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]

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>

 

[danielrussell2]

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))