ExcelBanter - What formula converts date to month only

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - What formula converts date to month only (https://www.excelbanter.com/excel-discussion-misc-queries/26291-what-formula-converts-date-month-only.html)

[email protected]

What formula converts date to month only

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

"
oft.com wrote in message
...
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

All times are GMT +1. The time now is 05:15 AM.