How to Use the WORKDAY Function in WPS on Windows

Last updated:July 20, 2026

Use WORKDAY through 4 practical topics that cover entering the function, filling in arguments, excluding holidays, and combining references; 4 items are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Enter the WORKDAY functionFree
22. Fill in the start date and workday countFree
33. Add the holiday argumentFree
44. Use cell references and nested formulasFree

How-to Guide

1. Enter the WORKDAY function

Entry point: Formula tab → formula bar

  1. Open WPS Spreadsheet and select the target cell.
  2. Type = to start a formula.
  3. Type WORKDAY(.
  4. Review the syntax prompt, then continue entering arguments.

Success Criteria

  • On-screen result: The cell enters formula-editing mode and shows WORKDAY-related guidance.
  • Next action available: You can continue entering the start date, workday count, and optional holiday argument.

Tips While Using

  • Common mistake: If you do not start with =, the content may be treated as plain text.
  • Environment note: The formula must be entered in an editable cell.

2. Fill in the start date and workday count

Entry point: Type directly in the selected cell

  1. In the target cell, type =WORKDAY(.
  2. Enter the start date argument, or reference a cell that contains a date.
  3. Type a comma, then enter the number of working days.
  4. Type the closing parenthesis and press Enter.

Example: =WORKDAY(A2,10)

Success Criteria

  • On-screen result: The cell returns a date result.
  • Next action available: You can copy the formula or edit the arguments to recalculate.

Tips While Using

  • Common mistake: If the start date is stored as text, the result may be incorrect.
  • Common mistake: If the workday count is not an integer, the decimal part may affect expectations, so an integer is recommended.

3. Add the holiday argument

Entry point: Formula bar → continue after the existing arguments

  1. Enter the start date and workday count first.
  2. Type a comma after the second argument.
  3. Select a holiday date range, or enter an array constant that contains dates.
  4. Press Enter to confirm the result.

Example: =WORKDAY(A2,10,F2:F10)

Success Criteria

  • On-screen result: The returned date excludes the dates listed in the holiday range.
  • Next action available: When you update the holiday range, the result updates as well.

Tips While Using

  • Common mistake: Non-date values inside the holiday range may affect the result.
  • Environment note: Keeping holidays in one continuous date range makes maintenance easier.

4. Use cell references and nested formulas

Entry point: Formula bar

  1. Reference the start date cell and the workday count cell in the formula.
  2. Add a holiday range reference if needed.
  3. Place WORKDAY inside a longer business formula, or combine it with other functions.
  4. Change the source data and confirm that the result updates automatically.

Example: =WORKDAY(B2,C2,H2:H20)

Success Criteria

  • On-screen result: The result date changes when the source data changes.
  • Next action available: You can fill the formula down to more rows for batch scheduling.

Tips While Using

  • Common mistake: If a moved range is not updated with the correct absolute reference, the result may shift unexpectedly.
  • Environment note: For cross-sheet references, make sure the referenced sheet contains valid date values.