How to Use WORKDAY in WPS Spreadsheet to Automatically Schedule the Next Weekday
Question details
The user wants to automatically return the next business day in a spreadsheet without manually changing formulas on Fridays or Mondays.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- Scheduling tasks, due dates, or follow-ups that should always fall on the next weekday.
- Observed behavior
- The next business day should appear automatically, skipping Saturday and Sunday and optionally skipping listed holidays.
Make sure your date cells use a valid date format and that your WPS Spreadsheets version supports the WORKDAY function. If you plan to exclude company holidays, prepare a range of holiday dates in the same sheet or a named range.
Use =WORKDAY(TODAY(),1) to Return the Next Weekday
Best for general next-business-day scheduling when skipping weekends is enough.
WORKDAY treats Saturday and Sunday as non-working days by default. The first argument can be a date value or cell reference, and TODAY() makes the result update automatically with the current date.
Open WPS Spreadsheets and click the cell where you want the next weekday date to appear.
Type =WORKDAY(TODAY(),1) into the selected cell and press Enter.
If the cell shows a serial number instead of a date, right-click the cell, choose Format Cells, select Date, and pick a date format.
Exclude Holidays with a Holiday Range in WORKDAY
Use this when you need to skip company or public holidays in addition to weekends.
Schedule the Next Weekday Automatically in WPS Spreadsheets
Use the WORKDAY function in WPS Spreadsheets to calculate the next business day from the current date, skip weekends, and optionally exclude holiday dates—without manual formula changes.
- 1. Open WPS Spreadsheets: Launch WPS Office and open a new or existing spreadsheet.
- 2. Enter the WORKDAY formula: Click the target cell, type =WORKDAY(TODAY(),1) and press Enter.
- 3. Add holiday exclusions if needed: Create a holiday list and use =WORKDAY(TODAY(),1,Holidays) or =WORKDAY(TODAY(),1,A2:A10).
- 4. Save or share the workbook: Save the workbook in .xlsx format to keep full compatibility with Microsoft Excel.
Frequently Asked Questions
What does =WORKDAY(TODAY(),1) do in WPS Spreadsheets?
It returns the next working day after today, automatically skipping Saturday and Sunday. The result updates whenever the workbook recalculates.
How do I exclude holidays from the WORKDAY result?
Enter the holiday dates in a range such as A2:A10, then use =WORKDAY(TODAY(),1,A2:A10). You can also select the range, name it Holidays in the Name Box, and use =WORKDAY(TODAY(),1,Holidays).
Why does WORKDAY show a number instead of a date?
The cell is likely formatted as General or Number. Right-click the cell, choose Format Cells, select Date, and pick a date format.
Does the WORKDAY function in WPS Spreadsheets work like it does in Microsoft Excel?
Yes. WPS Spreadsheets supports the WORKDAY function with the same arguments and .xlsx compatibility, so formulas behave consistently when files are opened in either application.
Can I calculate the next weekday from a date other than today?
Yes. Replace TODAY() with a cell reference or static date value, for example =WORKDAY(A2,1) or =WORKDAY(DATE(2025,1,1),1).
