On Fri, 14 Jan 2005 03:09:03 -0800, John G
wrote:

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

The problem is that the value in your IF statement is TEXT, and the value in
A12 is an Excel date, which means it is really a serial number displayed as
formatted.

One method which should work:

=IF(A12=DATE(2004,1,4), "TRUE", "FALSE")

for 4 January 2004


--ron