Is there a way to convert dates in report data exported to excel to a date format, so that they may be sorted sequentially?
I would like to be able to combine my accounts payable aging detail and accounts receivable aging detail into one excel report as part of my cash balance forecasting. This is an easy exercise, except that once exported to excel I cant seem to determine how to get my due dates to convert to an actual date format - this is necessary in order for me to sort the data together by due date.
Has anyone played with exported data and able to answer this for me? Ive tried all of the functions I can think of.