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 Commented Jan 19, 2018 at 13:36
  • 1
    My fail Mohamed! Your formula works. Thank You much! Friday..
    – Gennady G
    Commented Jan 19, 2018 at 13:44

1 Answer 1


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 and acknowledge you have read our privacy policy.

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