Skip to content
Sheetwrite

Sheetwrite / Documentation

dateToSerial@sheetwrite/core

Convert a real UTC Date to the Excel 1900-system serial.

Convert a real UTC Date to the Excel 1900-system serial. It is the inverse of serialToDate except for synthetic serial 60, which JavaScript cannot represent as a Date. Construct calendar dates with Date.UTC(...) (or via parseDateInput) to avoid host-timezone shifts.

Declaration

function dateToSerial(date: Date): number