Documentation/Calc Functions/DAYSINYEAR/en

Function name:
DAYSINYEAR

Category:
Date and Time

Summary:
Calculates the number of days in the year in which the specified date lies.

Syntax:
DAYSINYEAR(Date)

Returns:
Returns an integer value 365 or 366, which is the number of days in the year in which the specified date lies.

Arguments:
Date is the date (in quotation marks) or a date-time serial number, or a reference to the cell containing one of those types, which is the date for which the calculation is to be carried out.


 * If Date is not a valid date expression, then DAYSINYEAR reports a #VALUE! error.
 * DAYSINYEAR ignores any time components of Date.

Details specific to DAYSINYEAR function
DAYSINYEAR is not part of the ODF 1.2 international standard and should not be regarded as portable. If portability is important for your spreadsheet, try the following formula as an alternative to DAYSINYEAR.

Related LibreOffice functions:
DAYSINMONTH

ODF standard:
None.

Equivalent Excel functions:
None.