Hi Haseeb,
Nice Formula..
Thanks
Nikhil
On Mon, Apr 16, 2012 at 11:36 AM, Haseeb A wrote:
> Nikhil, One way:
>
> Assume date is in A2. So
>
> In B2 for the Curr Quarter.
>
> =TEXT(LOOKUP(MONTH(A2),{1,4,7,10})*29,"")
>
> Then in C2
>
> =TEXT((1&B2)+99,"")
>
> Copy across to E2.
>
>
> Se
Hi Anil,
Its very good formula made by Mr.Haseeb. 29 is used to pick the dates.
check below,
[image: Inline image 1]
like 28,30 also can use.
Regards,
MARIES.
On Mon, Apr 16, 2012 at 11:25 AM, anil panchal wrote:
> Dear All,
>
> Why Use *29???
>
> =TEXT(LOOKUP(MONTH(A2),{1,4,7,10})*
Dear All,
Why Use *29???
=TEXT(LOOKUP(MONTH(A2),{1,4,7,10})*29,"")
Thanks & Regards
Anil Kumar
113784
On Mon, Apr 16, 2012 at 11:36 AM, Haseeb A wrote:
> Nikhil, One way:
>
> Assume date is in A2. So
>
> In B2 for the Curr Quarter.
>
> =TEXT(LOOKUP(MONTH(A2),{1,4,7,10})*29,"
Nikhil, One way:
Assume date is in A2. So
In B2 for the Curr Quarter.
=TEXT(LOOKUP(MONTH(A2),{1,4,7,10})*29,"")
Then in C2
=TEXT((1&B2)+99,"")
Copy across to E2.
See the attached.
___
HTH, Haseeb
nikhil wrote:
>
> Now answer is right ,
>
> i.e. Date 01/05/2010 ( DD/MM/
Hi Hasseb,
Now answer is right ,
i.e. Date 01/05/2010 ( DD/MM/ ) Format ,
Currently it's showing Curr.Qtr = April ; Next Qtr = July ..it is ok
After July , Now I want Next Qtr = October ; Next Qtr = January
Nikhil
On Sun, Apr 15, 2012 at 11:07 PM, Haseeb A wrote:
> Nikhil,
>
> I got an
Nikhil,
I got answer July instead of April. There were two formulas in my last
reply. First one for Current Quarter, 2nd one for Next Quarter.
See the attached.
___
HTH, Haseeb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thr
Hi Haseeb,
Sorry , answer is wrong.
i.e. Dt.01/05/2010 ( DD/MM/ ) ,then Next Quarter should be July , here
it's display april..
Nikhil
On Sun, Apr 15, 2012 at 2:57 PM, Haseeb A wrote:
> Hello Nikhil,
>
> This will give the current quarter.
>
> =TEXT(LOOKUP(MONTH(A1),{1,4,7,10})*29,"mmm
