Thanks Noorain bai.
Regards,
Krishnaraddi V Madolli.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: 31 July 2013 17:49
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Fiscal Period calculation
Dear Krishna,
Try it
Dear Krishna,
Try it
*="Q"&INT((MONTH($A2)-1)/3)+1&"-"&TEXT($A2,"")*
or
*=LOOKUP(MONTH(A2),{1,4,7,10},{"Q1","Q2","Q3","Q4"})&"-"&TEXT($A2,"")*
see attachment for more clarity.
On Wed, Jul 31, 2013 at 4:01 PM, Krishnaraddi V. Madolli <
krishnaraddi.mado...@asia.xchanging.com> wrote
Use below formula or attached file
="Q"&IF(MONTH(A2)<4,1,IF(MONTH(A2)<7,2,IF(MONTH(A2)<10,3,4)))&"-"&YEAR(A2)
From: Krishnaraddi V. Madolli
To: "excel-macros@googlegroups.com"
Sent: Wednesday, July 31, 2013 4:01 PM
Subject: $$Excel-Macros$$ Fiscal Period calc
Thanks.
Regards,
Krishnaraddi V Madolli.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Gaurav Garg
Sent: 31 July 2013 16:13
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Fiscal Period calculation
find the formula
closing date
Fiscal
find the formula
closing date Fiscal Period1-Jan-12 Q1-2012
=+IF(MONTH(B6)<=3,"Q1",IF(MONTH(B6)<=6,"Q2",IF(MONTH(B6)<=9,"Q3",IF(MONTH(B6)<=12,"Q4",""&"-"&YEAR(B6)
2-May-12 Q2-20125-Sep-12 Q3-20126-Oct-12 Q4-2012
1-Jan-13 Q1-2013
--
Are you =EXP(E:RT) or =NOT(E
what is fiscal period?
I heard it first time.
On Wed, Jul 31, 2013 at 4:01 PM, Krishnaraddi V. Madolli <
krishnaraddi.mado...@asia.xchanging.com> wrote:
> Hi Experts,
>
> ** **
>
> Do we have excel formula to calculate Fiscal Period from the date.
>
> ** **
>
> Ex:
>
>
>
> ** *
Hey
Pl refer..
HTH//Vabs
On Wed, Jul 31, 2013 at 4:01 PM, Krishnaraddi V. Madolli <
krishnaraddi.mado...@asia.xchanging.com> wrote:
> Hi Experts,
>
> ** **
>
> Do we have excel formula to calculate Fiscal Period from the date.
>
> ** **
>
> Ex:
>
>
>
> ** **
>
> ** **
>
> Re
