» Calculating a Date Based on Year, Week Number and Day of the Week
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem: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:
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Business Analysis with Microsoft Excel (2nd Edition)
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Marketing Planning for Services
- Investing in Real Estate, Fourth Edition
- Microsoft Office XP Introductory Concepts and Techniques
No comments have been submitted.

