Have everybody you're saying we talk about a form like each month something that is going to be very
useful in case you are in any manner connected to the field of finance financial modeling investment
banking accounting taxation and you'll soon find out what before discussing this formula.
Let me illustrate some of the questions.
Question number one on a hypothetical level.
What if I want to find out any of the current month the month to which the deed pertains to.
That was case number one.
So for example I wish to have 21st December 2012 Here Top 40 my mistake 31 January 2012.
Then I wish to have 30th September 2010.
It's the end of the current month Case number two.
What if I tell you that these are the invoice deals and thus tax related to this invoices must be submitted
by 50 of the next month.
So I wish to have the Didi's five of if 2012 I wish to have 5th of March 2000 11 in this case and so
on.
That was case study to case three where if I given.
So indeed I wish to find out first of the current demand.
So in this case first of September 2014.
Now all this can be achieved through the formula of your month.
So let me take a case by case basis.
First guess I want end of current month so it ain't equal.
Or M I press the tab.
I choose the starting date and then it asks me how many months do you want to jump ahead before you
find the end of the month.
I say zero.
Why zero.
Because Halet given what it would have said for this particular day 17 January to 17 February and then
finding the end of that segment being February did.
So right now I want three four.
John let me test with one until you get 29 the fair why 17 January jump one month ahead and you get
end of the month 29 Fev K-Stew.
I want 5th of next month.
So how do they achieve this IRA equal to e or M.
I press the tab key.
I choose a starting date and then I put zero as expected it's going to give me end of the current month.
But wait I'm just going to add plus 5 towards the formula.
And that will give me what.
Yes.
First off next month notice any kind of calculation which involves 50 of next month 7th of next month's
15th of next month.
You can apply this formula K-Street.
If you want to find out first off the current month first of current month.
So how do I put that formula in.
Let me say equal or m d.
I choose the starting date.
Now I give minus one what is mine is going to give me.
Well it's going to give me thirty first of August 2014 in this case which means it is jumping back one
month saying from then until September to do in the third of August and then 23rd of August because
as a benchmark and then fine is the end of that month.
Now this is not the answer.
The final answer is when I simply add or additional one way to the end of this formula which means now
first of September 2014.
So notice how this combination can quickly change the scenario using simple formula.
All month doctors.
And trust me once in a while you will get to use this.