SOLVED

# date populate based on what the user enters

Copper Contributor

# date populate based on what the user enters

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?

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

# Re: date populate based on what the user enters

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.

# Re: date populate based on what the user enters

Thank you! The second one works!

# Re: date populate based on what the user enters

@datawizsmh , you are welcome

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

# Re: date populate based on what the user enters

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.