1

00:00:00,920 --> 00:00:01,640

Either.



2

00:00:02,010 --> 00:00:06,070

Now the question that I'm going to put forth is related to autofill feature.



3

00:00:06,120 --> 00:00:10,530

This was a question asked by one of the participants of my workshop program long time back.



4

00:00:10,560 --> 00:00:18,720

He said look when you are pulling any the light inside and if you choose failures you'll definitely



5

00:00:18,720 --> 00:00:20,460

get the you're in 4:34.



6

00:00:20,460 --> 00:00:24,150

December 10:34 December 11 12 13 14 and 15.



7

00:00:24,420 --> 00:00:26,370

But the point is what if.



8

00:00:26,400 --> 00:00:36,150

I wish that whenever I change the starting the let's say starting deal being thirty first March 2014.



9

00:00:36,210 --> 00:00:39,150

When I change that the other day should also change.



10

00:00:39,150 --> 00:00:44,530

Now that is not possible with all the fill feature that is possible though with a formula called the



11

00:00:44,570 --> 00:00:45,460

all month.



12

00:00:45,810 --> 00:00:54,090

So what it does in your month if I change it to the first March 2010 notice all the dates have jumped



13

00:00:54,090 --> 00:00:55,290

by three months.



14

00:00:55,350 --> 00:00:57,010

So showing the quarter ends.



15

00:00:57,240 --> 00:01:03,760

If you on your friends I just put well over 12 months hence if I wanted month end I just would one.



16

00:01:03,990 --> 00:01:09,420

So this is all one formula I would recommend that you watch in one of her videos that enable you to



17

00:01:09,510 --> 00:01:11,050

achieve this particular feature.