Excel WEEKNUM Function
Summary
The Excel WEEKNUM function takes a date and returns a week number (1-54) that corresponds to the week of year. The WEEKNUM function starts counting with the week that contains January 1. By default, weeks begin on Sunday.
Purpose
Get the week number for a given date
Return value
A number between 1 and 54.
Syntax
=WEEKNUM (serial_num, [return_type])
Arguments
- serial_num - A valid Excel date in serial number format.
- return_type - [optional] The day the week begins. Default is 1.
Version
Usage notes
The WEEKNUM function starts counting with the week that contains January 1. The return_type argument controls which day of the week is used to begin a new week number. Return_type is optional and defaults to 1.
With a return_type of 1-17, week number 1 in a given year is assigned to the week that contains January 1. With return_type 21, week 1 is the week containing the first Thursday of the year, following ISO 8601.
| Return_type | Week begins |
|---|---|
| 1 (default) | Sunday |
| 2 | Monday |
| 11 | Monday |
| 12 | Tuesday |
| 13 | Wednesday |
| 14 | Thursday |
| 15 | Friday |
| 16 | Saturday |
| 17 | Sunday |
| 21 | Monday (see note above) |
WEEKNUM formula examples
The WEEKNUM function takes a date and returns a week number (1-54) that corresponds to the week of year. The WEEKNUM function starts counting with the week that contains January 1. WEEKNUM takes two arguments: a date,...
The SUMIFS function can sum ranges based on multiple criteria.
In this problem, we configure SUMIFS to sum amounts in the named range total by week number using two criteria:
color = value in column G
week = value...
The TEXT function can apply number formats of any kind, including currency, date, percentage, etc. By applying a number format like "00", "000", "0000", you can "pad" numbers with as many zeros as you like. Zeros will...
Related functions
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
