Posted on 2016-11-25
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.