Set formula to convert an integer to date in JavaScript | SpreadJS

Background:

Using SpreadJS, our Javascript excel spreadsheet, users can convert an integer to a date using a formula.

This formula is: DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

This formula will extract the year by taking the last 4 digits: RIGHT(A1,4)

Extract the month by getting the 3rd and 4th digit using the function MID like so: MID(A1, 3, 2)

To extract the day, us the LEFT function to return the first 2 characters of the integer: LEFT(A1,4)

Steps to Complete:

1. Set 8-digit integer to cell A1

2. Set formula to cell A2 and have the formula point to cell A1

Getting Started:

Step 1: Set 8-digit integer to cell A1

Set the 8-digit integer, 20200617, to cell A1 to be converted to a date format

// integer to be converted in cell A1
activeSheet.setValue(0, 0, 20200617);

Step 2: Set formula to cell A2 and have the formula point to cell A1

Set the formula, =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)), to the cell A2 to take the integer in cell A1 and convert it to a date format

// set formula to convert int to date in cell B1
activeSheet.setFormula(0, 1, "=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))");