Fiscal quarters for two years...

[Ted McCastlain]

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!

 

[Guest]

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

 

[Guest]

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]

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