How to Use the WEEKDAY Function in WPS on Windows

There are 3 how-to topics for using WEEKDAY, and all 3 are available without membership; choose the method you need from the index below.

How-to Index

How-to Guide

1. Insert it from the Insert Function dialog

Entry point: Formula 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 Formula tab.
3. Search for WEEKDAY in the Insert Function dialog box.
4. Select the function and click OK.
5. Enter each parameter in the Function Arguments dialog box.
6. Click OK to finish inserting the function.

Success Criteria

• The selected cell now contains the WEEKDAY function.
• After the parameters are filled in, the cell returns a weekday number.

Tips While Using

• Search with the English function name WEEKDAY.
• The date argument should be a valid date or a recognizable date serial number.

2. Type the formula directly in a cell

Entry point: Worksheet cell → Formula bar

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

Success Criteria

• The cell shows the WEEKDAY calculation result.
• The formula bar shows the full function expression.

Tips While Using

• Use English commas to separate parameters.
• If the result looks incorrect, first check whether the referenced cell contains a valid date.

3. Review the syntax and parameter details

Entry point: Formula tab → Insert Function

1. Click Insert Function on the Formula tab.
2. Enter WEEKDAY in the search box.
3. Select the function and review the syntax WEEKDAY(serial_number, [return_type]).
4. Click the help link for the function to read more details.

Success Criteria

• You can see the WEEKDAY syntax and parameter structure.
• You can distinguish the required parameter from the optional parameter.

Tips While Using

• serial_number usually represents a date serial value.
• return_type changes the weekday numbering method, so confirm your reporting rule before setting it.