Difference between revisions of "Documentation/How Tos/Calc: DAYSINYEAR function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
Javier Lopez (Talk | contribs) |
||
| Line 3: | Line 3: | ||
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div> | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div> | ||
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Date_%26_Time_functions|<div style="font-size: 140%;">Date & Time Functions]] | |ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Date_%26_Time_functions|<div style="font-size: 140%;">Date & Time Functions]] | ||
| − | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc: | + | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_WEEKNUM_function |
| − | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc: | + | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_WEEKS_function |
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Database_functions | |ShowPrevPart=block|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 | ||
| Line 29: | Line 29: | ||
* [[Documentation/How_Tos/Calc:_DAYSINMONTH_function|<div style="font-size: 120%;">Daysinmonth]] | * [[Documentation/How_Tos/Calc:_DAYSINMONTH_function|<div style="font-size: 120%;">Daysinmonth]] | ||
* [[Documentation/How_Tos/Calc:_DAYSINYEAR_function|div style="font-size: 120%;">Daysinyear]] | * [[Documentation/How_Tos/Calc:_DAYSINYEAR_function|div style="font-size: 120%;">Daysinyear]] | ||
| − | * [[Documentation/How_Tos/Calc:_WEEKS_function|<div style="font-size: 120% | + | * [[Documentation/How_Tos/Calc:_WEEKS_function|<div style="font-size: 120%;">Weeks]] |
| − | * [[Documentation/How_Tos/Calc:_WEEKSINYEAR_function|<div style="font-size: 120%;">Weeksinyear]] | + | * [[Documentation/How_Tos/Calc:_WEEKSINYEAR_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Weeksinyear]] |
* [[Documentation/How_Tos/Calc:_WEEKNUM_function|<div style="font-size: 120%;">Weeknum]] | * [[Documentation/How_Tos/Calc:_WEEKNUM_function|<div style="font-size: 120%;">Weeknum]] | ||
* [[Documentation/How_Tos/Calc:_WEEKNUM_ADD_function|<div style="font-size: 120%;">Weeknum_add]] | * [[Documentation/How_Tos/Calc:_WEEKNUM_ADD_function|<div style="font-size: 120%;">Weeknum_add]] | ||
Revision as of 18:27, 12 May 2013
CALC FUNCTIONS
- Date & Time Functions
- TodayNowYearMonthDayWeekdayHourMinuteSecondDateDatevalueTimeTimevalueEomonthEdateWorkdayNetworkdaysDaysDays360Daysinmonth
- div style="font-size: 120%;">Daysinyear
WeeksWeeksinyearWeeknumWeeknum_addMonthsYears
Contents
DAYSINYEAR
Returns the number of days in a year.
This function is only available if the Analysis AddIn is installed.
Syntax:
DAYSINYEAR(date)
- returns the number of days in the year in which date lies.
Example:
DAYSINYEAR("2012-02-14")
- returns 366, the number of days in 2012 (2012 is a leap year).
Issues:
DAYSINYEAR is not part of the forthcoming ODFF international standard, and is not portable. Try 365+(MONTH(DATE(YEAR(date);2;29))=2) if you wish a portable result.
Template:Documentation/SeeAlso
-
