Pivot table date format

[kristell]

Hello - hope you are keeping well and can help me. I have 'googled' but all seem to be telling me to do what I have already done and it is not working.

I am using Windows 11 Excel version 2412

My pivot table shows dates from the data source as 01-Jan 02-Jan etc.,

The data in the pivot table is grouped - when not grouped the data shows as 01/01/2025 02/01/2025 etc.,

When I group back by days and it goes back to 01-Jan 02-Jan etc.,

Gone to field settings and changed to 'date' - but it doesn't change

See screenshots attached

Many thanks - in advance!

 

[etaf]

is the date in the raw data a real date or text
right click on one of the dates in the raw data itself and change to general - it should be a number

it looks like the date is left justified - which usually means text

 

[RoryA]

You'll need to extract the date part from the field in the source data (or a query linked to it) rather than grouping the dates in the pivot table, as that turns the days into text.