Date format inconsistent in Zoom Usage Excel reports

[DianeRoscoe]

Hi, Im an admin user. I'm generating usage reports for a recurring meeting to find out if people registered have never attended or when they last attended. I generate the report for the month and then filter out the people who attended the recurring meeting that Im interested in, however, the date format of when they started is inconsistent. In some reports it is stored as mm/dd/yyyy hh:mm:ss date format but in other reports it is stored as text and then I cannot treat it as a date in excel formulas. Is there a way to make sure it is always generated as a date format?

Im using a microsoft windows PC