If a cell contains a date then sum

[Cleric82]

Hi

I am trying to get a formula to work. I want to calculate the sum cells A1-B1 if cell C1 contains a date. If C1 is blank then I want a 0 value.

Thanks

[Phuocam]

Try this ...

=IF(ISBLANK(C1),0,SUM(A1:B1))

[PFDave]

=IF(C1="",0,A1-B1)

Should do the trick

[Cleric82]

thanks guys