Trying to get the text value of the month. Created a calculated column with a return type of 'Date', but can get the result only for 'Created' field.

This works:


Result, successfully:

enter image description here

But this not:

=TEXT((MONTH([Start Time])),"MMMM")
=TEXT((MONTH(['Start Time'])),"MMMM")
=TEXT((MONTH('Start Time')),"MMMM")


update: Thank You for the response, Mohammed!

Strange that You have more columns in Your multiple lookup("Insert column" on right side). I don't have 'Start/End Date' columns there:

enter image description here

enter image description here

Maybe some feature needed..

enter image description here

I have publishing enabled on this site-collection.

  • 1
    You are welcome @Gennady, Are you sure you have created the start date column, could you share the columns list in list setting page – Mohamed El-Qassas MVP Jan 19 '18 at 13:36
  • 1
    My fail Mohamed! Your formula works. Thank You much! Friday.. – Gennady G Jan 19 '18 at 13:44

Try the below formula

=TEXT([Start Date],"MMMM")

Column Settings

enter image description here


enter image description here

Note If the Start Date is not already created in the list or it's Content-Type Columns, so it will not be listed in the columns list in the Calculated column setting because it's unsupported in the SharePoint 2010 / 2013 / 2016 calculated column.

For more details, check The supported and unsupported columns in SharePoint calculated column formula

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.