<< 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: