Nov 15 2021 07:41 AM
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
Nov 15 2021 08:14 AM
Select A4.
Enter the formula
=SEQUENCE(5,,B3-4)
Select A4:A8 and apply the desired date format.