Calc TODAY function

Returns the serial number of the current date.

Help CentreFunctions & Formulas

For a full list of available calculation functions, please read What calculation functions are supported.

This article describes the formula syntax and usage of the TODAY function and is applicable to both the RPA and Cloud Automate's calculate functions.

Description

Returns the serial number of the current date.


Syntax

TODAY()

The TODAY function syntax has no arguments.


Example

FormulaDescriptionResult
=TODAY() Returns the current date. 2022-03-13
=DAY(TODAY())Returns the current day of the month (1 - 31).1
=MONTH(TODAY())Returns the current month of the year (1 - 12). For example, if the current month is May, this formula returns 5.12

Errors

For a full list of formula errors, please read Formula errors.


Related functions

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.