Problem sorting Pivot Table according to date

Copper Contributor

Hi,

 

Attached my Excel Raw Data and resulted Pivot Table. I cannot find a way to sort pivot table row according to date. Have tried to change cell format to date and sorting after that but no luck. :)

My customer wants date in a format as shown in column B. 

Any help is appreciated, thanks!

 

PivotCaptureRawData.JPGPivotCapture.JPG

2 Replies

@MikkoS 

If the dates are not the real dates, the sorting will work as it should work because it will sort the text not the numbers.

Excel treats dates as real numbers so if your dates are not real dates, convert them into the real dates and then apply the custom formatting to the date as per your customer's requirements so that the dates in the cell will appear in the desired format but underneath the cells, the date will remain the real dates and you can sort the date column properly as well.

 

To know whether a date which looks like a date is real date or not, you can check it with the function ISNUMBER. e.g. if your date is in B2, in a blank cell, place the formula =ISNUMBER(B2). If the formula returns True that means the date in B2 is a real date but if the formula returns False, that simply means the date in B2 is a Text string which looks like a date but not a real date.

how am I supposed to get the date real dates formatting?

If the problem is in pivot table, how am I supposed to do?