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:_WEEKS_function |
− | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc: | + | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_DAYSINMONTH_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 28: | Line 28: | ||
* [[Documentation/How_Tos/Calc:_DAYS360_function|<div style="font-size: 120%;">Days360]] | * [[Documentation/How_Tos/Calc:_DAYS360_function|<div style="font-size: 120%;">Days360]] | ||
* [[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%; border-style: double; border-color:#778899;">Daysinyear]] |
* [[Documentation/How_Tos/Calc:_WEEKS_function|<div style="font-size: 120%;">Weeks]] | * [[Documentation/How_Tos/Calc:_WEEKS_function|<div style="font-size: 120%;">Weeks]] | ||
− | * [[Documentation/How_Tos/Calc:_WEEKSINYEAR_function|<div style="font-size: 120% | + | * [[Documentation/How_Tos/Calc:_WEEKSINYEAR_function|<div style="font-size: 120%;">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:46, 12 May 2013
CALC FUNCTIONS
- Date & Time Functions
- TodayNowYearMonthDayWeekdayHourMinuteSecondDateDatevalueTimeTimevalueEomonthEdateWorkdayNetworkdaysDaysDays360DaysinmonthDaysinyearWeeksWeeksinyearWeeknumWeeknum_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
-