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