Return date as month and year

System

This discussion was created from comments split from: Formula - Return month as text from a date cell..

JShaikh

Hi @Cleversheet,
Kindly help if possible,
This is my Date Column16-Mar-2025 and I need an output for Month column as Mar'25. Can you suggest a formula for this

Paul Newcome

Try this:

=MID("12JanFebMarAprMayJunJulAugSepOctNovDec", MONTH([Date Column]@row) * 3, 3) + "'" + RIGHT(YEAR([Date Column]@row), 2)

Marcela

Hello @JShaikh, Just @mentioning you in case you missed the response above!