Skip to content

Latest commit

 

History

History
39 lines (31 loc) · 1.51 KB

README.md

File metadata and controls

39 lines (31 loc) · 1.51 KB
Raw

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...