How to Use the WORKDAY Function in WPS on Windows

Last updated:July 23, 2026

Use WORKDAY through 3 how-to topics, all available without membership in Multi-Dimensional Tables; choose a task from the How-to Index, then enter the formula and verify the returned result.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and enter WORKDAYFree
22. Set the WORKDAY parameter formatFree
33. Use a WORKDAY example in a business scenarioFree

How-to Guide

1. Create a formula field and enter WORKDAY

Entry: Add Field → Formula

  1. Open the WPS Multi-Dimensional Table that you want to edit.
  2. Click the Add Field button.
  3. Select Formula as the field type.
  4. Enter a WORKDAY-related formula in the formula editor.
  5. Click Confirm to save the field and check whether the calculated result appears.

Success Criteria

  • Interface result: A new formula field appears in the table.
  • Next action available: You can continue editing the formula or review the returned date for each record.

Tips While Using

  • Common mistake: Using a plain text field instead of a formula field prevents the function from being entered.
  • Environment note: You need edit permission for the current table.

2. Set the WORKDAY parameter format

Entry: Formula Editor → Enter function parameters

  1. Enter WORKDAY( in the formula editor.
  2. Fill in the start date parameter in order.
  3. Enter the number of working days to move forward or backward.
  4. Add a holiday range or holiday date values if needed.
  5. Check the parentheses and separators, then save the formula.

Success Criteria

  • Interface result: The function syntax is complete in the formula editor with no obvious format errors.
  • Next action available: After saving, you can see a date result in the field.

Tips While Using

  • Common mistake: An incorrect date format or parameter order can cause an error result.
  • Environment note: Holiday parameters should use valid date values.

3. Use a WORKDAY example in a business scenario

Entry: Formula field result column

  1. Choose a business table that contains a start date.
  2. Create a new formula field and enter the appropriate WORKDAY formula.
  3. Link the project duration or offset days to existing fields.
  4. Add holiday parameters when needed to get a result closer to the actual schedule.
  5. Check whether each record updates automatically when source data changes.

Success Criteria

  • Interface result: Different records return their own working-day dates.
  • Next action available: When you change the source date or day-count field, the result updates accordingly.

Tips While Using

  • Common mistake: Mixing up calendar days and working days can lead to unexpected results.
  • Environment note: If the business rule is complex, test with a small set of records first.