Getting the Week Number From a Date in Excel

New WEEKNUM Function - ISO 8601 standard

Excel has had a week number function for many versions, but Excel 2013 added a new week number function that complies with the ISO 8601 standard week number.

The existing week number function is WEEKNUM and can be used as below, assuming cell A1 has a date
=WEEKNUM(A1)
The default week numbering starts on a Sunday, but there is an option to start the week on a Monday as follows
=WEEKNUM(A1,2)
The new function is ISOWEEKNUM and can be used as below
=ISOWEEKNUM(A1)
The ISO standard week begins on the week with the year’s first Thursday.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *