ExcelBanter - date to text

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

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

- - date to text (https://www.excelbanter.com/excel-discussion-misc-queries/225358-date-text.html)

Arain

date to text

I have a date format 10/1/2008 and 10/2/2008 which i want to convert to just
October 2008 and drop the day date completely . can i extract just the month
and the year and display it in text.

Appreciate your help

Niek Otten

date to text

Format Custom as "mmmm yyyy"
Or use the TEXT function:
=TEXT(A1,"mmmm yyyy")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Arain" wrote in message
...
I have a date format 10/1/2008 and 10/2/2008 which i want to convert to
just
October 2008 and drop the day date completely . can i extract just the
month
and the year and display it in text.

Appreciate your help

All times are GMT +1. The time now is 12:38 AM.