Skip to content

WEEKNUM

Date & timeExcel 2007

The week number of the year for a date.

Syntax

WEEKNUM(serial_number, [return_type])

Examples

=WEEKNUM(A2, 2)

→ week starting Monday

Good to know

  • For the ISO 8601 week (used in most of the world for reporting) use ISOWEEKNUM.

Related functions

ISOWEEKNUMWEEKDAY

More Date & time functions

DATEDATEDIFDATESTRINGDATEVALUEDAYDAYSDAYS360EDATEEOMONTHHOURISOWEEKNUMMINUTE

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.