How to Use WEEKNUM() in Google Sheets

Description

Returns a number representing the week of the year where the provided date falls.

How To Actually Use WEEKNUM() in Sheets

WEEKNUM(date, [type])

Try WEEKNUM yourself

Use the WEEKNUM formula to calculate the week number for the dates in the range A1:A10. The correct answer should return the week number for each date.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for WEEKNUM(). Click through to watch.

Browse more tutorials

How to Iterate Counting Blank Cells in Google Sheets

Count different types of blank cells. Cells with nothing in them.

Intermediate

ARRAYFORMULA() IF() ISBLANK() MAX()

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Embed a Number in a Website from a Google Sheet

Ever wanted to display some data from a google sheet on your site? Witho...

Advanced

Unlock these tutorials

Learn more about the WEEKNUM() formula:

Generate a WEEKNUM() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses WEEKNUM(). 2 free AI generations, no signup. Members get unlimited use.

Generate a WEEKNUM() formula

How to Use WEEKNUM() in Google Sheets

Try WEEKNUM yourself

More related tutorials

How to Iterate Counting Blank Cells in Google Sheets

Hardest Formula: SumIF | Addition Based on Dates / Values

Embed a Number in a Website from a Google Sheet