SharePoint Events List – Group By Month

When showing a SharePoint Calendar control, the default view is the big “grid” of events.


But – there is another “view” that shows each item listed as with other SharePoint lists :


What would be nice is to have a group by “MONTH” so that you can have a text view, but easier to navigate.

Here’s what you need to do :

  • Click Settings > List Settings
  • Click Create Column
  • Enter a column name – eg. Month And Year
  • Change the Column Type to be “calculated”
  • Enter the formula as follows – basically formatting into YYYY-MMM format

=TEXT([Start Time],"MM-yyyy")

Now that the column is in place, it can be used in a “GROUP BY”.

  • Click on the View drop-down
  • Choose Create View


  • Click Standard View
  • Enter a name for the View  (eg. By Month)
  • Scroll down to the section for “Group By”
  • Expand, and choose the new column


  • Click OK to save the View details

The view should then display the list of events – grouped/sorted BY MONTH :


Nice, eh ?


One thought on “SharePoint Events List – Group By Month

  1. z September 25, 2014 / 5:32 am

    First of all I would like to say fantastic blog! I had a quick question in which I’d
    like to ask if you don’t mind. I was interested to find out how you center
    yourself and clear your thoughts prior to writing.
    I have had trouble clearing my mind in getting my ideas out there.

    I do take pleasure in writing however it just seems like the first 10
    to 15 minutes are generally lost simply just trying to figure out how to begin. Any ideas or hints?


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s