﻿ Set formula to convert an integer to date in JavaScript | SpreadJS # 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))");``````

Mackenzie Albitz