Skip to content

Instantly share code, notes, and snippets.

@scottschreckengaust
Forked from christopherscott/ExcelToJsDate.js
Last active August 29, 2015 14:07
Show Gist options
  • Save scottschreckengaust/a37472c550fbcdcbf45b to your computer and use it in GitHub Desktop.
Save scottschreckengaust/a37472c550fbcdcbf45b to your computer and use it in GitHub Desktop.
// 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 Dec 30, 1899 and Jan 1, 1970
// 2. Convert to milliseconds.
if (isNaN(excelDate)) {
return excelDate;
} else {
return new Date((excelDate - 25569) * 86400 * 1000);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment