software

Excel 97.

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

I need a formula to evaluate as follows:

If B2 amp; O2 contain no value return quot;quot;, if B2 contains a value amp; 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

Hi!

gt;O2 is null

Null means different things to different people!

Does null mean an empty cell (no formulas, nothing), a number 0, or a blank
cell (formula blank: quot;quot;) ?

Try this:

=IF(COUNTA(B2,O2)=0,quot;quot;,IF(AND(B2lt;gt;quot;quot;,O2=quot;quot;),0,TODA Y()-O2))

Biff

quot;Janquot; gt; wrote in message
...
gt; Excel 97.
gt;
gt; Column/Row B2 = text value
gt; Column/Row O2 = Date value
gt;
gt; I need a formula to evaluate as follows:
gt;
gt; If B2 amp; O2 contain no value return quot;quot;, if B2 contains a value amp; O2 is null
gt; return 0 (zero), otherwise calculate today()-O2.
gt;
gt; I have been trying many variations of formulas to return the above results
gt; without any success. Can anyone advise on the correct formula to enter?
gt;
gt; TIA
gt; Jan
Hi Biff,Thank you...that appears to work as needed.

Jan

quot;Janquot; wrote:gt; Excel 97.
gt;
gt; Column/Row B2 = text value
gt; Column/Row O2 = Date value
gt;
gt; I need a formula to evaluate as follows:
gt;
gt; If B2 amp; O2 contain no value return quot;quot;, if B2 contains a value amp; O2 is null
gt; return 0 (zero), otherwise calculate today()-O2.
gt;
gt; I have been trying many variations of formulas to return the above results
gt; without any success. Can anyone advise on the correct formula to enter?
gt;
gt; TIA
gt; Jan

You're welocme. Thanks for the feedback!

Biff

quot;Janquot; gt; wrote in message
...
gt; Hi Biff,
gt;
gt;
gt; Thank you...that appears to work as needed.
gt;
gt; Jan
gt;
gt; quot;Janquot; wrote:
gt;
gt;
gt;gt; Excel 97.
gt;gt;
gt;gt; Column/Row B2 = text value
gt;gt; Column/Row O2 = Date value
gt;gt;
gt;gt; I need a formula to evaluate as follows:
gt;gt;
gt;gt; If B2 amp; O2 contain no value return quot;quot;, if B2 contains a value amp; O2 is
gt;gt; null
gt;gt; return 0 (zero), otherwise calculate today()-O2.
gt;gt;
gt;gt; I have been trying many variations of formulas to return the above
gt;gt; results
gt;gt; without any success. Can anyone advise on the correct formula to enter?
gt;gt;
gt;gt; TIA
gt;gt; Jan