Hi
=IF(A1=2004,DATE(2003,12,1),"")

--
Regards
Frank Kabel
Frankfurt, Germany

"flotowntiger" schrieb im
Newsbeitrag ...
Can you have a cell return a value based on another cell's input. Ex:
If I
enter the year 2004 in a specific cell then I want another cell to
display
the date 12/01/03 or some other date or value that I would
pre-determine.