Documentation/How Tos/Calc: TODAY function

CALC FUNCTIONS

Date & Time Functions

< Previous Section

Next Section >

FUNCTIONS

• Today
• Now
• Year
• Month
• Day
• Weekday
• Hour
• Minute
• Second
• Date
• Datevalue
• Time
• Timevalue
• Eomonth
• Edate
• Workday
• Networkdays
• Days
• Days360
• Daysinmonth
• Daysinyear
• Weeks
• Weeksinyear
• Weeknum
• Weeknum_add
• Months
• Years
• Isleapyear
• Eastersunday
• Yearfrac

< Previous Page

Next Page >

TODAY

Returns the current date

Syntax:

TODAY()

returns the current date (as a date-time serial number). TODAY is updated at every recalculation, for instance if a cell is modified.

Example:

TODAY()

when calculated at say 12 noon on 1Apr08 returns 1Apr08.