Hi, thanks so much, both "date(2008,8,1)" and --"2008-8-1" mathod worked.

"Max" wrote:

Try it as: =IF(N83 --"2008-8-1",L5+E6-J56," not finalized")
--"2008-8-1" will resolve the text (2008-8-1) to a real date for evaluation
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik
---
"freebee" wrote:
Hi, I tried, but cell showed i5+e6-j56. My complete formula
is=IF(N832008-8-1,l5+e6-j56," not finalized") My N83 is set to today().
thanks.