Returns the number of the week of the specified date, relative to the year.
Syntax
 Copy Code
|
|---|
WEEKNUM( Date date, [Integer mode = 1] ) → Integer |
Parameters
- date
- Required. The date to inspect.
- mode
- Optional. A value indicating how to represent the result. If omitted, mode is assumed to be 1.
Remarks
Returns the number of the week within the year, for the specified date. If mode is not integer, it is automatically truncated.
Example
| Formula
Copy Code
|
|---|
=WEEKNUM(TODAY()) |
See Also
Function Reference
DAY Function
MONTH Function
YEAR Function
WEEKDAY Function