Return Zero in Date Subtraction

[Celticshadow]

Hi All

I have a range of dates in a row extending to ten columns but sometimes not all cells in the row have a date (the cells with dates in are dependent on other cells - so if the dependent cell does not have a date it the cell returns 00-Jan-00).

If for example the first two cells in the row had two dates as attached how do I get the cell to return zero when subtracting one from the other.

Thanking you in advance.

Kind Regards

[TMS]

B6: =IF(B4<>0,A4-B4,0)

and drag across.

Regards