1

00:00:00,820 --> 00:00:07,580

Height in this continued series of data based formulas Let me now to some light on the form.



2

00:00:07,600 --> 00:00:10,900

Luckily we did work day and network.



3

00:00:10,900 --> 00:00:14,850

These text formulas something you've discussed in the earlier video.



4

00:00:15,170 --> 00:00:17,210

Now what is victory this week.



5

00:00:17,210 --> 00:00:23,150

There's a formula which simply asks you to choose a date and what it gives you is the numeric digit



6

00:00:23,150 --> 00:00:25,050

sequence of that b.



7

00:00:25,070 --> 00:00:32,410

For example if it is a Friday to show you 6 Saturday being 7 the big cities starts from Sunday thought



8

00:00:32,420 --> 00:00:35,210

to be Monday 3 being Tuesday and so on.



9

00:00:35,210 --> 00:00:38,200

And that God is still 7 7 being Saturday.



10

00:00:38,270 --> 00:00:39,550

So that's a big day for law.



11

00:00:39,560 --> 00:00:44,300

Just telling you the sequence of the calendar does not.



12

00:00:44,600 --> 00:00:50,720

There's a formula called work b which helps you figure out that if there is a starting date of a project



13

00:00:51,050 --> 00:00:57,410

and if you're given five business days to complete it by when it is supposed to get completed.



14

00:00:57,560 --> 00:01:05,180

So for example if I'm trying to write a form all work day I put the starting day as 30th December 2011



15

00:01:05,600 --> 00:01:09,780

and then I'll see how many days do you need to complete the project.



16

00:01:09,890 --> 00:01:11,410

Let's say five business days.



17

00:01:11,450 --> 00:01:17,730

And the definition of business these aspart work the formula is Monday through Friday.



18

00:01:17,900 --> 00:01:24,670

So I put five and a close up but I can at a press Enter notice I'm getting 6th of January 2012.



19

00:01:24,770 --> 00:01:28,430

Now the question is which five have been chosen.



20

00:01:28,430 --> 00:01:34,880

Let me use a color combination if for example first of January that's a Sunday cannot be included as



21

00:01:34,880 --> 00:01:35,670

a business day.



22

00:01:35,810 --> 00:01:40,250

I go to the second of January and would Okola that.



23

00:01:40,430 --> 00:01:49,020

And you think Schottky I'm going to give a color blue note this second day is told of January next fall



24

00:01:49,090 --> 00:01:52,250

of January 1st of January 6th of January.



25

00:01:52,280 --> 00:01:58,670

So five business days it took to complete the project and the deadline happens to be 6th of January



26

00:01:58,670 --> 00:01:59,970

2012.



27

00:02:00,320 --> 00:02:06,720

Now this would be formula doesn't include the starting date even if that happens to be a working B.



28

00:02:06,860 --> 00:02:07,940

So just be careful.



29

00:02:08,000 --> 00:02:14,150

In case you wish to include the starting date you would have to make a manual adjustment in terms of



30

00:02:14,540 --> 00:02:22,230

simple deduction of one inside the formula which then tells you first of January 2012 being the deadline.



31

00:02:22,670 --> 00:02:27,710

Similarly as a corollary there's a formula called a network does what is it.



32

00:02:27,830 --> 00:02:33,630

It tries to find out between a start and indeed how many business deals are there.



33

00:02:33,890 --> 00:02:42,440

So for example if you write a formula equal to net to work these and the starting date let's say 30



34

00:02:42,520 --> 00:02:51,170

December coma the ending date the ending date is a sixth of January.



35

00:02:51,170 --> 00:02:58,870

I close the bracket and press enter it give me six which means what it does not only including the end



36

00:02:58,870 --> 00:02:59,540

date.



37

00:02:59,560 --> 00:03:00,910

Second third fourth fifth sixth.



38

00:03:00,940 --> 00:03:02,100

All five does in good.



39

00:03:02,260 --> 00:03:06,620

But it also includes the starting be some really give a color.



40

00:03:06,850 --> 00:03:13,240

So a network based formula to start as well as the end date is included both to calculate the number



41

00:03:13,240 --> 00:03:16,140

of business the line between that date range.



42

00:03:16,150 --> 00:03:22,420

So this was a very basic formula but amateur's for work the the network the formula in the next video



43

00:03:22,600 --> 00:03:31,000

I will show you that in 2010 Excel version you would have been introduced with a formula called work



44

00:03:31,030 --> 00:03:38,750

did not I I am willing to see how this is very important especially when there are different countries



45

00:03:38,750 --> 00:03:45,400

that follow Saturday or Sunday both to be on a date or it could be Friday is a holiday or could be just



46

00:03:45,400 --> 00:03:50,340

that that only Sunday the holiday in which gives Monday to Saturday is a business.



47

00:03:50,610 --> 00:03:51,860

Back in the next video.