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