calculate lastlogon date with CSVDE

=IF(C2>0,C2/(8.64*10^11) – 109205,””)


C2 is the cell that contains the Timestamp.

The If() statement hides the value if the user has not logged in.

(8.64*10^11) is the number of nanoseconds in a day divided by 100.

109205 is the number of days, including leap days, between 1601 and 1900. (Remember, 1900 is when excel dates “start”)

Leave a Comment

NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>