SOLVED

date populate based on what the user enters

Copper Contributor

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?

 

datawizsmh_0-1620324172376.png

 

3 Replies
best response confirmed by allyreckerman (Microsoft)
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.

Thank you! The second one works!

@datawizsmh , you are welcome

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
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.

View solution in original post