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

From Apache OpenOffice Wiki
Jump to: navigation, search
 
(One intermediate revision by one other user not shown)
Line 5: Line 5:
 
|parttitle=[[Documentation/How_Tos/Calc:_Date_%26_Time_functions|<div  style="font-size: 140%;">Date & Time Functions]]
 
|parttitle=[[Documentation/How_Tos/Calc:_Date_%26_Time_functions|<div  style="font-size: 140%;">Date & Time Functions]]
 
|ShowNextPage=block
 
|ShowNextPage=block
|NextPage=Documentation/How_Tos/Calc:_TODAY_function
+
|NextPage=Documentation/How_Tos/Calc:_NOW_function
 
|ShowPrevPage=block
 
|ShowPrevPage=block
|PrevPage=Documentation/How_Tos/Calc:_DVARP_function
+
|PrevPage=Documentation/How_Tos/Calc:_Date_%26_Time_functions
 
|ShowPrevPart=block
 
|ShowPrevPart=block
 
|PrevPart=Documentation/How_Tos/Calc:_Database_functions
 
|PrevPart=Documentation/How_Tos/Calc:_Database_functions
 
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Financial_functions
 
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Financial_functions
 
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
 
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
* [[Documentation/How_Tos/Calc:_TODAY_function|<div style="font-size: 120%;">Today]]
+
* [[Documentation/How_Tos/Calc:_TODAY_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Today]]
 
* [[Documentation/How_Tos/Calc:_NOW_function|<div style="font-size: 120%;">Now]]
 
* [[Documentation/How_Tos/Calc:_NOW_function|<div style="font-size: 120%;">Now]]
 
* [[Documentation/How_Tos/Calc:_YEAR_function|<div style="font-size: 120%;">Year]]
 
* [[Documentation/How_Tos/Calc:_YEAR_function|<div style="font-size: 120%;">Year]]
Line 55: Line 55:
 
: when calculated at say 12 noon on 1Apr08 returns 1Apr08.
 
: when calculated at say 12 noon on 1Apr08 returns 1Apr08.
  
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: NOW function|NOW]]
 
* [[Documentation/How_Tos/Calc: NOW function|NOW]]
 
* [[Documentation/How_Tos/Calc: DATE function|DATE]]
 
* [[Documentation/How_Tos/Calc: DATE function|DATE]]

Latest revision as of 07:31, 17 July 2018


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.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_TODAY_function&oldid=243357"
Views
Personal tools
Navigation
Print/export
Tools