Height in this continued series of data based formulas Let me now to some light on the form.
Luckily we did work day and network.
These text formulas something you've discussed in the earlier video.
Now what is victory this week.
There's a formula which simply asks you to choose a date and what it gives you is the numeric digit
sequence of that b.
For example if it is a Friday to show you 6 Saturday being 7 the big cities starts from Sunday thought
to be Monday 3 being Tuesday and so on.
And that God is still 7 7 being Saturday.
So that's a big day for law.
Just telling you the sequence of the calendar does not.
There's a formula called work b which helps you figure out that if there is a starting date of a project
and if you're given five business days to complete it by when it is supposed to get completed.
So for example if I'm trying to write a form all work day I put the starting day as 30th December 2011
and then I'll see how many days do you need to complete the project.
Let's say five business days.
And the definition of business these aspart work the formula is Monday through Friday.
So I put five and a close up but I can at a press Enter notice I'm getting 6th of January 2012.
Now the question is which five have been chosen.
Let me use a color combination if for example first of January that's a Sunday cannot be included as
a business day.
I go to the second of January and would Okola that.
And you think Schottky I'm going to give a color blue note this second day is told of January next fall
of January 1st of January 6th of January.
So five business days it took to complete the project and the deadline happens to be 6th of January
2012.
Now this would be formula doesn't include the starting date even if that happens to be a working B.
So just be careful.
In case you wish to include the starting date you would have to make a manual adjustment in terms of
simple deduction of one inside the formula which then tells you first of January 2012 being the deadline.
Similarly as a corollary there's a formula called a network does what is it.
It tries to find out between a start and indeed how many business deals are there.
So for example if you write a formula equal to net to work these and the starting date let's say 30
December coma the ending date the ending date is a sixth of January.
I close the bracket and press enter it give me six which means what it does not only including the end
date.
Second third fourth fifth sixth.
All five does in good.
But it also includes the starting be some really give a color.
So a network based formula to start as well as the end date is included both to calculate the number
of business the line between that date range.
So this was a very basic formula but amateur's for work the the network the formula in the next video
I will show you that in 2010 Excel version you would have been introduced with a formula called work
did not I I am willing to see how this is very important especially when there are different countries
that follow Saturday or Sunday both to be on a date or it could be Friday is a holiday or could be just
that that only Sunday the holiday in which gives Monday to Saturday is a business.
Back in the next video.