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


Select A4.

Enter the formula


Select A4:A8 and apply the desired date format.