» Calculating a Project's End Date
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Columns A & B contain the start date of various projects and the number of hours required for each project's completion.
We want to calculate each project's end date, based on the number of required hours, a specified number of daily working hours (cell C2), and the assumption that work is only done on weekdays.
Solution:
Use the WORKDAY and ROUNDUP functions as shown in the following formula:
=WORKDAY(A2,ROUNDUP(B2/$C$2,0))
Book Store:
Recommended Books:
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- 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
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- How to Pay Zero Taxes (Annual)
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
Dee Jackson
I would like to know how to project an end date. I want to write in a start date 02/24/2006 and want excel to put in the date after 180 days. For example after 180 days of 02/24/06 would be 08/22/06.
Cheers!