Fiscal quarters for two years...
 

Here is what I am trying to do:

I have a sheet where I need to reference a date and determine what
fiscal quarter it is. Here is what is causing me a problem: I need to
include fiscal year 2008 and our fiscal year starts in April.

I had been using the formula
(="Q"&LOOKUP(MONTH(A1),{1,4,7,10},{4,1,2,3}) &"07") to break dates down
into quarters but that of course will not work when I roll around to
dates pertaining to FY08. I have tried variations of the above formula
but cannot get anything to work. Maybe an "if" variation of the above?

Thanks for the help!

Fiscal quarters for two years...
 

Ted,
This was posted by Dave Peterson when you originally asked this
question:

="Q"&INT(1+MOD(MONTH(A4)-4,12)/3)&RIGHT(YEAR(A4)+(MONTH(A4)=4),2)

HTH

"Ted McCastlain" wrote:

Here is what I am trying to do:

I have a sheet where I need to reference a date and determine what
fiscal quarter it is. Here is what is causing me a problem: I need to
include fiscal year 2008 and our fiscal year starts in April.

I had been using the formula
(="Q"&LOOKUP(MONTH(A1),{1,4,7,10},{4,1,2,3}) &"07") to break dates down
into quarters but that of course will not work when I roll around to
dates pertaining to FY08. I have tried variations of the above formula
but cannot get anything to work. Maybe an "if" variation of the above?

Thanks for the help!

Fiscal quarters for two years...
 

I do not know how I missed this but it worked like a champ. Thanks for
reposting this for me!

Toppers wrote:
Ted,
This was posted by Dave Peterson when you originally asked this
question:

="Q"&INT(1+MOD(MONTH(A4)-4,12)/3)&RIGHT(YEAR(A4)+(MONTH(A4)=4),2)

HTH

"Ted McCastlain" wrote:

Here is what I am trying to do:

I have a sheet where I need to reference a date and determine what
fiscal quarter it is. Here is what is causing me a problem: I need to
include fiscal year 2008 and our fiscal year starts in April.

I had been using the formula
(="Q"&LOOKUP(MONTH(A1),{1,4,7,10},{4,1,2,3}) &"07") to break dates down
into quarters but that of course will not work when I roll around to
dates pertaining to FY08. I have tried variations of the above formula
but cannot get anything to work. Maybe an "if" variation of the above?

Thanks for the help!