Thanks to all for their suggestions - this formula will save me tons of time.

Rob

"Dave Peterson" wrote:

Another version:
="FY"&YEAR(A1)+MONTH(A1=10)&"--Q"&INT(1+MOD(MONTH(A1)-10,12)/3)

This returns:
FY2006--Q2
(nice for sorting, I think)

But if you want your string:
="Quarter "&INT(1+MOD(MONTH(A16)-10,12)/3)
&" FY"&TEXT(MOD(YEAR(A16)+MONTH(A16=10),1000),"00" )
(all one cell)


Rob wrote:

Hello,

I'm having problems with the following... my company has a 9/30 fiscal year
end. I am trying to create a formula that looks at a date that will be input
and will return the following:
- The fiscal quarter
- the fiscal year.
For example, A2 has a date of 10/28/06. I would like a formula to return
the fiscal quarter and year: Quarter 1 FY06.

Thanks in advance for your help!

--

Dave Peterson