1.0.2 • Published 5 months ago
excel-date-to-iso-string v1.0.2
Excel Date to ISO Date Converter
In Excel, dates are stored as serial numbers where the integer part represents the number of days since a specific base date (January 1, 1900, or January 1, 1904, depending on Excel settings), and the decimal part represents the fraction of the day.This npm package provides a utility function to convert Excel dates to ISO format while ignoring the timezone. It exports a single function, getISODateFromExcel
.
Installation
Install the package using npm:
npm install excel-date-to-iso
const { getISODateFromExcel } = require('excel-date-to-iso');
try {
// Replace with your Excel date
const excelDate = 44244;
// Convert Excel date to ISO format
const isoDate = getISODateFromExcel(excelDate);
// Output the result
console.log(`Excel Date: ${excelDate} => ISO Date: ${isoDate}`);
} catch (error) {
console.error(error.message);
}