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

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
m
Line 23: Line 23:
  
 
'''[[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]'''
 
'''[[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]'''
 +
 +
=== Issues: ===
 +
<tt>'''DAYSINYEAR'''</tt> is not part of the forthcoming ODFF international standard, and should not be regarded as portable.

Revision as of 09:11, 17 February 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

Date & Time functions

Date & Time overview

Issues:

DAYSINYEAR is not part of the forthcoming ODFF international standard, and should not be regarded as portable.

Personal tools