» 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:
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- How to Use Financial Statements: A Guide to Understanding the Numbers
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
