SharePoint list view group by month and year

This SharePoint tutorial, we will discuss how to create a SharePoint list view group by month and year. Here we will see how we can use a calculated column to create the SharePoint list view group by month and year.

SharePoint list view group by month year

Here the requirement was to create a list view that will display items based on Year and Month in descending order in SharePoint Online. But the same approach can be followed to create a sharepoint list view group by month in SharePoint 2013/2016/2019 also.

First let us create two calculated columns in the SharePoint document library: one for Year (By Year) and one for Month (By Month).

For Year column, the formula will be:

=TEXT(Created,”yyyy”) and it should like below:

sharepoint list view group by month

For Month column, the formula will look like below:

=TEXT(Created,”mm”)&” “&TEXT(Created,”mmmm”) and it should be shown like below:

sharepoint list view group by year

Now create the view and in the SharePoint list view, the Group By condition, provide the two columns which we have created and it should look like below:

sharepoint list view group by calculated column

Finally, the SharePoint list view looks like below:

create sharepoint list view group by month

You may like following SharePoint tutorials:

This SharePoint tutorial, we learned how to create a SharePoint list view group by month and year.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

>