Excluding Blank cells in Subtarction and the cell value is a Date

[Riham]

Hello,

I am using Excel 2007 and i have two columns one for an "expected date" and the other is for "actual date" and i want to subtract to highlight the extra days, anyway, some cells in the "expected date" column are blank and i want to exclude these cells from the formula, what can i do?

[saltarazan]

Consider column A is the "expected date" , and column B is the "actual date", column C the subtraction column.
Put this formula in the 1st cell of column C, then pull down for rest of the cells:
=IF(A1=""," ",A1-B1)

(Explanation: If cell A1 is blank, then leave the cell empty, else subtract A1-B1)

[Riham]

Thanxxxxxxxxxxxxxxxxxxxxxxx