I want to convert a date to year - month ie 15-05-2005 to (2005 May) I don't
want to use the format option as I need to use a pivot table, and that would
still use the original date.

I am using Excel 97

Thank you for your help

Michael