Formula - Return month as text from a date cell.
Answers
-
-
I can't seem to get that solution to work. Could you post an example?
-
I have this date field 01/01/2024 and want another column to show Jan-24...is this possible?
-
Hi @Keli
If you're looking directly at a Date field, you'll need to use a MONTH function to extract just the Month number and use the MID formula above like so:
=MID("JanFebMarAprMayJunJulAugSepOctNovDec", (MONTH(Date@row) * 3) - 2, 3)
If you need the year returned as well, you can + to add the YEAR function at the end:
=MID("JanFebMarAprMayJunJulAugSepOctNovDec", (MONTH(Date@row) * 3) - 2, 3) + "-" + RIGHT(YEAR(Date@row), 2)
Cheers,
Genevieve
-
This note is to underscore the brilliance of, and give credit to, @John C Murray’s Best Answer solution. Damn, wish I’d thought of that one!
I’ve cited him in my Smartsheet Arsenal (hodgepodge of tips and tricks), where his formula, and one adapted for 3-char weekdays, now lives. It’s also replaced the cumbersome nested-if formula that used to gobble system resources in my Days Calculator sample sheet, where John’s name is honored in the [Mth Alpha] column description.
-
Glad you liked it @Cleversheet.
Help Article Resources
Categories
Check out the Formula Handbook template!