Forum Discussion
Merry1972
Nov 15, 2021Copper Contributor
Setting up formula in Excel 2021
I am trying to do a formula where when if I enter a date in cell b3, I want it to include that date and go back 4 days and automatically fill those dates into A4-A8
1 Reply
Select A4.
Enter the formula
=SEQUENCE(5,,B3-4)
Select A4:A8 and apply the desired date format.