WPS Features
Resources
Free AI Tools
Docs Center

How to Use the TODAY Function in WPS on Windows

Last updated:July 14, 2026

This how-to guide includes 3 operation topics for the TODAY function in WPS Spreadsheet, with 3 available without membership and 0 membership-related items.

How-to Index

No.TopicMembership Requirement
11. Insert the function from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Check the syntax and help detailsFree

How-to Guide

1. Insert the function from the Insert Function dialog

Entry: Formula tab → Insert Function, or the fx button in the formula bar

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
  3. Search for TODAY in the Insert Function dialog.
  4. Select the function and click OK.
  5. Confirm the function content in the function dialog.
  6. Click OK to finish entering the function.

Success Criteria

  • The target cell contains the TODAY function.
  • The cell shows the current date result.
  • You can continue formatting the cell or copying the formula.

Tips While Using

  • The TODAY function returns the current date.
  • Use standard English characters when entering the function name.

2. Type the formula directly in a cell

Entry: A worksheet cell or the formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =TODAY() directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If needed, review the prompt shown after typing the opening parenthesis.

Success Criteria

  • The cell shows the current date.
  • The formula bar shows the full formula =TODAY().
  • The formula can be copied to other cells.

Tips While Using

  • The TODAY function does not require any arguments.
  • If the result appears as a number, change the cell format to a date format for easier reading.

3. Check the syntax and help details

Entry: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Enter TODAY in the search box.
  3. Select the function and review the syntax TODAY().
  4. Click the help link for more details about the function.

Success Criteria

  • You can see the standard TODAY syntax.
  • You have confirmed that the syntax is TODAY().
  • You can return to the worksheet and continue entering the formula.

Tips While Using

  • The TODAY syntax does not include arguments.
  • The help entry is useful when learning the function or checking an input issue.