I have a date field in a SharePoint 2013 list that contains the date only. I a View, I want to be able to group by Month and year.
I added 2 calculated columns and extracted the month and year. The date field is ClosingDate.
I used =Month([ClosingDate]) and it extracted the number of the month. I want the name of the month.
I used =Year([ClosingDate]) and it extracted the year, but if it is stored as a number, it puts a comma in the date i.e. 2,015.
In my View, I want to group by month and year. I know I am off with what I am doing. Is there a better way to do this other than what I am doing incorrectly?