I like this formula in general--if the fiscal year starts on the first of month
number #:
="FY"&YEAR(A1)-(MONTH(A1)<#)&"-Q"&INT(1+MOD(MONTH(A1)-#,12)/3)

So if the fiscal year starts on April 1st, then I'd use:
="FY"&YEAR(A1)-(MONTH(A1)<4)&"-Q"&INT(1+MOD(MONTH(A1)-4,12)/3)

I also like this style of result:
FY2009-Q1

You can fiddle around with the 1st, 2nd, 3rd, 4th stuff, but I wouldn't bother.

STEDIX wrote:

I am trying to develop a formula that would look at a date and return a value
based on that date.

For example, if the date was 4/15/09, it would return a value "FY2010 1st"

So the forumula would have to look at the date and based on a date range
return a value. I would want to have 4 quarters with a corresponding date
range. eg, 8/1/09 would return a value "FY2010 2nd" and so on.

I appreciate any help I can get.
--
Steve D

--

Dave Peterson