Forum Discussion
Excel want to have sequential numbers in a column
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...
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.