Displays the current date.
The TODAY function is useful when you need to have the current date displayed in a table. It is also useful for calculating intervals using the DATEDIF function.
Syntax
TODAY()
The function has no arguments.
Examples
| Formula | Description | Result |
| =TODAY() | Returns the current date. | 12 Jan 2020 |
| =DATEDIF(TODAY(), 25 Dec 2022, “D”) | Returns the number of days until Christmas, if the current date is 8 Aug 2022, this returns 139 | 139 |
KC Integrations 