THANK YOU!!!!! You are awesome....
I took the = and if out instead of just the =.
Thank you again and again... you just saved me a lot of time!

Serendipity

"Max" wrote:

Let's take your original line, as an example:
For E the formula I am using is: =IF(B1=0,TODAY()-$A$1,B1-$A$1)

What I meant by the indicative:
=IF($A$1="","",<yourformula)

was to apply it like this:
=IF($A$1="","",IF(B1=0,TODAY()-$A$1,B1-$A$1))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---
"Serendipity" wrote:
I tried this with no luck.
=IF($T17="","",(V17=0,TODAY()-$T17,V17-$T17))
and
=IF($T17="","",V17=0,TODAY()-$T17,V17-$T17)

The formula that works except for the wrong answers is:

=IF(V17=0,TODAY()-$T17,V17-$T17)

V17 = no date
T17 = no date or with a date

and the answer I am getting is 39679 or in that neck of the woods.

What did I do wrong?

Thanks