Documentation/Calc Functions/WEEKSINYEAR

Function name:
WEEKSINYEAR

Category:
Date and Time

Summary:
Calculates the number of weeks in the year in which the specified date lies. A week is assumed to start on Monday and is taken to be in the year if most of its days are in that year.

Syntax:
WEEKSINYEAR(Date)

Returns:
Returns an integer value 52 or 53, which is the number of weeks 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. Date can be any date in the year of interest.


 * If Date does not contain a valid date expression then WEEKSINYEAR reports a #VALUE! error.
 * WEEKSINYEAR ignores any time components of Date.

Details specific to WEEKSINYEAR function
WEEKSINYEAR is not part of the ODF 1.2 international standard and should not be regarded as portable.

Related LibreOffice functions:
DAYSINYEAR

ODF standard:
None.

Equivalent Excel functions:
None.