WEEKNUM

Returns the number of the week of the specified date, relative to the year.

Syntax

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

=WEEKNUM(TODAY())

See Also

Function Reference
DAY Function
MONTH Function
YEAR Function
WEEKDAY Function