Skip to content

Instantly share code, notes, and snippets.

@neufeldtech
Forked from christopherscott/ExcelToJsDate.js
Last active September 11, 2015 03:42
Show Gist options
  • Save neufeldtech/0e9564dbdea9e386696e to your computer and use it in GitHub Desktop.
Save neufeldtech/0e9564dbdea9e386696e to your computer and use it in GitHub Desktop.
Convert Excel date values to JavaScript date objects
// Convert Excel dates into JS date objects
//
// @param excelDate {Number}
// @return {Date}
function getJsDateFromExcel(excelDate) {
// JavaScript dates can be constructed by passing milliseconds
// since the Unix epoch (January 1, 1970) example: new Date(12312512312);
// 1. Subtract number of days between Jan 1, 1900 and Jan 1, 1970, plus 1 (Google "excel leap year bug")
// 2. Convert to milliseconds.
return new Date((excelDate - (25567 + 1))*86400*1000);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment