Get the month name in calculated column

May 7th, 2009 | Categories: SharePoint | Tags:

Before you go and make a long series of if clauses check the following:

If you need to get the month name from a date (and time) field, simply use the following formula:

=TEXT([DateField];"mmmm")

if you just need the three letters of the month name, replace “mmmm” with “mmm”. Now the problem may arise if you try to sort/group by month name. To keep them sorted, you can add the month number in front

=TEXT(month([DateField]); "00")&" "&TEXT([DateField];"mmmm")

Technorati Tags: ,
  1. Ken
    July 27th, 2009 at 17:28
    Reply | Quote | #1

    Instead of this:
    =TEXT([DateField];”mmmm”)

    Try:
    =TEXT([DateField],”mmmm”)

    … comma instead of semi-colon

    • Boris Gomiunik
      August 4th, 2009 at 20:45
      Reply | Quote | #2

      Exactly. It depends on your locale. If you’re using dot as a decimal separator, then the parameters separator in function becomes comma. In Slovenia, where I’m from the decimal separator is comma and thus you need function parameters separated by semicolon. Thanks for pointing out, Ken!

2 trackbacks