Get month name and year from date
Closed
well
-
Aug 21, 2015 at 01:38 AM
vcoolio Posts 1364 Registration date Thursday July 24, 2014 Status Moderator Last seen February 10, 2023 - Aug 21, 2015 at 04:13 AM
vcoolio Posts 1364 Registration date Thursday July 24, 2014 Status Moderator Last seen February 10, 2023 - Aug 21, 2015 at 04:13 AM
Related:
- Get month name and year from date
- Date month year format in excel - Guide
- Is the first month of netflix free - Guide
- How to convert fraction into years and months - Office Software Forum
- Libreoffice calc get month from date ✓ - Excel Forum
- How to get the month wise and date wise data - Office Software Forum
1 reply
vcoolio
Posts
1364
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 10, 2023
252
Aug 21, 2015 at 04:13 AM
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.
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.