WEEKNUM function helps to calculate the week number of the given date in a year. It considers 1st January as first week by default and through the output for the given input date.
=Weeknum(serial_number,[return_type])
This video covers:
WEEKNUM function helps to calculate the week number of the given date in a year. It considers 1st January as first week by default and through the output for the given input date.
=Weeknum(serial_number,[return_type])
The WEEKNUM uses the following arguments: Serial_number (required argument) – This is an Excel date for which we want to return the week number. When entering the argument, we should enter the date using the DATE function or as a result of other formulas or functions.
To find the WEEKNUM of the year we use the formula =WEEKNUM(A2,1).
In the WEEKNUM formula select the first argument as date comma now select first day of week it depends every company has different first day of week here i am selecting sunday .
As shown in below image when you apply formula the result is 2 and when we copy formula in column the result is shown in 2nd image.
To get week of the month using the same WEEKNUM Formula.
Calculating the week of the year minus the week of the year of first of the same month.
FORMULA=WEEKNUM(A2,1)-WEEKNUM(DATE(YEAR(A2),MONTH(A2),1),1)+1
LOWER function is used for changing the format of any text or string to LOWER case.
Excel Function- WORKDAY.INTL WORKDAY.INTL function is an advanced version of WORKDAY function with additional advantage of “Custom weekend options” For Example, with WORKDAY function weekends are treated as “Saturday and Sundays” however if you need…
MAX function is used to get the largest number in range or list of values. MAX function has one required argument i.e. number1
Microsoft Excel “ISBLANK Function” is a Logical Function and it is used to check if cell in question is “BLANK OR NON-BLANK”. “ISBLANK Function” is used as a test to validate if cell contains any…
ROWS function is used to get the total count of rows in an array or in cells range in an excel worksheet.
Have you ever got into situation in office where you need to count the cells in Excel sheet with specific color? If yes then you can use following code which counts the number of cells…