Blog2003 ≫ How to convert an Excel date to a UNIX date

Excel stores a date as the number of days since the start of 1900, and UNIX as the number of seconds since the start of 1970, so the sum is:

$[unixTime](/wiki/#unix) = ( $[excelDate](/wiki/#excel) - 25569 ) * 24 * 60 * 60;
⬅️ :: ➡️

Paul Clarke's weblog - I live in A small town. Wed to Clare and father to two, I am a full stack web engineer, and I do js / Node, some ruby, python, php ect ect. I like pubs, running, eating, home-automation and other diy jiggery-pokery, history, tree stuff, Television, squirrels, pirates, lego, + TIME TRAVEL.