integer8 values

I have ran an AD cmdlet report which gives a lot of attributes about users, such as last logon dates. It output the results to a csv file, which i am trying to analyse via excel 2010. From what I have read, the output of what should be dates, is sometimes "Integer8 (64-bit numbers representing dates in UTC)".


I need a formula to compare these into dates (UK date format; dd/mm/yyyy) I can use and therefore analyse properly, as at present they are pretty useless.
Who is Participating?
KimputerConnect With a Mentor Commented:
In your Excel file, have a helper column with the formula:


Open in new window

Obviously, now this whole column is still unreadable (it's like 1420200000), but it will become readable after you select the column, and format it  it to Date with the  date format you need.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.