Hi,
Just teaching myself Pivot Tables and hit a wall.
My Aim - To show the number of days between two dates (Context - Data table shows date an enquiry was received and the date it was called, I want the Pivot Table to show the response time in days
Data...
Attachment 781535
1st attempt: PivotTable Analysis > Field Items and Sets > Creating Formula. As Shown below...
Attachment 781533
and the following happened...
Attachment 781536
I know if I change the Format It will display as the number of days but the issue is that G5 should have the same answer as G4 and it's showing 00/01/1900.
I thought maybe if the Pivot Table pulled through the data I could just do a Formula to calculate the difference but doing this still some how changes the date for Douglas to 00/01/1900 (as below)
Attachment 781537
Any help with this would be much appreciated. Lots of hits on google about this date but not in this way.
TIA
Bookmarks