Re: Last Search Date format in Search History.csv

[void]

Everything stores dates as FILETIMEs.

To convert a FILETIME to a date in excel, use the following formula:
=((C2-116444736000000000)/864000000000)+DATE(1970,1,1)
where C2 is the cell to convert from a FILETIME to date.

FILETIMEs are in UTC.

https://stackoverflow.com/questions/42135186/how-to-convert-a-filetime-to-an-excel-date

[NotNull]

Alternative:

Code: Select all

=C2 / ( 8,64 * 100000000000 ) - 109205