=Weeknum(serial_number,[return_type])
This video covers:
=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
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.
LOWER function is used for changing the format of any text or string to LOWER case.
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
ROWS function is used to get the total count of rows in an array or in cells range in an excel worksheet.
COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.
TEXT function is used to change the formatting or appearances of the text. There are various types of formatting available.