As you will have seen, in your formula Excel will treat your "date" as 23
minus Aug minus 7 (and object with a #NAME error unless Aug is a defined
name). If you wanted Excel to recognise the date, you could use a modified
version of the formula
=IF(TRUE,--"23-Aug-07","")
but of course it is a fairly pointless IF statement, as TRUE is always true
so the condition is always met.
--
David Biddulph

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