There is no obvious solution available in SharePoint lists to filter list data based on month. However, we can create a calculated field to provide a column which would display Month info. Then we can use that month column to group data based on months.
Here is the simple 2 step procedure:
1. Create a new calculated field and use following formula to display month out of the modified date:
=TEXT(Modified,"MMMM")
This formula will display month extracted from "Modified" date.
2. Now, use this newly created column to filter list data in Groups.
That's it!
Further formatting options using =TEXT() function are:
November 2008 =TEXT([Modified],"mmmm")&" "&TEXT([Modified],"yyyy")
November 08 =TEXT([Modified],"mmmm")&" "&TEXT([Modified],"yy")
Nov 08 =TEXT([Modified],"mmm")&" "&TEXT([Modified],"yy")
10 08 =TEXT([Modified],"mm")&" "&TEXT([Modified],"yy")
10 08 =TEXT([Modified],"m")&" "&TEXT([Modified],"yy")
November Monday 2008 =TEXT([Modified],"mmmm")&" "&TEXT([Modified],"dddd")&" "&TEXT([Modified],"yyyy")
November Mon 2008 =TEXT([Modified],"mmmm")&" "&TEXT([Modified],"ddd")&" "&TEXT([Modified],"yyyy")
November 17 2008 =TEXT([Modified],"mmmm")&" "&TEXT([Modified],"dd")&" "&TEXT([Modified],"yyyy")
Monday November 17th, 2008 =TEXT([Modified],"dddd")&" "&TEXT([Modified],"mmmm")&" "&TEXT([Modified],"d")&"th, "&TEXT([Modified],"yyyy")
9b71cc0f-3242-45e9-86eb-23a2287c1d96|0|.0