A five-day packing sheet needs dates across the top. Set the start date once and let the headings follow it.
Spill one row of five dates
Enter June 8, 2026 as a real date in A2. Leave C4:G4 clear and put the formula in C4:
=SEQUENCE(1,5,$A$2,1)The first arguments request one row and five columns. The final 1 adds one day per column. Format the result as a date if the cells show serial numbers.

Illustrated calendar row. Format the numeric results as dates.
Move the start and verify the last day
With June 8 the row ends on June 12. Change A2 to June 9 and check that G4 becomes Saturday June 13. The formula includes weekends. For a working-day schedule, use a rule that accounts for excluded dates.

Illustrated boundary check. The formula advances by calendar days.
Keep the year visible somewhere on the sheet when the headings display only month and day.



