Formula extract the dates

[jevi]

Hi All,

I have a start date 01/01/2020 and an end date 13/11/2020. I did this formula so it can give me all the dates in H6 but it stops till 11/11/2020 and not 13/11/2020. So I can't understand why. Maybe C2 goes in the empty rows?
C2 = START DATE
C3 = END DATE
H6 = THE ROW WHERE I WANT THE DATE TO BE FROM H6 AND ON.

=IF($C$2+ROW(C2)>=$C$3;"";H6+1)

THANK YOU,

 

[Peter_SSs]

Try this min H6, copied down

=IF(ROWS(H$6:H6)>C$3-C$2+1;"";C$2+ROWS(H$6:H6)-1)

 

[jevi]

It worked like a treat. thank you

 

[Peter_SSs]

You are welcome. Thanks for the follow-up.