Compare one column with other column of different excel


i have input date i need to compare this date with another excel sheet
example my date is 9 i need to check in another excel sheet whether 9th date as value “L” is or not
Templates1.xlsx (29.8 KB)


Not going to give you the direct answer :slight_smile:

Extract both dates into variables and then compare them.

You should use DateTime.Parse, DateTime.ParseExact in combination with DateTime.TryParseExact to ensure that the values you have imported are in a format that can be compared.

The hard part is converting them to dates - once you have done that you can use things like DateDiff to compare them.

Give it a try - shout if you get stuck and search the forum for examples.