Get month name and year from date

[Closed]
Report
-
Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
-
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

Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
239
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.