1

00:00:01,310 --> 00:00:05,320

It as a continuation to what they don't in the formula.



2

00:00:05,340 --> 00:00:12,780

Now let me discuss network based god I in this formula you would find in excel in 2010 and 13 as of



3

00:00:12,780 --> 00:00:13,350

now.



4

00:00:13,650 --> 00:00:14,250

So what is next.



5

00:00:14,250 --> 00:00:16,250

Well this Dot ain't real well.



6

00:00:16,740 --> 00:00:24,120

It tries to find out how many business does exist between two sets of data including both start.



7

00:00:24,180 --> 00:00:25,220

Indeed.



8

00:00:25,230 --> 00:00:33,210

So if you consider a start date to be 30 in December and end date to be late as June 6th of January



9

00:00:33,930 --> 00:00:36,700

between this and this date both included.



10

00:00:36,780 --> 00:00:42,460

How many working days are there assuming Saturday Sunday the holiday on account of being away again.



11

00:00:42,540 --> 00:00:47,970

And let's assume Monday is a holiday on account of being a separate holiday which I'm with right here



12

00:00:48,030 --> 00:00:50,220

second of Jan 2000.



13

00:00:50,350 --> 00:00:58,110

Well so now if I write the formula equal to net work days doctor I can deal.



14

00:00:58,740 --> 00:01:01,190

I choose the starting date.



15

00:01:01,470 --> 00:01:03,360

I choose the ending date.



16

00:01:03,530 --> 00:01:08,380

Ok then I define the weekend to be Saturday and Sunday both.



17

00:01:08,460 --> 00:01:15,720

So hence one and holiday list is this in fact you can also prepare a holiday list using the named range



18

00:01:15,810 --> 00:01:17,760

something which has been discussed later.



19

00:01:18,090 --> 00:01:21,810

I close the black kid into the Disney five working days.



20

00:01:21,810 --> 00:01:23,910

Let me find out this one.



21

00:01:24,000 --> 00:01:25,150

This is too.



22

00:01:25,350 --> 00:01:29,310

This is three next funding for and this is the fifth working day.



23

00:01:29,380 --> 00:01:35,310

So between the start and indeed both these included how many business these depending on the holidays



24

00:01:35,310 --> 00:01:40,970

that are included and depending on the fact that Saturday or Sunday or maybe just Sundays the weekend.



25

00:01:41,070 --> 00:01:43,590

That was the formula or networks or IMT.