[EXCEL] – WEEKNUM FUNCTION

WHAT IS WEEKNUM FUNCTION IN MICROSOFT EXCEL?

In Microsoft Excel, WEEKNUM function returns the week number of a specific date, return value is integer, and it is between 1 to 54 (depends on return type selection). For example, the week containing January 1 is the first week of the year, and returned as 1.

SYNTAX OF WEEKNUM FUNCTION

weeknum function in microsoft excel

WEEKNUM function has 2 functional arguments

=WEEKNUM(serial_number,[Return_Type])

— serial_number in this function is required argument and it should be date value.

— return type is optional argument and it is prepopulated built-in list. We can select this argument depends on our requirement

(Check out the below about working with WEEKNUM function in Microsoft Excel in details with real time scenarios).

EXAMPLES OF WEEKNUM FUNCTION

NODESCRIPTIONFORMULARESULT
1In cell B2 type 03/31/2020, and cell B4 write formula=WEEKNUM(B2)14
2In cell B2 type 03/31/2020, and cell B4 write formula=WEEKNUM(B2,1)14
3In cell B2 type AK, and cell B4 write formula=WEEKNUM(B2,1)#VALUE!

TIPS & TRICKS

  1. We can use WEEKNUM function to return any date week number for calculations.
  2. For example, if we have a requirement to create weekly template for a month like any month it should be show as Week1, Week2,… [refer the above video to achieve this task], we can use this function to fulfill requirement.

RELATED ARTICLES

  1. Check out the following article for learning WEEKDAY function: http://msofficeguru.in/microsoft-excel/excel-weekday-function-in-microsoft-excel/
  2. Check out the following article for learning DATE function: http://msofficeguru.in/microsoft-excel/excel-date-function-in-microsoft-excel/

Leave a Reply

Your email address will not be published. Required fields are marked *