SharePoint list formula fields – created month name

Few days back one our users wanted to group all the items in a MOSS list by the created month. I just created a new filed and made it a formula field and just applied the following, then used this field to group the list items.

=CHOOSE(MONTH(Created),”January”,”February”,”March”,”April”,”May”,”June”,”July”,”August”,
“September”,”October”,”November”,”December”)

Happy formula writing J

One thought on “SharePoint list formula fields – created month name

Leave a comment