You're welocme. Thanks for the feedback!

Biff

"Jan" wrote in message
...
Hi Biff,


Thank you...that appears to work as needed.

Jan

"Jan" wrote:


Excel 97.

Column/Row B2 = text value
Column/Row O2 = Date value

I need a formula to evaluate as follows:

If B2 & O2 contain no value return "", if B2 contains a value & O2 is
null
return 0 (zero), otherwise calculate today()-O2.

I have been trying many variations of formulas to return the above
results
without any success. Can anyone advise on the correct formula to enter?

TIA
Jan