excel-date-to-js

Convert Excel date in integer format into JS date. Dates are stored as numbers in Excel and count the number of days since January 0, 1900 (1900 standard, for mac it is 1904, which means January 0, 1904 is the start date). Times are handled internally as

Usage no npm install needed!

<script type="module">
  import excelDateToJs from 'https://cdn.skypack.dev/excel-date-to-js';
</script>

README

excel-date-to-js

CI Version Documentation Maintenance License: MIT

Description

Converts Excel date in integer format into JS date. Dates are stored as numbers in Excel and count the number of days since January 0, 1900 (1900 standard, for mac it is 1904, which means January 0, 1904 is the start date). Times are handled internally as numbers between 0 and 1.

Install

npm install -s excel-date-to-js

Usage

const { getJsDateFromExcel } = require("excel-date-to-js");
getJsDateFromExcel("42510");
// 2016-05-20T00:00:00.000Z

Inspired by...