# Have a column of dates (first of each month) and need a function to add a number if the first of the month falls between two dates

#### danielrussell2

##### New Member
I am trying to set up an excel to show income and expenses for each period, on a two week pay schedule.

I have the beginning date of the pay period in column A (starting at A8), the end of the pay period in column B (starting at B8). In column C I am trying to show what the income will be for that pay period...of course the salary pay will be the same for each pay period, but there's also once a month incomes to consider. The one I'm trying to add right now is paid the first of each month. So in a column over to the side (column Y), I made a list of all of the first of the month dates (06/01/18, 07/01/18, 08/01/18, etc.). I need a function that will add the amount of the once a month income (listed in cell C3) IF the date in column Y (the first of the month) falls within the date range in columns A and B (both start at row 8). I made a table below to reflect what my excel sheet looks like. Thanks in advance for your help!

 A B C D .. .. Y 1 2 2 week salary Once a month 3 Amount 1000 200 4 Day of Month 1 5 6 Monthly 7 Pay Date Period End Income 06/01/18 8 05/25 06/07 =B3+????? 07/01/18 9 06/08 06/21 08/01/18 10 06/22 07/05 09/01/18 11 07/06 07/19 10/01/18 12 07/20 08/02 11/01/18 13 08/03 08/16 12/01/18 14 08/17 08/30 01/01/19

<tbody>
</tbody>

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### danielrussell2

##### New Member
figured out another way to do this not using the Y column I set up:

=\$B\$3+(if(A8<=(B8-DAY(B8)+1),if(B8>=(B8-DAY(B8)+1),\$C\$3,0),0))

Replies
2
Views
1K
Replies
4
Views
314
Replies
3
Views
372
Replies
1
Views
525
Replies
2
Views
359

1,181,642
Messages
5,931,172
Members
436,780
Latest member
doknights

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back