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

⬆️Too many fields appear to be blank

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ʼs blog - I live in Hythe in Kent. Wed + father to two, I'm a full-stack web engineer, and I do js / node, some ruby, python, php ect ect. My hobbies are pubbing, parkrun, restaurants, home automation 🤖 and other diy jiggery-pokery, history, tree stuff, television, squirrels, pirates ☠️, lego, and TIME TRAVEL.