PLEASE HELP: Date Formula Glitch

[janemarie100]

I have a spreadsheet which the cell calculates the number of days between dates found in two other cells.
It currently shows a weird number if one of the cells is blank, and I would like to show that cell blank when I dont have dates in the date cells.

Is there a formula for this?

Thanks,
Jane

 

[circledchicken]

Hi,

You could try the following assuming your dates are in A1 and A2 (where the part in bold is whatever formula you are using to return the number of days):

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

 

[janemarie100]

Thanks, that worked perfectly!!
I really appreciate the quick response!

 

[circledchicken]

Thanks, I'm glad it worked.