DAYSINYEAR function
From Apache OpenOffice Wiki
< Documentation | How Tos
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 ODFF international standard, and is not portable. Try 365+(MONTH(DATE(YEAR(date);2;29))=2) if you wish a portable result.
See Also
