Get month name and year from date

Closed
well - Aug 21, 2015 at 01:38 AM
vcoolio
Posts
1347
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
June 10, 2022
- 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

1 reply

vcoolio
Posts
1347
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
June 10, 2022
249
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