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:
=WEEKNUM(A2,2)
To use the WEEKNUM function, install the Analysis ToolPak Add-in (if not already installed):
Tools->Add-ins->select Analysis ToolPak->Click OK.