Documentation/How Tos/Calc: DAYSINYEAR function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 08:02, 17 February 2008 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


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

Personal tools