WPS Features
Resources
Free AI Tools
Docs Center

How to Use the WORKDAY.INTL Function in WPS on Windows

Last updated:July 14, 2026

Use WORKDAY.INTL in WPS on Windows with 3 practical topics; all 3 are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Insert it from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Review the syntax and argumentsFree

How-to Guide

1. Insert it from the Insert Function dialog

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.INTL in the dialog box.
  4. Select the function and click OK.
  5. Enter the required arguments in the Function Arguments dialog box.
  6. Click OK to finish inserting the formula.

Success Criteria

  • The cell contains the WORKDAY.INTL function.
  • You can enter the start date, day count, weekend rule, and holiday argument normally.

Tips While Using

  • Use English commas as argument separators.
  • For date arguments, use valid dates or cell references that contain dates.

2. Type the formula directly in a cell

Entry point: Cell → Formula bar

  1. Select the target cell.
  2. Type =WORKDAY.INTL(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want to review argument hints, type the opening parenthesis first and continue filling in the arguments.

Success Criteria

  • The cell returns a date result or shows an editable formula expression.
  • The full formula is visible in the formula bar.

Tips While Using

  • If the result shows an error, check the date format, weekend argument, and holiday reference range.
  • When filling the formula across rows, review relative and absolute references.

3. Review the syntax and arguments

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Search for WORKDAY.INTL.
  3. Select the function and review the syntax WORKDAY.INTL(start_date, days, [weekend], [holidays]).
  4. Confirm the purpose of each argument before completing the formula.

Success Criteria

  • You can see the full syntax and argument order.
  • You can distinguish required arguments from optional ones.

Tips While Using

  • The weekend argument can use either a number or a string pattern.
  • The holidays argument is easier to manage when it references a cell range that contains dates.