Formula - Return month as text from a date cell.

Genevieve P.

@John C Murray

John C Murray

Aug 22, 2023

If you only need three digit month names the formula is much simpler:

=MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)

This is a fantastic solution - thanks for sharing!

Keli

I can't seem to get that solution to work. Could you post an example?

Keli

I have this date field 01/01/2024 and want another column to show Jan-24...is this possible?

Genevieve P.

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

Cleversheet

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.

John C Murray

Glad you liked it @Cleversheet.