I have a problem I am hoping someone can help me with. Here is what I am
calculating:
A = Work Completion Date
B = Fixed Price Date
C = Receipt Date
D = Invoice Date
E = Difference between A + B
F = Difference between A + C
G = Difference between A + D
H = Difference between B + C
I = Difference between C + D

For E the formula I am using is: =IF(B1=0,TODAY()-$A$1,B1-$A$1)
For F the formual I am using is: =IF(C1=0,TODAY()-$A$1,C1-$A$1)
For G the formula I am using is: =IF(D1=0,TODAY()-$A$1,D1-$A$1)
For H the formula I am using is: =C1-B1
For I the formula I am using is: =D1-C1

Things work except when A has no date in it. What do I add to my formula in
E-G to result in 0 or leaving the cell blank when that purchase order work
has not been completed? The results of these calculations will be used in
pivot tables, charts, and conditional formatting so the answers of 39,679 or
so that I get when this is the case, plays havoc in them. This is a backwards
AR tracking that I am tracking due to a vendor not billing us for work
completed in the contracted time period and I need to know how many days have
elapsed between the 4 dates to determine whether the invoice can be paid, or
needs to be penalized according to the contract.

Thank you