DAYSPERYEAR (days per year)

<< Click to Display Table of Contents >>

DAYSPERYEAR (days per year)

Syntax:

DAYSPERYEAR(Date)

Description:

Returns the number of days in the specified year.

Compatibility notes:

This function is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last result as a fixed value.

Example:

DAYSPERYEAR("01/01/2012") returns 366 (2012 was a leap year)

DAYSPERYEAR("01/01/2013") returns 365 (2013 was not a leap year)

If cell A1 contains the date value 1/1/2012 then DAYSPERYEAR(A1) retrurns 366

See also:

YEAR, DAYSPERMONTH, DAYS/DAYSP, DAYS360