What formula converts date to month only

[[email protected]]

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

[Bob Phillips]

=TEXT(A1,"yyyy mmmm")

--
HTH

Bob Phillips

"[email protected]"
<[email protected]@discussions.microsoft.com> wrote in message
news:[email protected]...
> 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