Fill series of dates with a difference of days upto a specific date

Hi,

Friends

i need some help i want to fill series of dates with specific difference that is if cell a1 is having 15/10/2017 date and cell B1 is having 15/01/2018 in cell C1 i want to add 15 days from A1 cell that is in C1 it should reflect 31/10/2017,C2 cell 15/11/2017,C3 cell 30/11/2017 and fill the series as 15 days increment and should not cross the date in cell B1 that is 15/01/2018 date

kindly help me to sort out this thing



thanks in advance

Try in C1:

=IF(IF(DAY($A$1)>=15,EOMONTH($A$1,0),$A$1-DAY($A$1)+15)<=$B$1,IF(DAY($A$1)>=15,EOMONTH($A$1,0),$A$1-DAY($A$1)+15),"")

in C2:

=IF(C1="","",IF(IF(DAY(C1)>15,C1+15,EOMONTH(C1,0))<=$B$1,IF(DAY(C1)>15,C1+15,EOMONTH(C1,0)),""))

c1 formula shows value