Program Roster Report dates in excel
The Program Roster Report (there may be others, but this is the most pressing) spits out start and end dates in very strange format in Excel. The columns are not formatted as dates but as text. You can tell because you can't use date formats, and sorting goes alphabetically (month > day > year) rather than chronologically. Just reformatting does not seem to work - you have to actually add a new column with a datevalue(...) formula.
This report is one of the most used by end users, many of whom are not adept in Excel. Please fix the structure of the report so that the date columns are actually dates.
[GNRL-106] Program Roster has been updated to ensure the date format within the report can be sorted chronologically. The Program Roster article has been updated to include troubleshooting tips and tricks to ensure sorting in Excel is as expected. In addition to this update, the report has been updated to include an HoH filter prompt and bolded HoH formatting to quickly identify clients that are HoH or Household members.