TODAY() – Returns the current date

The TODAY() function returns the current date. The format of the date is based on your MathGrid settings.

Syntax

TODAY()

This function takes no arguments.

Basic example

TODAY()

Returns the current date.

Example outputs (depending on date format settings):
If current date is January 15, 2025:

Date format "dd/mm/yyyy" → "15/01/2025"
Date format "mm-dd-yyyy" → "01-15-2025"
Date format "yyyy.mm.dd" → "2025.01.15"
Date format "d/m/yy" → "15/1/25"

Key features

Automatic updates: The date is dynamic and updates to reflect the current day each time the formula is recalculated (e.g., when the document is opened or cells are modified).
Format-dependent: The output format is determined by the "Date Format Settings" in MathGrid's settings panel.

Practical uses

Displaying the current date on reports or documents.
Calculating ages or durations by subtracting a past date from TODAY() (e.g., DAYS(TODAY(), "01/01/2000")).
Tracking deadlines or event dates relative to the current day.
Timestamping entries or logs automatically.

Common mistakes

Adding arguments: The function TODAY() does not accept any arguments. Using it like TODAY(T1A1) will result in an error.
Expecting a specific format: Remember the output format is controlled globally in the MathGrid settings, not within the TODAY() function itself.