» Calculating the Week Number Corresponding with a Specific Date
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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)
Book Store:
Recommended Books:
- Financial Modeling - 2nd Edition
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- How to Use Financial Statements: A Guide to Understanding the Numbers
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
No comments have been submitted.
