1

00:00:00,990 --> 00:00:06,870

Have everybody you're saying we talk about a form like each month something that is going to be very



2

00:00:06,870 --> 00:00:13,950

useful in case you are in any manner connected to the field of finance financial modeling investment



3

00:00:13,950 --> 00:00:20,960

banking accounting taxation and you'll soon find out what before discussing this formula.



4

00:00:20,970 --> 00:00:22,680

Let me illustrate some of the questions.



5

00:00:22,680 --> 00:00:25,770

Question number one on a hypothetical level.



6

00:00:25,860 --> 00:00:31,740

What if I want to find out any of the current month the month to which the deed pertains to.



7

00:00:31,950 --> 00:00:33,330

That was case number one.



8

00:00:33,510 --> 00:00:42,020

So for example I wish to have 21st December 2012 Here Top 40 my mistake 31 January 2012.



9

00:00:42,330 --> 00:00:45,130

Then I wish to have 30th September 2010.



10

00:00:45,180 --> 00:00:49,680

It's the end of the current month Case number two.



11

00:00:49,980 --> 00:00:56,910

What if I tell you that these are the invoice deals and thus tax related to this invoices must be submitted



12

00:00:56,910 --> 00:00:58,980

by 50 of the next month.



13

00:00:59,010 --> 00:01:08,880

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



14

00:01:08,880 --> 00:01:09,300

on.



15

00:01:09,510 --> 00:01:13,750

That was case study to case three where if I given.



16

00:01:13,780 --> 00:01:16,990

So indeed I wish to find out first of the current demand.



17

00:01:16,980 --> 00:01:20,910

So in this case first of September 2014.



18

00:01:21,300 --> 00:01:24,780

Now all this can be achieved through the formula of your month.



19

00:01:24,780 --> 00:01:26,960

So let me take a case by case basis.



20

00:01:27,020 --> 00:01:31,260

First guess I want end of current month so it ain't equal.



21

00:01:31,350 --> 00:01:33,680

Or M I press the tab.



22

00:01:34,020 --> 00:01:40,200

I choose the starting date and then it asks me how many months do you want to jump ahead before you



23

00:01:40,200 --> 00:01:41,720

find the end of the month.



24

00:01:41,940 --> 00:01:42,860

I say zero.



25

00:01:42,990 --> 00:01:43,960

Why zero.



26

00:01:44,130 --> 00:01:50,610

Because Halet given what it would have said for this particular day 17 January to 17 February and then



27

00:01:50,610 --> 00:01:53,430

finding the end of that segment being February did.



28

00:01:53,590 --> 00:01:55,480

So right now I want three four.



29

00:01:55,480 --> 00:02:03,790

John let me test with one until you get 29 the fair why 17 January jump one month ahead and you get



30

00:02:03,880 --> 00:02:08,430

end of the month 29 Fev K-Stew.



31

00:02:08,870 --> 00:02:11,150

I want 5th of next month.



32

00:02:11,150 --> 00:02:14,840

So how do they achieve this IRA equal to e or M.



33

00:02:14,900 --> 00:02:16,730

I press the tab key.



34

00:02:16,880 --> 00:02:23,720

I choose a starting date and then I put zero as expected it's going to give me end of the current month.



35

00:02:23,750 --> 00:02:28,180

But wait I'm just going to add plus 5 towards the formula.



36

00:02:28,320 --> 00:02:29,820

And that will give me what.



37

00:02:30,050 --> 00:02:30,700

Yes.



38

00:02:30,710 --> 00:02:37,030

First off next month notice any kind of calculation which involves 50 of next month 7th of next month's



39

00:02:37,030 --> 00:02:38,470

15th of next month.



40

00:02:38,570 --> 00:02:42,200

You can apply this formula K-Street.



41

00:02:42,620 --> 00:02:48,330

If you want to find out first off the current month first of current month.



42

00:02:48,590 --> 00:02:52,160

So how do I put that formula in.



43

00:02:52,310 --> 00:02:55,230

Let me say equal or m d.



44

00:02:55,400 --> 00:02:56,990

I choose the starting date.



45

00:02:57,140 --> 00:03:02,210

Now I give minus one what is mine is going to give me.



46

00:03:02,300 --> 00:03:07,580

Well it's going to give me thirty first of August 2014 in this case which means it is jumping back one



47

00:03:07,580 --> 00:03:14,050

month saying from then until September to do in the third of August and then 23rd of August because



48

00:03:14,110 --> 00:03:16,980

as a benchmark and then fine is the end of that month.



49

00:03:17,270 --> 00:03:18,640

Now this is not the answer.



50

00:03:18,710 --> 00:03:27,110

The final answer is when I simply add or additional one way to the end of this formula which means now



51

00:03:27,110 --> 00:03:29,820

first of September 2014.



52

00:03:29,840 --> 00:03:35,270

So notice how this combination can quickly change the scenario using simple formula.



53

00:03:35,300 --> 00:03:37,290

All month doctors.



54

00:03:37,430 --> 00:03:40,460

And trust me once in a while you will get to use this.