This function returns a number that indicates the week of the year numerically.
WEEKNUM(date,weektype)
This function has these arguments:
| Argument | Description | |
|---|---|---|
| date | Date for which you want to determine the number of week | |
| weektype | Type of week determined by on which day the week starts | |
| Value | Number returned | |
| 1 (assumed if omitted) | Week starts on a Sunday | |
| 2 | Week starts on a Monday |
Specify the date argument as a number (as in 37806.5) a string (as in "7/4/2003 12:00"), or a DateTime object, as in DATE(2003,7,4). For more details on the date inputs, refer to Date and Time Functions.
Accepts numeric, string, DateTime object, or TimeSpan object data. Returns numeric data.
WEEKNUM(A2)
WEEKNUM(R2C1,2)
WEEKNUM(23,1) gives the result 4