TODAY in WPS on Windows: Introduction

TODAY in WPS is a date function for multidimensional tables that returns the current date; 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

TODAY is a formula function in WPS Office for Windows multidimensional tables. It returns the current date in a formula field without requiring any arguments. It is useful for showing the current date in records, comparing dates, and building dynamic calculations with other functions.

Core capabilities include:

Create a formula field and use TODAY to insert the current date.
Check the function format and use the standard TODAY() syntax.
Combine TODAY with other functions for date-based logic.

Common use cases include due-date tracking, daily logs, and status checks. It helps reduce manual date entry and keeps date-based formulas current as data refreshes.

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 network connection is required for local formula editing; sign-in, sync, or online collaboration requires network access
Other	You need access to a multidimensional table and permission to add or edit formula fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office, open a multidimensional table, add a Formula field, and enter `TODAY()`

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Use `TODAY()` in a multidimensional table formula field to return the current date and combine it with other functions.	Excel `TODAY()` returns the serial number of the current date with the syntax `TODAY()` and can be used in date calculations.	Google Sheets `TODAY()` returns the current date with the syntax `TODAY()` and updates when the sheet recalculates.	Notion database formulas support `today()` to return the current date without a time component.	Acrobat mainly supports date fields and calculated values in PDF forms rather than a spreadsheet-style `TODAY()` function.
WPS Advantages	Advantage: WPS places the current-date function directly in a multidimensional table formula field, which fits record-based table workflows and date checks.	Compared with WPS: Excel focuses on traditional spreadsheet cell calculations rather than a record-based multidimensional table structure.	Compared with WPS: Sheets offers a similar date function, but its behavior is centered on online spreadsheet recalculation.	Compared with WPS: Notion supports date logic in database formulas, but it is not a spreadsheet-style formula interface.	Compared with WPS: Adobe is oriented toward PDF form date fields and calculations instead of table formula workflows.
Official Source	—	TODAY function in Excel	TODAY in Google Sheets	Notion formula syntax and functions	PDF form fields in Acrobat

Overall Conclusion
WPS TODAY is well suited to returning the current date inside multidimensional table records and using that value with field-based data. If your work is centered on traditional spreadsheet cells, Excel or Google Sheets may be a closer fit. If your workflow is database-page management, Notion is a relevant alternative, while Adobe is more suitable for PDF form scenarios.

Use Cases

No.	Scenario	Suitable For	Core Need	How WPS Helps
1	Daily record logging	Team members	Show the current date in each record	Enter `TODAY()` in a formula field to return the current date automatically
2	Due-date status checks	Project managers	Compare the current date with a deadline	Combine `TODAY()` with conditional functions
3	Date baseline in a table	Operations and admin users	Avoid inconsistent manual date entry	Use TODAY as a shared current-date reference
4	Reusable table templates	Users who duplicate tables often	Avoid resetting dates after copying a table	Keep `TODAY()` in the formula so the date updates automatically
5	Formula learning	New users	Learn a simple date function format	Start with the no-argument `TODAY()` syntax

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Core Writer, Spreadsheet, and Presentation apps	✅ Available	✅ Available
Basic use of TODAY in multidimensional tables	✅ Available	✅ Available
Some advanced PDF and extended tools	Limited or provided as listed on the plan page	✅ More advanced tools available
Cloud storage and some value-added benefits	Basic quota	Higher quota or more benefits

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
You only need basic functions such as TODAY in multidimensional tables	Free	The feature can be used directly without a membership requirement
You also need more PDF tools, cloud storage, or added office benefits	WPS Premium	Suitable for users who need broader benefits across workflows

WPS membership page: Subscribe now