Hi

=IF(G2<DATE(2005,1,3),"Y","N")

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Paula" wrote in message
...
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