Convert date to Excel serial number

Forms SharePoint Online
1

Can the date be converted into excel serial number format? I am trying to convert the date and then store in a text field.

2

Hello @aseem,

You can try out this code:

function dateToExcelNumber(date) {
var serialNumber = 25569.0 + ((date.getTime() - (date.getTimezoneOffset() * 60 * 1000)) / (1000 * 60 * 60 * 24));
return serialNumber.toString().substr(0,20);
}

var dateToConvert = new Date(fd.field('Date').value);
fd.field('Title').value = dateToExcelNumber(dateToConvert);
3

Thanks @mnikitina it worked! Appreciate your help.

1 Like