Comparing dates in an IF function
Could someone kindly give me some guidance on the below:
I have two columns, one a list of dates, and the other which is supposed to
show a 'Y' if the date in the same row is prior to a certain date e.g. 3rd
January 2005, and an 'N' if not.
My formula looks like this, but doesn't seem to work:
=IF(G2<03/01/2005,"Y","N") Any thoughts? TIA
|