SharePoint - Calculated month name

You can create a new calculated column (calcualtion based on other columns), and display the year, name of the month, etc. This is really useful for when you create views that group by year and/or month.


This formula gives you the name of the month, based on an existing data column in your list/library.

=TEXT([Modified],"MMMM")


This formula, will give you the name of the month, prefixed by the month number, from any date column in a list.

=IF(MONTH([Modified])<10,"0","")&MONTH([Modified])&" "&TEXT([Modified],"MMMM")


This one gives you the year, as a text. This helps so that the year doesn't get formatted as a number, with a comma.

=YEAR([Modified])&""



Tested compatibility: WSS 3.0.