Calulating the number of days between two dates

[broncos347]

I am trying to calculate the no. of days between two dates (cols A and B). I have used the formula B-A to calculate the number of dates. However, I have some cells in the columns that do not have any dates yet.

Where I have a date in column A but not column B I would like to show a zero.

I also have some text in column A and a date I column B in this case I would also like to return a zero value.

Can anyone help?

 

[SteveO59L]

Something like

=IF(ISERROR(D8-C8),0,IF(D8="",0,D8-C8))

?

 

[broncos347]

Excellent, thanks.