we have used the get-aduser command to pull all attributes about all our user accounts. the output for the accountExpirationDate and accountExpires fields is in a bizarre format, e.g. "9223372036854770000", and I need a way, perhaps in excel, to convert it to a meaningful date. I have found a formula to covert the lastlogintimestamp to a meaningful date, so wondered if that would work here, or if anyone has any proven way of converting them.
I am also keen to understand what each field represents, e.g. if you add an expiry date for an AD account, which of accountExpirationDate and accountExpires would be populated?