How to Use the WORKDAY Function in WPS on Windows

Use the WORKDAY function through 3 how-to topics, all available without membership; choose a topic from the How-to Index and follow the steps to complete the task.

How-to Index

How-to Guide

1. Enter the function from the Insert Function dialog box

Entry point: Formulas tab → Insert Function

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
3. Search for WORKDAY in the Insert Function dialog box.
4. Select the function and click OK.
5. Enter each argument in the Function Arguments dialog box.
6. Click OK to finish entering the function.

Success Criteria

• The selected cell now contains the WORKDAY function.
• A date result is returned after the arguments are entered.
• You can continue by copying the formula or adjusting the referenced ranges.

Tips While Using

• start_date should be a valid date.
• It is recommended to use an integer for days for working-day calculations.
• If you need to exclude holidays, reference a date range in the holidays argument.

2. Type the formula directly in a cell

Entry point: Cell → Formula bar

1. Select the cell where you want to enter the formula.
2. Type =WORKDAY(...) directly in the cell or in the formula bar.
3. Press Enter to confirm.
4. If you want to review the syntax, type =WORKDAY( and press F1 to open help.

Success Criteria

• The cell displays a calculation result.
• The full WORKDAY formula is visible in the formula bar.
• You can fill the formula across more cells for batch date calculations.

Tips While Using

• Separate arguments with commas.
• If an error value appears, check the date format and argument types first.
• When filling the formula across cells, confirm whether relative or absolute references are needed.

3. Review the syntax and argument details

Entry point: Formulas tab → Insert Function

1. Click Insert Function on the Formulas tab.
2. Enter WORKDAY in the search box.
3. Select the function and review the syntax: WORKDAY(start_date, days, [holidays]).
4. Open the related help entry to read more details.

Success Criteria

• You can see the WORKDAY function name and syntax structure.
• You have confirmed the meaning of required and optional arguments.
• You can return to the sheet and enter the formula.

Tips While Using

• holidays is optional and can be left blank if holiday exclusions are not needed.
• If dates are stored as text, the calculation result may be incorrect.