Use WORKDAY in WPS Spreadsheets to Find the Next Working Day
Question details
Find the working day immediately after the latest date in several columns.

- Product
- WPS Spreadsheets and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A schedule stores the final shoot dates in columns H, I, and J, and the user wants the next working day in column K.
- Observed behavior
- The desired result is the next weekday after the latest date, excluding listed holidays if needed.
Check that the dates in H10:J10 are stored as spreadsheet dates rather than text. If holidays should be excluded, enter them as dates in a separate range.
Combine MAX and WORKDAY to Find the Next Working Day
Use this formula when the latest date is in H10:J10 and the result should appear in K10.
MAX selects the latest date in the range, and WORKDAY advances one working day, excluding Saturdays and Sundays.
Open the spreadsheet and select cell K10.
Type =WORKDAY(MAX(H10:J10),1) in K10 and press Enter.
If K10 displays a number, use the cell format menu to apply a date format. Drag K10's fill handle down to apply the formula to other rows.

Calculate the Next Working Day in WPS Spreadsheets
Use MAX and WORKDAY in WPS Spreadsheets to turn the latest shoot date in a row into the next working day.
- 1. Open your schedule: Open WPS Spreadsheets and select Open to load your workbook.
- 2. Select the output cell: Click K10, next to the dates in H10:J10.
- 3. Calculate the date: Enter =WORKDAY(MAX(H10:J10),1) and press Enter.
- 4. Apply the formula to other rows: Drag the fill handle from K10 down column K, and apply a date format if the results appear as numbers.

Frequently Asked Questions
How do I exclude holidays from the result?
Enter the holiday dates in a separate range and add that range as the third argument. For example, use =WORKDAY(MAX(H10:J10),1,$M$2:$M$10).
What happens if the latest date is a Friday?
WORKDAY normally skips Saturday and Sunday, so the formula returns Monday unless Monday is included in the holiday range.
Why does the result appear as a number?
Spreadsheet dates are stored as numbers. Select the result cell and use the cell format menu to change its format to Date.
Will the formula work if some date cells are blank?
Yes. MAX ignores blank cells, but the range should contain at least one valid numeric date. Dates stored as text may not be included.




