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
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.