Formula for Calculating the End Date of a Project.

Posted on April 4, 2008
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

Here are a few posts the other readers recommend you check out.

Computer Tips, Tricks, Tweaks and Tutorials - Formula for Calculating the End Date of a Project.

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.

Excel-Tip-Trick-Pic1

· Now first you’ll need to fill in the “special day’s” like national holidays etc. etc.

Excel-Tip-Trick-Pic2

· Then type in the start date in Cell C2

Excel-Tip-Trick-Pic3

· Type in Cell D2 the following formula =WORKDAY(C2;B2;$F$2:$F$4)

· And press Enter

Excel-Tip-Trick-Pic4

· Now you’ll need to go to Cell C3

· And type in =D2+1

Excel-Tip-Trick-Pic5

· 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.

Excel-Tip-Trick-Pic6

· And do the same with Cell D2

Excel-Tip-Trick-Pic7

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!!

Do you want to see more? This is related...

Did you ever thought about publishing your own eBook or PDF report?

Invite your friends to the World of Office.

Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 10 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!

If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.