From the course: Google Sheets: Advanced Formulas and Functions

Find the week number for a given date - Google Sheets Tutorial

From the course: Google Sheets: Advanced Formulas and Functions

Start my 1-month free trial

Find the week number for a given date

“

- [Instructor] Many businesses track their transactions by the week of the year. For example, a business might typically see higher sales in the 13th, 26th, 39th and 52nd weeks of the year. Those weeks correspond to the end and beginning of the four quarters of the year. In this movie, I'll show you how to calculate in which week of the year a date occurs. I have a series of dates in cells A2 through A8 and I want to find the week number for each of them. So I'll click in cell B2 and type an equals sign to start entering my first formula. And the function I want to use is weeknum which is short for week number, so w-e-e-k-n-u-m, followed by a left parentheses. I need to provide two pieces of information. The first is the date. That's easy enough, it's the cell A2, then a comma, and then type, and looking down, I see that type is a number representing the day that a week starts on, where Sunday equals day number one. In the United States, we typically do start our weeks on Sunday, at least counting from Sunday on the calendar, so I will stay with that for this first formula, and I'll type a right parentheses to close out the argument list, and enter, and I see that November 1st, 2017, occurs in week number 44. Now I can copy the formula to the other cells next to my dates by clicking cell B2, positioning my mouse pointer over the fill handle at the bottom right corner, it's this blue box, and when my mouse pointer changes to a large, black crosshair, I know it's in the right place, so I'll double click, and I get my week numbers for the dates in my worksheet.

Contents