Spread Formula Reference
TODAY

This function returns the date and time of the current date.

Syntax

TODAY()

Arguments

This function does not accept arguments.

Remarks

If you use this function in a date-time cell (DateTimeCellType), the cell formats the value using the date format settings.

This function is updated only when the spreadsheet or cell containing the function is recalculated. This is a volatile function with version 2.5 or later.

Data Types

Does not accept data. Returns a DateTime object.

Examples

If today is the 14th of November in the year 2003, then

TODAY() gives the result November 14, 2003 12:00:00AM

Version Available

This function is available in product version 1.0 or later. This function is a volatile function in version 2.5 or later.

See Also

DATE | DAY | NOW | TIME | Date and Time Functions

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options