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!
|