Timeline for Convert YYYYMM to MMMYY
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 23, 2022 at 2:22 | history | edited | Taylor Raine | CC BY-SA 4.0 |
edited body
|
| Jun 17, 2020 at 9:04 | history | edited | CommunityBot |
Commonmark migration
|
|
| Apr 9, 2018 at 21:30 | history | edited | Taylor Raine | CC BY-SA 3.0 |
added 268 characters in body
|
| Apr 9, 2018 at 19:27 | comment | added | Engineer Toast |
Turns out the Excel formula can be 46 bytes: =UPPER(TEXT(RIGHT(A1,2)*28,"MMM"))&MID(A1,3,2)
|
|
| Apr 9, 2018 at 19:22 | comment | added | Engineer Toast |
48 bytes: ?UCase(MonthName(Right([A1],2),1))&Mid([A1],3,2)
|
|
| Apr 7, 2018 at 11:15 | comment | added | pajonk | Worth noting that Excel needs to be set to English, otherwise it returns locale-specific month name. | |
| Aug 13, 2017 at 19:35 | history | answered | Taylor Raine | CC BY-SA 3.0 |