Excel Write Range does not update columns with formulas associated with written cell

excel

#1

My bot writes a datatable(with existing data) into an excel workbook.

For simplicity, we assume the datatable only has 1 column of data(date), and the data will be written into column A of Sheet1.
At Column C of the same sheet, there is a formula already inplace, that takes the date in column A, and add a day to it.

So if cell A1 has 21/02/2018, cell C1 will be value 22/02/2018.

However, some of the columns are not reacting to the values in column A correctly. about every 10 rows, there is about 1 that has the same date at column C that has the same value as column A.
I wouldnt be able to upload the workflow here as it contains sensitive data.

Any help would be appreciated. Thanks.


#2

Can you upload excel sheet with some dummy data


#3

dummy excel.xlsx (17.5 KB)

Column A of sheet1 is compared with cell A1 of sheet2.

The formula in column B is basically:
if sheet 1 column A date is less than sheet2 cell A1, sheet 1 column B will show the date of sheet2 cell A.
if more, sheet1 columb B will be the date in sheet1 columb A