» 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:
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- The New Financial Order: Risk in the Twenty-First Century
- Writing Excel Macros with VBA, 2nd Edition
- The Financial Numbers Game: Detecting Creative Accounting Practices
- 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
- Definitive Guide to Excel VBA
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!