Difference between revisions of "Documentation/How Tos/Calc: DAYSINYEAR function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
(→Issues:) |
||
Line 28: | Line 28: | ||
=== Issues: === | === Issues: === | ||
− | <tt>'''DAYSINYEAR'''</tt> is not part of the forthcoming ODFF international standard, and should not be regarded as portable. | + | <tt>'''DAYSINYEAR'''</tt> is not part of the forthcoming ODFF international standard, and should not be regarded as portable. Try <tt>'''365+(MONTH(DATE(YEAR(date);2;29))=2)'''</tt> if you wish a portable result. |
Revision as of 05:31, 17 September 2008
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).
See also:
ISLEAPYEAR, WEEKSINYEAR, DAYSINMONTH, DAYS
Functions listed alphabetically, Functions listed by category
Issues:
DAYSINYEAR is not part of the forthcoming ODFF international standard, and should not be regarded as portable. Try 365+(MONTH(DATE(YEAR(date);2;29))=2) if you wish a portable result.