Get month name and year from date
[Closed]
Report
well
-
vcoolio
vcoolio
- Posts
- 1320
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- October 8, 2021
Related:
- Get month name and year from date
- How to pay monthly netflix - Guide
- Netflix one month free - 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
- Posts
- 1320
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- October 8, 2021
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.
