Converting date to year and month text
Solved/Closed
Related:
- Converting date to year and month text
- Convert m3u to mp3 - Guide
- How to convert free fire id facebook to google - Guide
- Convert mm/dd/yyyy to month and year in excel - Guide
- How to convert number to words in word - Guide
- Convert picture to shape powerpoint - Guide
3 responses
I'm by no means an Excel expert at all, however, I have come up with another possible solution...
=TEXT(A1, "mmm") & ". " & TEXT(A1, "yyyy")
This will translate 11/08/2008 in cell A1 as Nov. 2008. The day value can be any from 1 through 30 (for the month of November).
Hope it works!
=TEXT(A1, "mmm") & ". " & TEXT(A1, "yyyy")
This will translate 11/08/2008 in cell A1 as Nov. 2008. The day value can be any from 1 through 30 (for the month of November).
Hope it works!
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 1, 2010 at 02:30 PM
Jul 1, 2010 at 02:30 PM
Format the cell as YYYYMM
Excel can't handle dates without a day, but the following will convert a text input of "y-mmm" into a workable date:
=DATE(2000+LEFT(A7,FIND("-",A7)-1),MATCH(RIGHT(A7,3),{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)
Change A7 to whatever is required. You can then format the cell as mmm-yy or however you want to display it.
=DATE(2000+LEFT(A7,FIND("-",A7)-1),MATCH(RIGHT(A7,3),{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)
Change A7 to whatever is required. You can then format the cell as mmm-yy or however you want to display it.
Feb 20, 2012 at 04:20 PM
=TEXT(A1, "mmm. ") & TEXT(A1, "yyyy")
Feb 25, 2013 at 01:16 PM