» Calculating a Date Based on Year, Week Number and Day of the Week
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Calculating a date using the relevant numbers for day of the week, week number, and year number.
Solution:
Use the DATE and WEEKDAY functions as shown in the following formula:
=DATE(C2,1,3)-WEEKDAY(DATE(C2,1,3),1)+7*(B2-1)+A2
Book Store:
Recommended Books:
- Keys to Reading an Annual Report (Barron's Business Keys)
- Adventure Capitalist: The Ultimate Road Trip
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- The Guide to Understanding Financial Statements
- Investing for Dummies, Third Edition
corresponding dates
amy
If I type in the date in cell d10, what formula can I use in cells F-L10?
