» 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:
Recommended Books:
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Finance and Accounting for Nonfinancial Managers
- Microsoft Excel Version 2002 Step by Step
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Seven Habits Of Highly Effective People
No comments have been submitted.
