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

Use WORKDAY.INTL through 4 how-to topics, all available without membership; start from the How-to Index to jump to the steps you need.

How-to Index

How-to Guide

1. Enter a basic WORKDAY.INTL formula

Entry point: Open WPS Spreadsheet, select the target cell, and type the function in the cell or formula bar.

1. Open your spreadsheet and select the cell where you want the result to appear.
2. Type =WORKDAY.INTL(.
3. Enter the start date and the number of workdays.
4. Type the closing parenthesis and press Enter.

Success Criteria

• The cell returns a date result.
• When you select the cell again, the full formula appears in the formula bar.

Tips While Using

• The start date should be a valid date value.
• The workday count can be positive, negative, or 0, and each option changes the calculation direction.

2. Set a custom weekend rule

Entry point: Enter a weekend number or weekend string in the third argument of WORKDAY.INTL.

1. Start with a basic formula structure such as =WORKDAY.INTL(A2,B2,.
2. In the third argument, enter a weekend number or a string that defines working and non-working days.
3. Complete the formula and press Enter.
4. Check whether the returned date matches your business calendar.

Success Criteria

• Changing the third argument changes the result date.
• With the same start date and workday count, different weekend rules can return different results.

Tips While Using

• If the weekend rule is entered incorrectly, the result may not match your expectation.
• After changing the rule, test it with a known sample date.

3. Reference a holiday range in the calculation

Entry point: Reference a holiday cell range in the fourth argument of WORKDAY.INTL.

1. Prepare a list of holiday dates in the worksheet.
2. Enter or edit the formula and select the holiday range in the fourth argument.
3. Press Enter to finish the calculation.
4. Update the holiday list and check whether the result recalculates automatically.

Success Criteria

• The formula skips dates included in the holiday range.
• After the holiday list is updated, the result recalculates automatically.

Tips While Using

• Values in the holiday range should be valid dates.
• If the range contains text-formatted dates, convert them to date values first.

4. Use it with cross-sheet references and nested formulas

Entry point: Reference cells from other worksheets in the formula, or combine WORKDAY.INTL with functions such as DATE or TEXT.

1. Select the result cell and enter a WORKDAY.INTL formula.
2. Replace the start date, day count, or holiday range with references from another worksheet as needed.
3. Combine it with other functions when you need a more complete formula.
4. Press Enter and confirm that the result updates when referenced data changes.

Success Criteria

• The formula returns a valid date result.
• When referenced cells change, the result updates accordingly.

Tips While Using

• For cross-sheet references, confirm that the worksheet name and cell range are correct.
• If the nested formula is long, review the parentheses in the formula bar.