WEEKNUM

Get the week number of a date in Excel
Returns the week number in the year

Rational

Get the week number of a date.

Description

The Excel WEEKNUM function finds the week number of date and adjust as per week start day argument (optional). Example; to find week number starting from Monday for a date (05-06-2018: Cell-C7), use =WEEKNUM(B7,2) that returns ‘23’.
In simple term, WEEKNUM function helps you figure out which week of the year a date falls on.

Syntax

=WEEKNUM(serial_number,[return_type])

Parameters

serial_number – A valid argument of date, string representation or a serial number of a specific date
return_type [optional] – Setting custom start day of a week.

Return Value

Returns an integer between 1 and 54.

Key Notes

The WEEKNUM  function returns an integer between 1 and 54 that corresponds to the week number of a year as per given date argument.

The return type argument is optional, and the default is 1. There are two methods used for this function:

  1. The week containing January 1 is the first week of the year and represented as week 1.
  2. The week containing the first Thursday of the year is the first week of the year and expressed as week 1. This system is the methodology specified in ISO 8601, which is commonly known as the European week numbering system.

To customize the starting day of the 1st week of a calendar year following are the return type option available:

Return_typeWeek begins on
1 or omittedSunday
2Monday
11Monday
12Tuesday
13Wednesday
14Thursday
15Friday
16Saturday
17Sunday
21Monday (System 2)

 

Keep Reading Similar Functions:

Find the ISO week number of a year for a given date in Excel

ISOWEEKNUM

The ISOWEEKNUM function return ISO week number considering a week begins on Monday. Example; date (09-03-2017), use = ISOWEEKNUM(date) that returns 10.

Read More »
Converts a serial number of a day in the week in Excel

WEEKDAY

The WEEKDAY function returns an integer between 1 and 7 the corresponds specific day of a week. Example; (07-04-2018: Cell-B6), use =WEEKDAY(B6,2) returns ‘6’.

Read More »