37684 Days

[Bob]

Example:

A B C
1 3-Mar-03 7-Mar-03 4
2 4-Mar-03 -37684
3 8-Mar-03 37688
4 5-Mar-03 2-Mar-03 -3

The formula correctly calculated -37684 / 37688. What I
would like to do is to have the formula display no value
when there is no date to subtract from. Is this possible?

The formula used: =B1-A1
Format: General

 

[Dan E]

Bob,

To show nothing if B1 is empty
=IF(B1="","",B1-A1)

To show nothing if either B1 or A1 is empty
=IF(OR(A1="",B1=""),"",5)

Dan E

 

[Dave R.]

You can tell it if either A or B is blank, put a blank there, otherwise do
it

+IF(OR(A1="",B1=""),"",B1-A1)