» 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 36-Hour Course in Finance for Nonfinancial Managers
- Microsoft Access Version 2002 Step by Step
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- The Fall of Advertising and the Rise of PR
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Advanced modelling in finance using Excel and VBA
Help in date conversions
Mindy
How can I convert this date in excel
081906 - means 08 is the day - 19 is the week - 06 is the year. So in other words it means the 19th week of the year 2006 and the 08th day of that month. It reads May 8, 2006
081906 - means 08 is the day - 19 is the week - 06 is the year. So in other words it means the 19th week of the year 2006 and the 08th day of that month. It reads May 8, 2006