WEEKDAY in WPS on Windows: Introduction

WEEKDAY in WPS helps you return the weekday number for a date in a spreadsheet; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

The WEEKDAY function in WPS Spreadsheet for Windows returns the weekday number for a given date. It is useful for attendance sheets, shift planning, calendar analysis, and weekday-based formulas.

Key capabilities include:

Return the weekday number for a date, with the default result ranging from 1 for Sunday to 7 for Saturday.
Use return_type to change the numbering method for different business rules.
Reference date cells directly, or combine WEEKDAY with other date formulas.
Recalculate results when the referenced date changes.

Common use cases include attendance tracking, workday checks, weekly reports, and calendar templates.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory internet connection is required for local spreadsheet formulas; downloading and account actions require internet access
Other	You need permission to open or create a spreadsheet and edit formulas in cells

Download & Installation

Install WPS Office for Windows before using the WEEKDAY function.

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Spreadsheet, create or open a worksheet, and type `=WEEKDAY(` in a cell to confirm that the function prompt appears

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides `WEEKDAY(serial_number, return_type)` in WPS Spreadsheet. By default, it returns weekday numbers from 1 for Sunday to 7 for Saturday, and common `return_type` options include 2 and 3.	Excel provides `WEEKDAY(serial_number,[return_type])`, returns 1 for Sunday to 7 for Saturday by default, and supports additional return types.	Google Sheets provides `WEEKDAY(date, [type])` and supports multiple numbering systems for weekdays.	Notion formulas support date properties and the `day()` function, which returns the day of the week in database formulas, but this is not a cell-based spreadsheet function.	Acrobat supports PDF form fields and calculated values for forms, but it does not provide a spreadsheet WEEKDAY function.
WPS Advantages	Advantage: WEEKDAY works directly in spreadsheet cells with standard formula syntax, which fits batch fill, attendance sheets, and calendar analysis in tabular data.	Compared with WPS: Excel offers more documented return type options, while the basic weekday workflow is similar.	Compared with WPS: Google Sheets has similar syntax and explains date input behavior in more detail for web spreadsheets.	Compared with WPS: Notion can calculate weekday values in databases, but it is oriented to database properties rather than spreadsheet cells.	Compared with WPS: Acrobat is designed for PDF forms and field calculations, not spreadsheet-style date analysis.
Official Source	—	WEEKDAY function in Excel	WEEKDAY in Google Sheets	Formula syntax and functions in Notion	PDF form field properties in Acrobat

Overall Conclusion: WPS, Excel, and Google Sheets are closer alternatives for WEEKDAY because they all support spreadsheet date formulas. Notion and Adobe cover adjacent scenarios, but their official workflows focus on database formulas or PDF form calculations rather than worksheet-based weekday formulas.

Use Cases

No.	Scenario	Suitable for	Main need	How WEEKDAY helps
1	Attendance date classification	HR and admin teams	Quickly identify the weekday for each date	Return a weekday number and use it for labels or rules
2	Shift planning	Team managers	Separate weekdays from weekends	Combine WEEKDAY with `IF` or filtering rules
3	Weekly sales analysis	Operations and sales teams	Group records by weekday	Generate weekday numbers before sorting or summarizing
4	Calendar templates	Teachers, students, and office users	Avoid checking weekdays manually	Reference dates and calculate weekday numbers automatically

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Use basic spreadsheet functions such as WEEKDAY	✅	✅
Basic spreadsheet editing and calculation	✅	✅
More PDF, AI, and extended tools	Some features are limited	More related tools are available
Cloud storage	1 GB	20 GB or plan-based higher benefits

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Daily date calculations, attendance sheets, and schedule tracking	Free	WEEKDAY and other basic spreadsheet formulas are available without membership
Broader PDF, AI, or cloud-based office work	WPS Premium	Suitable when you need more tools beyond basic spreadsheet formulas

Membership page: Subscribe to WPS Premium