» Calculating the Week Number Corresponding with a Specific Date
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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)

Book Store:
No comments have been submitted.

