Setting up formula in Excel 2021

%3CLINGO-SUB%20id%3D%22lingo-sub-2966049%22%20slang%3D%22en-US%22%3ESetting%20up%20formula%20in%20Excel%202021%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2966049%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20do%20a%20formula%20where%20when%20if%20I%20enter%20a%20date%20in%20cell%20b3%2C%20I%20want%20it%20to%20include%20that%20date%20and%20go%20back%204%20days%20and%20automatically%20fill%20those%20dates%20into%20A4-A8%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2966049%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2966251%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20up%20formula%20in%20Excel%202021%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2966251%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1219066%22%20target%3D%22_blank%22%3E%40Merry1972%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20A4.%3C%2FP%3E%0A%3CP%3EEnter%20the%20formula%3C%2FP%3E%0A%3CP%3E%3DSEQUENCE(5%2C%2CB3-4)%3C%2FP%3E%0A%3CP%3ESelect%20A4%3AA8%20and%20apply%20the%20desired%20date%20format.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.