Hello that they're starting to go to learn something which is very very important for project management
managing and calculating deadline dates and also to find out that if a certain project starts on a defined
beat predefined date and there are seven to eight or maybe x number of business these allocated to it
by when shall it be estimated to get complete.
And mind you when I say business does it can mean Monday to Friday.
It can also mean Monday to Saturday and in different countries.
Friday being a holiday it can also mean Saturday to Thursday.
So let's see how to get hold of this formula.
Firstly I've populated a very small list of dates and I mentioned the day that it belongs to example's
38 December 2011 happens to be a Friday.
Now the project start date is 30th December to 11 and I've dedicated five business days to complete
it.
But also notice that I have one more variable added that is among the group of the second January 2012
is the holiday.
So now how do I calculate that.
When was the project going to end.
Assuming that I do not take into consideration those starting the that is 30 December.
When was the project get completed.
Well let's find out if the business works with Saturday and Sunday or the holiday the next working day
which we think as Monday in January is dead.
But that's also holiday.
So first the is toward next 4th next 5th and next the sixth and seventh and it's our weekend the next
ending it happens.
We want 9th of January 2012.
Now how do I calculate this using the formula.
Let's see.
So let me dive in equal to W O R K.
And what I get to see is to form allow work day and what they don't.
I mean if you are using words in 2007 then you will be getting only one formula that would be not the
would be ideal.
The second formula which we are going to use right now has been introduced in version 2010 and this
is something which is more powerful than the previous one.
So present Dabi now it asks me starting date which is 30th December 2011.
OK.
Coma then it does me please choose the DS which I gladly choose as 5 and then it asks me what is the
week in Boston that you follow.
I would say I follow the normal one that is one Saturday Sunday.
But yes in case you your country happens to fall only Monday to Saturday as business does that I will
have to in 11 inductees in this case.
Let me start with one now mind you there is one loop on the left.
It says what a list of holidays I dont need to choose the columns of holiday and the type of holiday
I just need to use the cells which contain the date of holidays.
Thats about it.
And if I close the bracket let me see what I get.
I get 9 of January 2008 and this is the thing that we had initially thought of as an anthem.
Now imagine if sick in January 2012 was not a holiday.
I believe that the moment I didn't notice since it is not a holiday it's considered as a working day.
And because of it.
One two three four five five days gets completed on which the 6th of January 2012.
Imagine that this particular calculation needs to be done in a manner where Sunday is considered to
be a hundred day Saturday of business day.
So what do I do.
I never click on the formula.
I grew Inter-Parliamentary to begin.
Find them again.
I Backspacer it and I'm going to choose 11 and I press enter.
Notice this time it has further reduced by one day.
That means telephone December is the working day second third fourth and fifth sixth and nine normal
needed.
So this is how you calculate in Bede's deadline ladies and when a product needs to be get completed
and quite often it happens the window closes.
There are service agreements that says the resolution must happen in 5 business days or six business
days in which case this could also be used as a control mechanism to find out by then by which date
the resolution has had to be completed.
That was Will be done.
I intill formula for you.
Just keep in mind that this in Clunes all the dates except the project started.
So if you want to make that minor adjustment you can inside the formula by saying plus one that means
sixth of January or in this case minus 1.
So that plus one minus one is you can do that based on your calculation.