Hi Paul..........

My original formula anticipated that if H180 did not contain a date, that
the result of the formula would be a null, (ie: ""). That formula will not
work if the result is a zero, or any other character(s). If the result is a
zero or a null, try this version.......

=IF(OR(H180=0,H180=""),TEXT(E180-NOW(),"#")&" days","")

If it is actually something else, like the text, "Not Started Yet", then
the formula can be modified accordingly...........

Vaya con Dios,
Chuck, CABGx3



"paulrm906" wrote:


Thanks Chuck

For your suggestion for my formula and yes it works great but
unfortunately it will not work when I enter a formula in H180 even if
there is no result. If you have any further suggestions with the
formula with getting it to work with a formula in H180 I would
appreciate it very much as I have been trying to work this one out now
for some now.

Regards

Paul Maynard
Moscow
Russia


--
paulrm906
------------------------------------------------------------------------
paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776
View this thread: http://www.excelforum.com/showthread...hreadid=512259