WPS Spreadsheet: Generate Weekly Saturday Dates in an Excel Column
Question details
The user needs to generate a recurring list of Saturday dates in a spreadsheet column.
- Product
- WPS Spreadsheet
- Device & OS
- not provided
- Scenario
- A weekly schedule, duty roster, or task list requires dates that repeat every seven days.
- Observed behavior
- The user wants a column containing sequential Saturday dates, such as 52 weekly dates.
Choose the first Saturday and decide how many weekly dates you need. Set the destination cells to a Date format so the generated serial numbers display as calendar dates.
Generate 52 weekly Saturdays with the SEQUENCE function
Use this method when your WPS Spreadsheet version supports dynamic array functions and you want the full date list created at once.
SEQUENCE creates a vertical list beginning with the selected start date and increases each row by seven days. Replace the start date or count to match your schedule.
Open the worksheet, click the cell where the list should begin, such as A2, and make sure the cells below it are available for the results.
In the selected cell, enter =SEQUENCE(52,,DATE(2023,12,16),7) and press Enter. The formula creates 52 dates, starting on Saturday, December 16, 2023, with a seven-day interval.
Change 52 to the required number of weeks and replace DATE(2023,12,16) with the date of the first Saturday. Use the Home tab's number-format controls if the results do not display as dates.
Fill a Saturday date down with a seven-day formula
Use this compatible approach when SEQUENCE is unavailable or when you prefer to control each row with a standard formula.
Create recurring Saturday schedules in WPS Spreadsheet
WPS Spreadsheet can generate weekly date columns with SEQUENCE or a standard +7 formula. Enter the starting Saturday, set the interval to seven days, and fill or spill the results into your schedule.
- 1. Open WPS Spreadsheet: Launch WPS Office and open an existing workbook or select Spreadsheet to create a new worksheet.
- 2. Choose the starting cell: Click the cell where the weekly date list should begin, such as A2.
- 3. Generate the dates: Enter =SEQUENCE(52,,DATE(2023,12,16),7), or enter the first Saturday and use =A2+7 in the next row.
- 4. Fill or format the list: Press Enter, fill the formula down if needed, and use the Home tab's number-format controls to display the values as dates.
Frequently Asked Questions
How do I generate 52 Saturdays in WPS Spreadsheet?
Select the first output cell and enter =SEQUENCE(52,,DATE(2023,12,16),7). Press Enter to create 52 weekly dates. Change the date and number 52 as needed.
What formula adds one week to a date?
Enter =A2+7 in the cell below the date in A2. Copy the formula downward to create dates one week apart.
Why are my generated dates not Saturdays?
Check the starting date first. The seven-day interval preserves the weekday only when the initial date is a Saturday.
Can I change the number of weekly dates generated by SEQUENCE?
Yes. Replace the first argument in the formula. For example, =SEQUENCE(20,,DATE(2024,1,6),7) generates 20 dates beginning on January 6, 2024.
How can I show the results as dates instead of numbers?
Select the generated cells, open the Home tab, and choose a Date format from the Number Format controls. The underlying seven-day sequence remains unchanged.
