But what if you are looking for the opposite, i.e. How to convert week number to date in ExcelĪs you have just seen, it's no big deal to turn a date into a week number using the Excel WEEKNUM function. Most often you would use it in combination with other functions to perform various calculations based on the week number, as demonstrated in further examples. In real-life scenarios, the Excel WEEKNUM function is rarely used on its own. The above formula returns 16, which is the number of the week containing April 15, 2015, with a week beginning on Monday. Instead of referring to a cell, you can specify the date directly in the formula by using the DATE(year, month, day) function, for example: If you'd rather begin with some other day of the week, say Monday, then use 2 in the second argument: In the above formula, the return_type argument is omitted, which means that the default type 1 is used - the week beginning on Sunday. The following screenshot demonstrates how you can get week numbers from dates with the simplest =WEEKNUM(A2) formula: Excel WEEKNUM formulas to convert date to week number (from 1 to 54)

Return types 11 through 21 are supported in Excel 2010 and Excel 2013 only. In Excel 2007 and earlier versions, only options 1 and 2 are available. It is commonly known as the European week numbering system and it is used mainly in government and business for fiscal years and timekeeping.Īll of the return types listed above apply to System 1, except for return type 21 that is used in System 2. In this system, the week starts on Monday and the week containing the first Thursday of the year is considered week 1. This is the ISO week date system that is part of the ISO 8601 date and time standard. In this system, the week traditionally starts on Sunday. The week containing January 1 is considered the 1 st week of the year and is numbered week 1. In the WEEKNUM function, two different week numbering systems are used: Monday (used in System 2, please see the details below.)

Here is a complete list of the return_type values supported in WEEKNUM formulas. If omitted, the default type 1 is used (the week beginning on Sunday). Return_type (optional) - a number that determines on which day the week begins.This can be a reference to a cell containing the date, a date entered by using the DATE function or returned by some other formula. Serial_number - any date within the week whose number you are trying to find.

11 x 17 in word for mac