Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Excel want to have sequential numbers in a column

Copper Contributor

creating a list of duties for several friends. The duties occur on each Saturday (bring the drinks after golf), so I want to create a list of dates occurring on each Saturday down the first column in the spreadsheet. I see how to do it for daily date "spreads". How to do it for weekly each seventh day? Thanks.

2 Replies

@Bill_Goodale 

 

There are fancy ways to do this--to specify the 7th day of the week--but this also seems like a case for simplicity.

 

Enter the first Saturday of the year into cell A2 manually. E.g., 1/6/2024  Then in the next cell, =A2+7 and copy that formula down till time ends. It will continue to come up with all Saturdays.

@Bill_Goodale 

You can use SEQUENCE to produce an array of dates:

=LET(
    start, DATE(2023, 12, 16),
    step, 7,
    dates, 52,
    SEQUENCE(dates, , start, step)
)

This example produces 52 dates but you can adjust it and the start date as needed.