How to Convert Unix Date to Excel Date

preview_player
Показать описание
Formula

=(Cell with date code/86400)+25569+(-5/24)

Enjoy!
Рекомендации по теме
Комментарии
Автор

Hi, I think I have an error. What do I have to do now?

lambi
Автор

brother i have two dates in YYYYMMDDHHMM format and i want to calculate different between two times in min unix. Kindly help

f_mak