Skip to content

Instantly share code, notes, and snippets.

@kikill95

kikill95/ExcelToJsDate.js

Forked from christopherscott/ExcelToJsDate.js
Last active April 25, 2018 14:18
Show Gist options
  • Save kikill95/67303111b868ef6cab20f0478c3d1dfc to your computer and use it in GitHub Desktop.
Save kikill95/67303111b868ef6cab20f0478c3d1dfc to your computer and use it in GitHub Desktop.
Download ZIP
Convert Excel date values to JavaScript date objects
Raw
ExcelToJsDate.js
// 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 2 (Google "excel leap year bug")
// 2. Convert to milliseconds.
return new Date((excelDate - (25567 + 2))*86400*1000);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment