Get month name and year from date
Closed
well
-
Aug 21, 2015 at 01:38 AM
vcoolio
vcoolio
- Posts
- 1347
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- June 10, 2022
Related:
- Get month name and year from date
- Netflix 1 month free - Guide
- How to change month format in excel - Guide
- How to calculate monthly attendance percentage in excel - Forum - Excel
- PHP - Last day of the month/Number of days in the month - How-To - PHP
- Excel - Color cells for specific days in a month - How-To - Excel
1 reply
vcoolio
Aug 21, 2015 at 04:13 AM
- Posts
- 1347
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- June 10, 2022
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.
