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!