|
#1
|
|||
|
|||
Formula To Calculate Countdown Days To Project Completion
I have a schedule with the following columns:
Start Date Finish Date Days Remaining I have hundreds of tasks, but the final project completion is: Open Date 8/4/2014 I would like to add a formula to the rows of key deliverables and some other milestones that shows the number of days or weeks (not sure what is available) remaining until the final project completion (which is the day we open). Please let me know if you need other information |
#2
|
|||
|
|||
Add a spare Duration column (Duration1 for example). Right click on the column heading and choose Custom Fields. Click the Formula button and enter the formula below:
ProjDateDiff([Finish],[Project Finish]) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula for week days only | gbaker | Excel | 5 | 02-15-2014 01:07 AM |
Calculate difference by days and hours | alysolyman | Excel | 6 | 05-13-2013 02:19 AM |
How to create a days countdown in powerpoint? | john.kelly11 | PowerPoint | 3 | 04-09-2013 09:56 AM |
Project Days | mah_dahshan | Project | 1 | 12-17-2012 04:27 AM |
Multiple Formulas in one Cell one Formula Away From Completion | microsoftnovice | Excel | 2 | 12-05-2012 12:54 PM |