How to Use the WEEKDAY Function in WPS on Windows

Use the WEEKDAY function through 4 practical topics, all available without membership, and jump from the index to the task you need.

How-to Index

How-to Guide

1. Enter a basic WEEKDAY formula

Entry point: Open a worksheet in WPS Spreadsheet and type the formula in the target cell.

1. Open a worksheet that contains dates, or create a blank spreadsheet.
2. Select the cell where you want to show the result.
3. Type =WEEKDAY(A2) where A2 is the date cell.
4. Press Enter to return the weekday number.

Success Criteria

• The cell returns a numeric result.
• With the default setting, the result is between 1 and 7.

Tips While Using

• The referenced cell should contain a valid date value.
• The formula must start with =.

2. Set different return_type values

Entry point: Add the second argument in the WEEKDAY formula.

1. Select the result cell.
2. Type =WEEKDAY(A2,2) and press Enter.
3. If you want Monday to return 0 and Sunday to return 6, change it to =WEEKDAY(A2,3).
4. Compare the results and keep the numbering method that matches your worksheet logic.

Success Criteria

• With 2, Monday returns 1 and Sunday returns 7.
• With 3, Monday returns 0 and Sunday returns 6.

Tips While Using

• Different numbering systems affect later IF, filter, or conditional formatting rules.
• Use one consistent return_type in the same result column.

3. Reference date cells to calculate weekdays

Entry point: Use WEEKDAY with existing date cells in the worksheet.

1. Enter or paste dates into one column.
2. In the next column, type =WEEKDAY(A2,2).
3. Press Enter, then move the pointer to the lower-right corner of the result cell.
4. Drag the fill handle down to calculate weekday numbers for the whole column.

Success Criteria

• Each row returns the weekday number for its date.
• When the original date changes, the result updates automatically.

Tips While Using

• Check the cell reference before filling down.
• Use absolute references when a fixed reference is required.

4. Fix incorrect or unexpected results

Entry point: Review the formula, the parameter, and the date format.

1. Check whether the formula uses the correct brackets, comma, and cell reference.
2. Confirm that the referenced value is a date, not plain text.
3. Check whether return_type matches the numbering rule you want.
4. Edit the date or parameter and confirm the result again.

Success Criteria

• The formula no longer returns an error.
• The returned number matches the actual weekday rule you expect.

Tips While Using

• A text date may not calculate as expected.
• If your worksheet starts the week on Monday, check the second argument first.