Difference between revisions of "Documentation/How Tos/Calc: TODAY function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
(See also:)
Line 16: Line 16:
 
'''[[Documentation/How_Tos/Calc: DATE function|DATE]]''',
 
'''[[Documentation/How_Tos/Calc: DATE function|DATE]]''',
 
'''[[Documentation/How_Tos/Calc: TIME function|TIME]]'''
 
'''[[Documentation/How_Tos/Calc: TIME function|TIME]]'''
 +
 +
'''[[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]'''
  
 
'''[[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]'''
 
'''[[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]'''
  
'''[[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]'''
+
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
 +
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]

Revision as of 07:08, 12 September 2008


TODAY

Returns the current date and time

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.

See also:

NOW, DATE, TIME

Date & Time overview

Date & Time functions

Functions listed alphabetically, Functions listed by category

Personal tools