date populate based on what the user enters

[datawizsmh]

Hello, I am trying to have the date populate based on what the user enters (see below). I used the formula =IF(ROW(A1)>=$B$2,"",DAYS($A$4,ROW(A1))) but as you can see it includes dates past 4/13, and I have to manual reference 4/21. Is it possible to have this automatically?

[#2 · Accepted solution]

@datawizsmh 

If you are on Excel 365 that could be

=SEQUENCE(B1-D1+1,1,B1,-1)

If not

=IF(ROW()-ROW($B$2)>$B$1-$D$1+1,"",$B$1-ROW()+ROW($B$2)+1)

could work. Please check in attached.

[#3]

Thank you! The second one works!

[#4]

@datawizsmh , you are welcome