Get week number from date

To get the week number from a date, you can use the WEEKNUM function. In the example shown, the formula in C5, copied down, is: =WEEKNUM(B5)

April 14, 2025 · 1 min · 52 words · Robert Anderson

The WEEKNUM function starts counting with the week that contains January 1.

See theWEEKNUM pagefor more information.

For more details, seeRon de Bruin’s nice write-up on Excel week numbers.

Excel formula: Get day name from date

The WEEKNUM function starts counting on the week that contains January 1.

By default, weeks begin on Sunday, but this can be changed.

Excel formula: Get month from date

Excel formula: Get year from date

Excel WEEKNUM function

Excel ISOWEEKNUM function