As you can see at How to Group Dates in Pivot Tables in Excel (by Years, Months, Weeks), you can define beginning and end of the period for grouping. If this does not work perhaps you do not have real dates ( left aligned in cell when NO manual alignment applies). then, by all means, follow Alan's suggestion

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post