Excel/VBA date compare not working

[austenr]

I am having an issue where a certain date field in Excel sheet will not compare properly when checked in VBA.
I am only using a simple IF statement i.e.


If Sheets("Input + Wksheet").Range("D9").Value < "07/01/1996" Then


and the date keeps dropping in even when it IS greater than the criteria.
Can someone help me with the formatting mismatch from the Excel Sheet to the VBA code? Sample WB attached

[GTO]

Hi Austen,

I did not look at the file, but I think you want:

If Range("A1").Value < DateValue("07/01/1996") Then

Have a great day,

Mark

[austenr]

thanks Mark. That got it. Sometimes you stare at it too long you need a fresh set of eyes.

[GTO]

...Sometimes you stare at it too long you need a fresh set of eyes.

Trust me, I am all too painfully aware of my own tired eyes :bug: (what a week!)