Get the month name in calculated column

May 7th, 2009 | Categories: SharePoint

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: ,