Take date in double quotes ("23-Sep-07") and format cell to date.
let us know if it works.

"OssieMac" wrote:

Hi Eric,

Not sure that I really understand what you want but the following formula
tests the date in cell A1 and if it equals 23-Aug-07 the it inserts Yes else
it inserts No

=IF(A1=VALUE("23 Aug 2007"),"Yes","No")

Note: Because the VALUE function is converting an excel recognizable string
to a date then the format of the date in A1 does not have to match the format
of the date in the VALUE function.

Alternative Example where A1 is 23 Aug 2007 and value function using
different format. It still works:-

=IF(A1=VALUE("23/8/07"),"Yes","No")

Regards,

OssieMac




"Eric" wrote:

Does anyone have any suggestions on how to display date?

=If(True,23-Aug-07,"")
which is wrong statement in excel.
Does anyone have any suggestions on how to fix it?
Thanks in advance for any suggestions
Eric