Doing Date Subtraction in Excel

[ppr (Peter Preuss)]

@Hendrix_Santos

do I have to take the Excel column(“Date”) and transform a datetime to be able to make this comparison between dates and years?

Yes

Let’s assume first digit is the month and the values are within the data table similar to excel

otherwise we use ParseExact to get more control (e.g. first digit is day)

And for checking what is inside the data table after read range / adopting the parsing format we can do:
[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum