Get month name and year from date

Closed
well - 21 Aug 2015 à 01:38
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Moderator Last seen 6 September 2024 - 21 Aug 2015 à 04:13
Hello,



how do I can convert the date in to month name and year
ex. 01/05/2015 , I want to get month name as May and year 2015
pls help me, both want to get in one cell

1 response

vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Moderator Last seen 6 September 2024 262
21 Aug 2015 à 04:13
Hello Well,

High-light the cell (or range of cells) that have the dates you wish to convert. Right click then from the menu that appears, select "Format Cells". A Format Cells dialogue box will appear and from here, select "Custom". In the Type Box, type in the following:-

mmmm yyyy (there is a space in between )

Click OK.

I hope that this helps.

Cheerio,
vcoolio.