Display the number of times a specific day appears between two dates

[rjfrederick]

I need a formula to find all the occurrence of Nov. 1 (11/01) as a string between two dates.
For example:

Start date: 11/05/2014
End Date: 11/05/2018
Date to list: Every November 1st

Result: 11/01/2015, 11/01/2016, 11/01/2017, 11/01/2018

Thank you in advance

 

[Legacy 143009]

This is your answer but it only returns the count. I don't think you can return comma separated array values in a cell with out VBA.

 

[kvsrinivasamurthy]

B5=Start date
C5=End date
Formula in D5

=IF(YEAR($B$5)+COLUMNS($D$5:D5)-IF(DATE(YEAR($B$5),11,1)<$B$5,0,1)<=YEAR($C$5),DATE(YEAR($B$5)+COLUMNS($D$5:D5)-IF(DATE(YEAR($B$5),11,1)<$B$5,0,1),11,1),"")

then drag across