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

Hi!

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: "") ?

Try this:

=IF(COUNTA(B2,O2)=0,"",IF(AND(B2<"",O2=""),0,TODA Y()-O2))

Biff

"Jan" wrote in message
...
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

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

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