Converting date to year and month text
Solved/Closed
Related:
- Converting date to year and month text
- How to convert free fire id facebook to google - Guide
- Convert m3u to mp3 - Guide
- Convert mm/dd/yyyy to month and year in excel - Guide
- How to convert number to text 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 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
1 Jul 2010 à 14:30
1 Jul 2010 à 14:30
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.
20 Feb 2012 à 16:20
=TEXT(A1, "mmm. ") & TEXT(A1, "yyyy")
25 Feb 2013 à 13:16