TODAY function evaluates to the current date.
When working offline, the
TODAY() function will evaluate to the date in the
TODAY can be used with together with the YEARFRAC function to calculate ages from birthdates. For example:
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:
Note that the order of arguments for
DAYS is switched. We have inherited this infelicity from Excel.