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.