|
<< Click to Display Table of Contents >> DAYSPERYEAR (days per year) |
Syntax:
DAYSPERYEAR(Date)
Description:
This returns the number of days in the specified year.
Compatibility notes:
This function does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current 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) returns 366
See also: