TODAY in WPS on Windows: Introduction

WPS TODAY is the current-date function in Spreadsheet on Windows; 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
Version limit	None	Available in WPS Spreadsheet on Windows
Membership limit	None	The function can be used directly

About This Feature

Overview

TODAY is a date function in WPS Spreadsheet that returns the current date and can be used in date calculations and analysis.

Main capabilities include:

Return the current date directly in a worksheet.
Work with other functions for date differences, period checks, and related calculations.
Support nested formulas and cross-sheet references in spreadsheet workflows.
Update results when the worksheet recalculates, which is useful for daily logs, trackers, and schedules.

Common use cases include daily reporting, due-date tracking, project timelines, and age or day-count calculations.

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	No mandatory network connection for local formula calculation; internet access is needed for download, installation, and account-related actions
Other	You need permission to open and edit a WPS Spreadsheet file

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Download the Windows installer, follow the on-screen steps, and launch WPS Office
Post-install check	Open Spreadsheet, enter `=TODAY()` in any cell, and press Enter to confirm that the current date is returned

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	The TODAY function returns the current date and supports direct entry, formula hints, nested formulas, and recalculation in spreadsheet workflows.	Excel `TODAY()` returns the serial number of the current date, takes no arguments, and is used in date calculations.	Google Sheets `TODAY()` returns the current date with no time component and updates on recalculation.	Notion formulas support `today()` in database formulas, but the workflow is centered on database properties rather than spreadsheet cells.	Acrobat focuses on PDF form date fields and calculations, not a spreadsheet-style TODAY function.
WPS Advantages	Advantage: WPS keeps the TODAY workflow in a familiar spreadsheet cell formula environment, including direct editing, nested formulas, and cross-sheet use.	Compared with WPS: Excel offers similar current-date logic, with official guidance emphasizing serial values and recalculation settings.	Compared with WPS: Google Sheets offers similar current-date logic, and its official help notes that TODAY is volatile and may affect spreadsheet performance.	Compared with WPS: Notion can return the current date, but it is designed for database formula properties instead of cell-based spreadsheet formulas.	Compared with WPS: Acrobat is oriented toward PDF form fields and form calculations instead of spreadsheet formula workflows.
Official Source	—	TODAY function in Excel	TODAY in Google Sheets	Notion formula syntax	PDF form date fields in Acrobat

Overall Conclusion
If your work depends on current-date formulas inside spreadsheet cells, WPS provides a direct and familiar workflow. Compared with Notion and Adobe, WPS is closer to standard spreadsheet use. Compared with Excel and Google Sheets, the core logic is similar, so the learning curve stays low.

Use Cases

No.	Scenario	Suitable For	Main Need	How WPS Helps
1	Auto-fill the current date in daily logs	General office users	Re-entering the date every day takes time	Enter `=TODAY()` to show the current date automatically
2	Calculate days until a deadline	Project and admin users	It is hard to check remaining days quickly	Subtract `TODAY()` from a target date
3	Track age or years of service	HR and data users	Results need to stay current over time	Combine TODAY with YEAR, DATEDIF, and related functions
4	Refresh date-based trackers	Finance and operations users	The date baseline needs to refresh when the file is recalculated	Use TODAY so date-based results update with recalculation

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Writer, Spreadsheet, and Presentation core apps	✅ Available	✅ Available
TODAY function	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Advanced PDF editing, more conversion tools, and extended benefits	Partly limited	✅ More items available
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
You only need basic spreadsheet functions such as TODAY	Free	The function itself is available without membership
You also need more PDF tools, conversion options, or more cloud storage	WPS Premium	A membership is more suitable for broader office needs

Membership page: Subscribe to WPS Premium
Review the available plans and benefit differences on the pricing page before you choose a plan.