How to compare dates and return the difference between them?

Help
2

You can try this…

Define a variable with type System.DateTime.
Read your excel file with Excel Application Scope and Read range (Range " "), then store it as a Datatable output.
From Column 1, loop through each row store it as another variable
Add an IF loop to check if variable1.tostring equals variable2.tostring.
Check this post how to change variables in DateTime format

2 Likes