I have an excel file that's an export out of a phone system. The dates aren't recognized as dates by a pivot table. I need them to be dates in order to group them. I simply want to look at average call durations over a grouping of dates. Pretty simple but what's the best way to convert the dates to dates that are usable by pivot tables? I've attached the file in question.
Bookmarks