Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How To Load Analysis ToolPak in Excel
  • Excel Line Chart
  • Subtotal function in Excel
  • How to create dynamic reference table name in Excel
  • Conditional Formatting Data bars Examples in Excel

References

  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation
  • To count total rows in a range in Excel
  • Lookup entire row in Excel
  • Excel Advanced Lookup using Index and Match Functions
  • How to use Excel COLUMN Function

Data Validations

  • Excel Data validation date in specific year
  • Excel Data validation allow uppercase only
  • Excel Data validation require unique number
  • Excel Data validation unique values only
  • Excel Data validation only dates between

Get week number from date in Excel

by

If you need to get the week number from the day from a date, you can use the WEEKNUM function. The date must be in a form that Excel recognizes as a valid date.

Note: The WEEKNUM function takes two arguments, a date, and, optionally, an argument called return_type, which controls the scheme used to calculate the week number.

Formula

=WEEKNUM(date)

Explanation

In the example, the formula is:

=WEEKNUM(B5)

B4 contains a date value for January 5, 2016. The DAY function returns the number 2 representing the calculated week number.

Note that by default, the WEEKNUM function uses a scheme where week 1 begins on January 1, and week 2 begins on the next Sunday (when the return_type argument is omitted, or supplied as 1).

With a return_type of 2, week 1 begins on January 1, and week 2 begins on the next Monday.

ISO week number

With ISO week numbers, week 1 starts on the Monday of the first week in a year with a Thursday. This means that the first day of the year for ISO weeks is always a Monday in the period between Jan 29 and Jan 4.

Starting with Excel 2010 for Windows and Excel 2011 for Mac, you can generate an ISO week number using 21 as the return_type:

=WEEKNUM(date,21)

Post navigation

Previous Post:

DECIMAL function: Description, Usage, Syntax, Examples and Explanation

Next Post:

AVERAGE function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

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

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Return blank if in Excel
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • OR function Examples in Excel
  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • Nested IF function example in Excel

Date Time

  • Get fiscal year from date in Excel
  • Find Last Day of the Month in Excel
  • Get days, hours, and minutes between dates in Excel
  • Get work hours between dates custom schedule in Excel
  • Extract date from a date and time in Excel

Grouping

  • Group times into 3 hour buckets in Excel
  • If cell contains one of many things in Excel
  • How to randomly assign data to groups in Excel
  • Running count group by n size in Excel
  • Group numbers at uneven intervals in Excel

General

  • Find, Trace and Correct Errors in Excel Formulas using ‘Formula Auditing’
  • How to generate random times at specific intervals in Excel
  • Basic numeric sort formula in Excel
  • Count cells that do not contain errors in Excel
  • Customize Ribbon In Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning