WEEKDAY in WPS on Windows FAQ

Last updated:July 20, 2026

These FAQ items cover 4 common questions about date format, return types, batch calculation, and practical spreadsheet use.

FAQ

What do the numbers returned by WEEKDAY mean?

  1. If you omit the second argument, 1 means Sunday and 7 means Saturday.
  2. If the second argument is 2, 1 means Monday and 7 means Sunday.
  3. If the second argument is 3, 0 means Monday and 6 means Sunday.

Why is my WEEKDAY result incorrect?

  1. Check whether the referenced cell contains a valid date.
  2. Check whether return_type matches your worksheet rule.
  3. If the date is stored as text, convert it to a date value before calculating.

Can I use the WEEKDAY function for a whole date column?

  1. Enter the WEEKDAY formula in the first result cell.
  2. Confirm that the first result is correct.
  3. Drag the fill handle down to apply the same formula to the rest of the column.

How do I use the WEEKDAY function in WPS for attendance sheets or calendar analysis?

  1. Use WEEKDAY to convert each date into a weekday number.
  2. Combine the result with IF, filtering, or summary rules.
  3. Use the weekday numbers to mark workdays, weekends, or reporting groups.

Glossary

TermDefinition
serial_numberThe first argument in WEEKDAY. It is the date serial value or a cell reference that points to a date.
return_typeThe second argument in WEEKDAY. It controls how weekday numbers are assigned.
date serial numberThe internal numeric form used by spreadsheet software to store dates for calculation.
fill handleThe small square at the lower-right corner of a selected cell that lets you copy formulas down or across.