July 1, 2007 is quarter 1 of 2007???

I'd use another cell:

I find this formula easy to modify:
="FY"&YEAR(A1)-(MONTH(A1)<7)&"-Q"&INT(1+MOD(MONTH(A1)-7,12)/3)

It'll return:
FY2007-Q1

I find that I usually sort in chronological order and putting the year first
makes it easier to do that. (But you could swap it if you want.)



RichNYC wrote:

In a sales spreadsheet, the sale date is represented as a specific day
date...i.e 7/12/2006. I want to convert that date into a representative
quarter...like Q1FY07.
I tried formating the date as a month-year( Jul-06 ) and then doing a
find/replace to replace all Jul-06 with Q1FY07...but the date in the field is
actually still 7/12/2006, just formatted as Jul-06....so Find/Replace finds 0
records....help !!

--

Dave Peterson