Hi @TomHam ,
This is by default behavior in PivotTable, I tested the Group feature, grouped by the Days and Months:
"dates are treated as text" No, it is not treated as Text, as you can see it is formatted as Date:
You should change the source data, add all days in table.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.