Pinterest Pixel

WEEKNUM Formula in Excel

  What does it do? Gets the week number from the date Formula breakdown: =WEEKNUM(serial_number, [return_type]) What it... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

 

What does it do?

Gets the week number from the date

Formula breakdown:

=WEEKNUM(serial_number, [return_type])

What it means:

=WEEKNUM(date wherein the week number will be retrieved, [day when the week will begin])


Do you need to retrieve the week number from a given date? The WEEKNUM Formula in Excel is perfect for this!

There are a couple of interesting points to take note of the WEEKNUM Formula:

  • The return type parameter specifies which day of the week is used to start a new week number. For our examples, we will be using the default. But there are a number of settings that you can use:
    • 1 (default) – Sunday
    • 2 – Monday
    • 11 – Monday
    • 12 – Tuesday
    • 13 – Wednesday
    • 14 – Thursday
    • 15 – Friday
    • 16 – Saturday
    • 17 – Sunday
    • 21 – Monday, the difference here is it uses the European week numbering system, week 1 is the week containing the first Thursday of the year as specified in ISO 8601
See also  DATE Formula in Excel

I explain how you can do this below:

WEEKNUM Formula in Excel | MyExcelOnline

Download excel workbookWEEKNUM-FORMULA.xlsx

STEP 1: We need to enter the WEEKNUM function in a blank cell:

=WEEKNUM(

WEEKNUM Formula in Excel

 

STEP 2: The WEEKNUM arguments:

serial_number

What is the date to extract the week number from?

Select the cell containing the date:

=WEEKNUM(C9)

WEEKNUM Formula in Excel

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

WEEKNUM Formula in Excel

You now have your week numbers!

WEEKNUM Formula in Excel

 

How to Use the WEEKNUM Formula in Excel

 

 

WEEKNUM Formula in Excel | MyExcelOnline

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!