StudioX/ Calculating the difference between two days within a for each row

Help StudioX
, , , ,
1

Hey,

I have been desperately trying to resolve this issue for hours to no avail.

StudioX uses US date formatting by default, even if your excel is configured in another date formatting. I am trying to calculate the difference between two dates, that are formatted correctly in my file as dd/MM/yyyy. The automation will always use MM/dd/yyyy.

I have tried everything, and my most hopeful solution up to now has been creating a Date Reformatter sheet in the Project Notebook, which looks like this (formatting in my language):

image

Now, despite the excel function on each cell within each row of my iteration being along the lines of:
image

Apparently the output is:
image

When testing the same formula just using my a new blank excel file, I get the wanted result, which would be 57 (days). Help needed!

2

@Nikolaos_Brezas

Did you try using excel formula directly

and do a auto fill range to fill the formula all the way down?

cheers