Hi,

The problem is that Excel is helpfully converting 03/01/2005 to a number
(probably 3/2005). If you try

=IF(G2<datevalue("03/01/2005"),"Y","N")

if should work.

David Jessop

"Paula" wrote:

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