Description
The TODAY
function evaluates to the current date.
Usage
TODAY()
Remarks
When working offline, the TODAY()
function will evaluate to the date in the
Examples
Calculating ages
The TODAY
can be used with together with the YEARFRAC function to calculate ages from birthdates. For example:
FLOOR(YEARFRAC(DOB, TODAY()))
Calculating delays
You can also use the DAYS function to find the number of days between today and some event in the past. For example, if you are providing emergency case management, you might want to know how long an urgent case has been open. If you have a date field with the code CASE_OPENED
, you could calculate the number of days the case has been opened using the formula:
DAYS(TODAY(), CASE_OPENED)
Note that the order of arguments for YEARFRAC
and DAYS
is switched. We have inherited this infelicity from Excel.