Formula for Month in words

Hi everyone seeking for a help please I'm making a helper column formula for month I want the result as Month - day- Year (October 28, 2025)

but it seems my formula doesn't work

is there any way to have this formula or result as

(October 28, 2025)

=IF(ISDATE([Refund Deadline]@row ), MONTHNAME(MONTH([Refund Deadline]@row )) + " " + RIGHT("0" + VALUE(DAY([Refund Deadline]@row )), 2) + ", " + VALUE(YEAR([Refund Deadline]@row )), "")

Find more posts tagged with

Sheets

Formulas

functionality

Accepted answers

All comments

Paul Newcome

For the full month name such as "January", you would use this:

=MID("01January02February03March04April05May06June07July08August09September10October11November12December13", FIND(RIGHT("0" + MONTH([Refund Deadline]@row), 2), "01January02February03March04April05May06June07July08August09September10October11November12December13") + 1, FIND(RIGHT("0" + (MONTH([Refund Deadline]@row) + 1)), "01January02February03March04April05May06June07July08August09September10October11November12December13") - (FIND(RIGHT("0" + MONTH([Refund Deadline]@row ), 2), "01January02February03March04April05May06June07July08August09September10October11November12December13") + 1))

For a three character such as "Jan":

=MID("12JanFebMarAprMayJunJulAugSepOctNovDec", MONTH([Refund Deadline]@row) * 3, 3)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.