Project Management Seminars from the Project Management Advisor™ |
Project Management
Templates -
Project Template using =Workday() function
 |
| |
 |
Recently I was helping a client do a very simplistic one-person project plan where we entered a project start date, task durations, and lag time between tasks. We wanted to be able to see the projected end date of the project but wanted the plan to be smart enough to recognize weekends and holidays. Because the client is more excel literate than project literate, they preferred to do the plan in excel. I started doing a lot of nested "if" statements and realized that there had to be a better way. After doing a bit of research I discovered a nifty little function called =Workday. The syntax of =Workday is really simple, as follows:
=WORKDAY(start_date,days,holidays)
The start_date parameter is the date that the task is to start. The days parameter is the duration of the task in work days. The holidays parameter is the list of holiday or off days that must be taken account in the plan. The function works like a charm when you want to do a simple plan but need to know end dates based on durations taking into account weekends and holidays.
I put together a simple excel template for you see the formula in action and to use as a starting point for a quick and dirty project plan where MS Project might be overkill.
Get this template for only
$1.99 Free
here
|
|
| |
|