# Days Between Dates Formula Question

  • Thread starter Thread starter John
  • Start date Start date
J

John

Say I have two columns (A and B) containing dates and I want to know how
many days there are between the dates. I know that if I use the formula
=B1-A1 I'll get the number of days between the dates if the formula cell
is formatted as a number. However, say cell B1 does not contain a date
(not filled in yet) I get a huge negative number. I don't want that to
appear. I want a zero (0) to appear. Is there a simple formula that
will calculate the number of days between the dates yet result in a 0 if
column B doesn't have a date. Column A will always have a date in it.

Thanks,

John
 
DDM,
Thank you very much. Your formula works perfectly. I appreciate your kind
and quick help! :)

John
 
Frank,

Thanks for this formula. Both the one you provided and the one DDM
provided work great! Thanks again!

John
 
Back
Top