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

Riham

New member
Joined
Jan 22, 2013
Messages
2
Reaction score
0
Points
0
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?
 
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)
 
Back
Top