Difference between revisions of "Documentation/How Tos/Calc: TODAY function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
Javier Lopez (Talk | contribs) |
||
| 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: | + | |NextPage=Documentation/How_Tos/Calc:_NOW_function |
|ShowPrevPage=block | |ShowPrevPage=block | ||
| − | |PrevPage=Documentation/How_Tos/Calc: | + | |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]] | ||
Revision as of 14:18, 12 May 2013
CALC FUNCTIONS
- Date & Time Functions
- TodayNowYearMonthDayWeekdayHourMinuteSecond
- Date
DatevalueTimeTimevalueEomonthEdateWorkdayNetworkdaysDaysDays360DaysinmonthDaysinyearWeeksWeeksinyearWeeknumWeeknum_addMonthsYears
Contents
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.
-
