Tip Printed from ExcelTip.com

---

Calculating the Week Number Corresponding with a Specific Date


Problem:
Calculating the week number corresponding with each of the dates listed in column A.

Solution:
Use the WEEKNUM function as shown in the following formula:
=WEEKNUM(A2,2)