How to Group Dates in Pivot Tables in Excel (by Years, Months, Weeks)
Grouping Dates in a Pivot Table VERSUS Grouping Dates in the Source Data - Excel Campus


If your version of Excel allows you to add a timeline, you may not even need to group the dates at all; the timeline will do it for you - the dates don't even need to appear in the pivot table.
2022-01-18_151844.png






and:
2022-01-18_151701.png