How about:

=A1=--"1/4/04"
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"John G" wrote in message
...
I want to create an IF statement that says if a cell value is equal to a set
date then "True" otherwise "False"
The formula used is:
=IF(A12="01/04/2004", "TRUE", "FALSE")
The value in A12 is 01/04/2004 (created by formatting cell to dd/mm/yyyy)
This returns "False" regardless of what I put in A12
I am using Excel 2000 on an XP Pro O/S.

Any help greatly appreciated.

Thanks