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])
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
Microsoft Excel “TODAY” function is used to get the current Date. It is very useful function and can be used in many ways. “TODAY Function” does not have any argument that makes this easy to apply and implement.
FIND function is used to find the position of text, or character in an available string.
AVERAGEIF function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.
MATCH function performs lookup for a value in a range and returns its position sequence number as output. It has two required and one optional arguments
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.
Watch: How to use SUMIF & SUMIFS Function in Excel? What is SUMIF Function? The SUMIF function in Excel adds up values in a range of cells that meet certain criteria. Click here to Read Full…