Forum Discussion
Solved
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?
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 Replies
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
