Change Past Date into Month as Written Text

Phil Parks · 05/24/21

Probably a simply question but I'm looking for a formula that is able to read dates in the past, and then fill a different cell with the month as text only.

e.g. The first 'offline' date would populate the offline month with 'October'

Thanks

Andrée Starå · 05/24/21

Hi @Phil Parks

I hope you're well and safe!

Try something like this.

=

IF(MONTH(Offline@row) = 1; "January";

IF(MONTH(Offline@row) = 2; "February";

IF(MONTH(Offline@row) = 3; "March";

IF(MONTH(Offline@row) = 4; "April";

IF(MONTH(Offline@row) = 5; "May";

IF(MONTH(Offline@row) = 6; "June";

IF(MONTH(Offline@row) = 7; "July";

IF(MONTH(Offline@row) = 8; "August";

IF(MONTH(Offline@row) = 9; "September";

IF(MONTH(Offline@row) = 10; "October";

IF(MONTH(Offline@row) = 11; "November";

IF(MONTH(Offline@row) = 12; "December"))))))))))))

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå · 05/24/21