WEEKNUM(...)
How to find week number from the date.
Used Functions
Category: Date and time
Converts a serial number to a number representing where the week falls numerically with a year
Syntax
WEEKNUM(serial_number,[return_type])
Practice WEEKNUM Formula at Sheetzoom
WEEKNUM formula at Microsoft help
0
We use MS Excel's function WEEKNUM() to find the week number.