How can we help?
Returns a number representing the week of the year where the provided date falls.
WEEKNUM(DATE(1969, 7, 20), 1)
date- The date for which to determine the week number. Must be a reference to a cell containing a date, a function returning a date type, or a number.
type- [ OPTIONAL - default is
1] - A number representing the day that a week starts on as well as the system used for determining the first week of the year (1=Sunday, 2=Monday).
DATEfunction, as text values may return errors.
For each type, the start day and end day of a week are defined as follows when counting week numbers:
|Day week begins on||Day week ends on||System|
|1 or omitted||Sunday||Saturday||1|
WEEKDAY: Returns a number representing the day of the week of the date provided.
DAYS360: Returns the difference between two days based on the 360 day year used in some financial interest calculations.
DATE: Converts a provided year, month, and day into a date.
DATEVALUE: Converts a provided date string in a known format to a date value.