Is there a way to convert dates into their respective fiscal quarters. For
instance, if A2 = 10/15/07, I want A3 = Q3.

I'm doing this for a calendar quarter as opposed to a fiscal quarter. I'm
not sure of your fiscal calendar.

=IF(MONTH(A2)=10,"Q4",IF(MONTH(A2)=7,"Q3",IF(MON TH(A2)=4,"Q2","Q1")))

"Andrew" wrote:

Is there a way to convert dates into their respective fiscal quarters. For
instance, if A2 = 10/15/07, I want A3 = Q3.

Define your quarters:

Assume Q1 = 1/1/2007 to 3/31/2007, etc., etc.

So,
=IF(A110/1/2007,"Q4",IF(AND(A17/1/2007,A1<=9/30/2007),Q3,IF(AND(A14/1/2007,A1<7/1/2007),Q2,Q1)))

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Andrew" wrote:

Is there a way to convert dates into their respective fiscal quarters. For
instance, if A2 = 10/15/07, I want A3 = Q3.

Yes it can be done, I assume your fiscal years starts on April 1st

="Q"&INDEX({4;1;2;3},INT((MONTH(A2)+2)/3))


--
Regards,

Peo Sjoblom




"Andrew" wrote in message
...
Is there a way to convert dates into their respective fiscal quarters.
For
instance, if A2 = 10/15/07, I want A3 = Q3.

With a date in cell A1

Try something like this:
B1: ="Q"&CEILING(MONTH(A1)/12*4,1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Andrew" wrote:

Is there a way to convert dates into their respective fiscal quarters. For
instance, if A2 = 10/15/07, I want A3 = Q3.

For calendar quarters:

="Q"&CEILING(MONTH(A1)/3,1)

Biff

"Dave F" wrote in message
...
Define your quarters:

Assume Q1 = 1/1/2007 to 3/31/2007, etc., etc.

So,
=IF(A110/1/2007,"Q4",IF(AND(A17/1/2007,A1<=9/30/2007),Q3,IF(AND(A14/1/2007,A1<7/1/2007),Q2,Q1)))

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Andrew" wrote:

Is there a way to convert dates into their respective fiscal quarters.
For
instance, if A2 = 10/15/07, I want A3 = Q3.

Ooops! I totally missed the "fiscal year" situation.
Nice catch (and good solution), Peo!

***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

With a date in cell A1

Try something like this:
B1: ="Q"&CEILING(MONTH(A1)/12*4,1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Andrew" wrote:

Is there a way to convert dates into their respective fiscal quarters. For
instance, if A2 = 10/15/07, I want A3 = Q3.

"Peo Sjoblom" wrote...
Yes it can be done, I assume your fiscal years starts on April 1st

="Q"&INDEX({4;1;2;3},INT((MONTH(A2)+2)/3))

More generally, if the fiscal year beginning date (text in MM/DD
format) were given by the name FYBD, the fiscal quarter would be given
by

=TEXT((DATEDIF(FYBD&"/1904",$A2,"YM")+2)/3,"\Q0")