Get month name and year from date

Closed
well - Aug 21, 2015 at 01:38 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Aug 21, 2015 at 04:13 AM
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
Related:

1 response

vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
Aug 21, 2015 at 04:13 AM
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.
0