Hi Experts,
Do we have excel formula to calculate Fiscal Period from the date.
Ex:
[cid:image001.png@01CE8E07.35F27340]
Regards,
Krishnaraddi V Madolli.
CONFIDENTIALITY NOTICE: This message and any attachment are confidential and
may also be privileged. If you are not the intended recipient
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:
** **
** **
Regards,
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(EXP(E:RT)) in
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
, 2013 4:01 PM
Subject: $$Excel-Macros$$ Fiscal Period calculation
Hi Experts,
Do we have excel formula to calculate Fiscal Period from the date.
Ex:
Regards,
Krishnaraddi V Madolli.
CONFIDENTIALITY NOTICE: This message and any attachment are confidential and
may also be privileged
Dear Krishna,
Try it
*=QINT((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:
Hi Experts,
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