Calculating week numbers with WEEKNUM and ISOWEEKNUM (Excel 2013)

preview_player
Показать описание
Spreadsheet example and more info from:

How to calculate week number with the WEEKNUM-function and the new (Excel 2013 way that are available with the ISOWEEKNUM function.
Week numbering with the ISO week date system (ISO 8601) is explained and WEEKNUM function is compared with the new Excel 2013 spreadsheet function ISOWEEKNUM.
WEEKNUM Returns the week number of a specific date.
ISOWEEKNUM Returns number of the ISO week number of the year for a given date.
WEEKNUM with Return_type 21 returns the same week number as ISOWEEKNUM.
Рекомендации по теме
Комментарии
Автор

How can I find the date against of the weeknumber.
Ex: week no: 42 Date: ???
please suggest???

vishnutejasaini
Автор

There are actually 10 different types instead of 9.

You missed return_type 11.

Very good video and very informative otherwise.

Thank you

hernanmartinez