Formula for Calculating the End Date of a Project.
Posted on April 4, 2008
Filed Under Excel Tips & Tricks
We covered some pretty cool Excel formula’s this week and I hope you’re ready for the last one. I used this one a lot when I still had a day job as a sales- and project manager. This excel formula can be used for determining the end date of a project or a certain time span. Of course you use it in your own advantage by giving it your own twist.
For calculating the end date of a project you’ll need to take the following steps.
· First you’ll to fill in the steps/subprojects with the estimated day’s that are needed for the steps.
· Now first you’ll need to fill in the “special day’s” like national holidays etc. etc.
· Then type in the start date in Cell C2
· Type in Cell D2 the following formula =WORKDAY(C2;B2;$F$2:$F$4)
· And press Enter
· Now you’ll need to go to Cell C3
· And type in =D2+1
· Now it’s time for some magic;)
· Fill in the Cells C3 down to Cell C6 by dragging down the bottom right corner of Cell C3.
· And do the same with Cell D2
And you’re done.
So I hope you all enjoyed this Excel week and if you have any question don’t be shy 
and just send me a message. Maybe I can help you. I hope you all have a great weekend and I’ll see you on Monday with some new Tips and Tricks. See you!!
Comments
One Response to “Formula for Calculating the End Date of a Project.”
Leave a Reply
Want to Follow Us
Or Join others on Twitter-
Custom Search -
Thank you for the explanation of the WORKDAY function. But, for the example task starting 4/2, going for 8 days with a non-work day on 4/3, I would have thought the end date would be 4/14 with the next task starting on 4/15. What am I missing?