Microsoft Office Forums Formula To Calculate Countdown Days To Project Completion

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-19-2014, 08:24 AM
Catherine Catherine is offline Formula To Calculate Countdown Days To Project Completion Windows XP Formula To Calculate Countdown Days To Project Completion Office 2013
Novice
Formula To Calculate Countdown Days To Project Completion
 
Join Date: Feb 2014
Posts: 1
Catherine is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 02-19-2014, 11:15 AM
JulieS JulieS is offline Formula To Calculate Countdown Days To Project Completion Windows 7 64bit Formula To Calculate Countdown Days To Project Completion Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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])
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for week days only gbaker Excel 5 02-15-2014 01:07 AM
Formula To Calculate Countdown Days To Project Completion 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
Formula To Calculate Countdown Days To Project Completion Multiple Formulas in one Cell one Formula Away From Completion microsoftnovice Excel 2 12-05-2012 12:54 PM


All times are GMT -7. The time now is 04:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft