DAY in WPS on Windows: Introduction

WPS DAY is a date extraction function in multidimensional tables on Windows; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	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 DAY function in WPS multidimensional tables extracts the day portion from a date value and returns the corresponding day number. It is useful when you need to split date fields, build date-based dimensions, or combine date results with other formulas in record-based tables.

Core capabilities include:

Use DAY in a formula field to extract the day from a date.
Fill in the function parameter in the expected format.
Combine DAY with other formulas for more flexible date processing.

Common scenarios include attendance logs, project schedules, and activity tracking. It helps when you need to pull the day number from a full date or keep date-based calculations updated automatically in a table.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	An internet connection is recommended for installation and account sync; local formula editing does not require a constant connection
Other	You need access to open a multidimensional table and permission to add fields and edit formulas

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office, enter a multidimensional table, and confirm that Add Field and Formula options are available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Use DAY in a formula field inside a multidimensional table to extract the day from a date value and combine it with other formulas.	Excel DAY returns the day of a date as an integer from 1 to 31.	Google Sheets DAY returns the day of the month for a given date in numeric format.	Notion supports date formulas, but `day()` returns the day of the week, while `date()` returns the day of the month, so the model differs from spreadsheet functions.	Adobe Acrobat Sign supports calculated fields in forms and can format results as dates, numbers, or currency, but it does not provide a spreadsheet-style DAY function page.
WPS Advantages	Advantage: You can add a formula field directly to record-based tables and keep results updated with table data. Distinct: The workflow fits table-style data management and field-based calculations.	Compared with WPS: Focuses on worksheet formulas and cell-based calculation.	Compared with WPS: Also supports date extraction, with a stronger focus on online spreadsheet workflows.	Compared with WPS: Uses a database formula model with different date function names and return logic.	Compared with WPS: Focuses on calculated fields in signing forms rather than general spreadsheet-style date functions.
Official Source	—	Excel DAY function	Google Sheets DAY	Notion formula syntax	Adobe calculated fields

Overall Conclusion
If your main goal is to extract the day number from dates in record-based tables, WPS DAY fits a field-oriented workflow well. Excel and Google Sheets provide standard spreadsheet function behavior, while Notion and Adobe are better matched to their own database or form scenarios.

Use Cases

No.	Scenario	Suitable For	Main Need	How DAY Helps
1	Attendance date splitting	HR and admin teams	Extract the day number from full dates	Use DAY in a formula field to generate a day column
2	Schedule tracking	Operations and project teams	Filter or group records by day of month	Extract the day first, then combine it with other fields
3	Data cleanup	Table maintainers	Turn full dates into easier-to-use numeric values	Split dates into day values for later logic
4	Conditional formulas	Advanced users	Use date results inside IF and similar formulas	Pass the DAY result into other formulas
5	Automatic record updates	Collaborative teams	Avoid manual date splitting	Keep formula results refreshed with source data

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Core Writer, Spreadsheet, and Presentation apps	✅ Available	✅ Available
Basic formula use in multidimensional tables, including DAY	✅ Available	✅ Available
Some advanced PDF and extended tools	Depends on the feature	✅ More advanced tools are available
Cloud storage and selected value-added benefits	Basic allocation	Higher allocation or more benefits

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Everyday DAY usage and basic table work	Free	It covers common date extraction and formula editing needs
Broader office work with more PDF, cloud, or added tools	WPS Premium	Better for users who need expanded office capabilities

WPS membership page: Subscribe now