1

00:00:00,850 --> 00:00:05,270

Hello there everybody another formula from the dead cluster.



2

00:00:05,410 --> 00:00:08,950

That is one of my favorites is Editta formula.



3

00:00:09,220 --> 00:00:13,850

And let me illustrate to Redus example where Edith formula can be used.



4

00:00:13,850 --> 00:00:21,580

Now take for instance on 1st of January 2012 or so that leaves expired a certain agreement expired.



5

00:00:21,920 --> 00:00:30,010

Now there are two ways in within which I need to find out that this needs to be renewed so the agreement



6

00:00:30,010 --> 00:00:33,370

might say within 30 days of expiry of the date.



7

00:00:33,550 --> 00:00:37,410

Or it might seem within one month of that being expired.



8

00:00:37,540 --> 00:00:40,170

Now these two are very different things.



9

00:00:40,330 --> 00:00:45,670

If you take for instance first of January 2012 and if you want to find out 30 years from now you can



10

00:00:45,670 --> 00:00:48,770

simply choose the date and add plus 3 0.



11

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

Correct.



12

00:00:50,800 --> 00:00:58,990

But if you want one month hence then the meaning is first Jan then Gullu first of February.



13

00:00:58,990 --> 00:01:04,810

Now this will become more prominent if you take a date of the month which doesn't have 30 days.



14

00:01:04,810 --> 00:01:14,040

For example February 14th from 14th February 2012 to 15 much notice.



15

00:01:14,140 --> 00:01:18,110

It is a one day gap because we're discovering this now.



16

00:01:18,250 --> 00:01:23,590

Same thing if I calculate using a technique called date it's going to give me an answer for.



17

00:01:23,650 --> 00:01:27,890

Of March to which I mean did that or at one these for Greece.



18

00:01:27,970 --> 00:01:30,910

But that should be based on my description.



19

00:01:30,910 --> 00:01:32,880

So let's see how this is achieved.



20

00:01:33,040 --> 00:01:39,960

I go to the sale Irais the formula that it asks me the starting date which I gladly provide and then



21

00:01:39,960 --> 00:01:43,130

it asks me how many months do you want to jump.



22

00:01:43,180 --> 00:01:45,060

When I put one and I close the bracket.



23

00:01:45,060 --> 00:01:51,600

It says from 14 FEBE jumped to the next month the 14th of March.



24

00:01:51,600 --> 00:01:55,960

So this is how he did I the basic target level calculates.



25

00:01:55,980 --> 00:02:02,050

Now let me give you two case studies case study one where if a person has joined a certain company if



26

00:02:02,130 --> 00:02:08,040

you stick around for five years continuously he's going to be given up loyalty bonus.



27

00:02:08,070 --> 00:02:12,300

Now when I wish to calculate that I don't want to do that.



28

00:02:12,360 --> 00:02:17,760

And then I do this combination of formula that says five years into 365 days.



29

00:02:17,760 --> 00:02:18,470

Why.



30

00:02:18,480 --> 00:02:25,980

Because 365 days is the number which doesn't reflect the leap year which might occur in one of the five



31

00:02:25,980 --> 00:02:26,810

years.



32

00:02:26,850 --> 00:02:27,490

Correct.



33

00:02:27,720 --> 00:02:30,550

So now you've equal you idiot.



34

00:02:30,750 --> 00:02:35,010

I choose the date and then I wish to jump how many months.



35

00:02:35,010 --> 00:02:36,580

Sixty six.



36

00:02:36,780 --> 00:02:43,590

Because five years has 60 months in total of five injured people do not seem to five because that would



37

00:02:43,590 --> 00:02:46,860

be taken as months hence finally multiplied with 12.



38

00:02:47,040 --> 00:02:54,990

So for January 2017 this particular employee will complete five years of his employment in that company



39

00:02:55,080 --> 00:02:57,990

and hence eligible to get a bonus.



40

00:02:57,990 --> 00:03:04,130

Similarly if I go to Case do let's say 60 is the age of retirement date of birth.



41

00:03:04,130 --> 00:03:07,310

In this case happens to be first of January 1976.



42

00:03:07,470 --> 00:03:11,220

I wanted to find out when is this employee going to go down to 60.



43

00:03:11,400 --> 00:03:21,580

So I did I choose it then I bought 60 multiplied with 12 which means 720 months.



44

00:03:21,750 --> 00:03:30,060

So on 2036 let me see if we change the format from her control fee and here for my I go to form and



45

00:03:30,060 --> 00:03:33,230

says all good to pay special pay special what format.



46

00:03:33,360 --> 00:03:34,270

OK.



47

00:03:34,470 --> 00:03:38,840

Now 2036 for January is the date on which he done 60.



48

00:03:38,850 --> 00:03:45,270

So any kind offer beyond the base calculation one month from now two months from now 16 months from



49

00:03:45,270 --> 00:03:48,100

now you can use the formula.



50

00:03:48,210 --> 00:03:54,540

And I've given certain examples but you do go to them and this is when are you need for stance.