Difference between revisions of "Documentation/How Tos/Calc: DAYSINYEAR function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(3 intermediate revisions by one other user not shown)
Line 56: Line 56:
 
<tt>'''DAYSINYEAR'''</tt> is not part of the forthcoming ODFF international standard, and is not portable. Try <tt>'''365+(MONTH(DATE(YEAR(date);2;29))=2)'''</tt> if you wish a portable result.
 
<tt>'''DAYSINYEAR'''</tt> is not part of the forthcoming ODFF international standard, and is not portable. Try <tt>'''365+(MONTH(DATE(YEAR(date);2;29))=2)'''</tt> if you wish a portable result.
  
−
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: ISLEAPYEAR function|ISLEAPYEAR]]
 
* [[Documentation/How_Tos/Calc: ISLEAPYEAR function|ISLEAPYEAR]]
 
* [[Documentation/How_Tos/Calc: WEEKSINYEAR function|WEEKSINYEAR]]
 
* [[Documentation/How_Tos/Calc: WEEKSINYEAR function|WEEKSINYEAR]]

Revision as of 07:40, 17 July 2018


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.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_DAYSINYEAR_function&oldid=243387"
Views
Personal tools
Navigation
Tools