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

Data Analysis

  • How to count table columns in Excel
  • How To Load Analysis ToolPak in Excel
  • How to Sort by Color in Excel
  • Managing Conditional Formatting Rules in Excel
  • Create Scatter Chart in Excel

References

  • How to use Excel INDIRECT Function
  • How to use Excel ROW Function
  • Count rows with at least n matching values
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • How to get first row number in range in Excel

Data Validations

  • Excel Data validation allow weekday only
  • Excel Data validation unique values only
  • Excel Data validation require unique number
  • Excel Data validation must contain specific text
  • Excel Data validation exists in list

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

  • How to use Excel FALSE Function
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel AND Function
  • Not Equal To ‘<>‘ operator in Excel
  • SWITCH function example in Excel

Date Time

  • Get fiscal year from date in Excel
  • How to get Holiday Date from Year in Excel
  • Add days to date in Excel
  • Get fiscal quarter from date in Excel
  • TODAY function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • How to randomly assign data to groups in Excel
  • Group times into unequal buckets in Excel
  • Categorize text with keywords in Excel
  • Group arbitrary text values in Excel
  • How to randomly assign people to groups in Excel

General

  • Excel Autofill Cell Ranges, Copy, Paste
  • How to generate random number between two numbers in Excel
  • How to choose page/paper size in Excel before Printing
  • Delete Blank Rows at Once in Excel
  • Zoom Worksheet in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning