Function Problems

Use WORKDAY in WPS Spreadsheets to Find the Next Working Day

Olivia MillerOlivia Miller Nov 18, 2026 870 views

Question details

Find the working day immediately after the latest date in several columns.

Find the Next Working Day After the Latest Date in WPS Spreadsheets
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the result cell

Open the spreadsheet and select cell K10.

2
Enter the formula

Type =WORKDAY(MAX(H10:J10),1) in K10 and press Enter.

3
Format and copy the result

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.

Combine MAX and WORKDAY to Find the Next Working Day
Exclude holidays: Add a holiday range as the third argument. For example, use =WORKDAY(MAX(H10:J10),1,Holidays) if Holidays is a named range containing holiday dates.
WPS Spreadsheets

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. 1. Open your schedule: Open WPS Spreadsheets and select Open to load your workbook.
  2. 2. Select the output cell: Click K10, next to the dates in H10:J10.
  3. 3. Calculate the date: Enter =WORKDAY(MAX(H10:J10),1) and press Enter.
  4. 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.
Finds the latest date across multiple columnsSkips weekends and can exclude a holiday rangeWorks with Microsoft Excel formats such as XLSXLets you copy the formula down a schedule
QA img-9

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.