Setting up formula in Excel 2021

Occasional Visitor

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

@Merry1972 

Select A4.

Enter the formula

=SEQUENCE(5,,B3-4)

Select A4:A8 and apply the desired date format.