Hello there everybody another formula from the dead cluster.
That is one of my favorites is Editta formula.
And let me illustrate to Redus example where Edith formula can be used.
Now take for instance on 1st of January 2012 or so that leaves expired a certain agreement expired.
Now there are two ways in within which I need to find out that this needs to be renewed so the agreement
might say within 30 days of expiry of the date.
Or it might seem within one month of that being expired.
Now these two are very different things.
If you take for instance first of January 2012 and if you want to find out 30 years from now you can
simply choose the date and add plus 3 0.
Correct.
But if you want one month hence then the meaning is first Jan then Gullu first of February.
Now this will become more prominent if you take a date of the month which doesn't have 30 days.
For example February 14th from 14th February 2012 to 15 much notice.
It is a one day gap because we're discovering this now.
Same thing if I calculate using a technique called date it's going to give me an answer for.
Of March to which I mean did that or at one these for Greece.
But that should be based on my description.
So let's see how this is achieved.
I go to the sale Irais the formula that it asks me the starting date which I gladly provide and then
it asks me how many months do you want to jump.
When I put one and I close the bracket.
It says from 14 FEBE jumped to the next month the 14th of March.
So this is how he did I the basic target level calculates.
Now let me give you two case studies case study one where if a person has joined a certain company if
you stick around for five years continuously he's going to be given up loyalty bonus.
Now when I wish to calculate that I don't want to do that.
And then I do this combination of formula that says five years into 365 days.
Why.
Because 365 days is the number which doesn't reflect the leap year which might occur in one of the five
years.
Correct.
So now you've equal you idiot.
I choose the date and then I wish to jump how many months.
Sixty six.
Because five years has 60 months in total of five injured people do not seem to five because that would
be taken as months hence finally multiplied with 12.
So for January 2017 this particular employee will complete five years of his employment in that company
and hence eligible to get a bonus.
Similarly if I go to Case do let's say 60 is the age of retirement date of birth.
In this case happens to be first of January 1976.
I wanted to find out when is this employee going to go down to 60.
So I did I choose it then I bought 60 multiplied with 12 which means 720 months.
So on 2036 let me see if we change the format from her control fee and here for my I go to form and
says all good to pay special pay special what format.
OK.
Now 2036 for January is the date on which he done 60.
So any kind offer beyond the base calculation one month from now two months from now 16 months from
now you can use the formula.
And I've given certain examples but you do go to them and this is when are you need for stance.