Sorting Date Columns in Excel

Owned by Sean Connaghan (ITD)
Nov 02, 2017
2 min read

Follow the steps below when trying to sort dates in any SchedulePro export.  This would include Schedule Summary, Vendor Summary, Overdue Task, Work Orders, Issues 

Step-by-step guide

  1. Export your data
  3. Click "Yes" to the warning message
  5. Click "Enable Editing"
  7. Click "Sort and Filter", then Custom Sort, DO NOT CLICK Filter
  9. Select your column to sort, and the order, then click "OK"
  11. Select "Sort anything that looks like a number, as a number" then "OK" (This is the most important step)