Calculating due dates on possible blank cells

[toxicatom]

Within large sheet I am trying to calculate "Invoice Due" dates dynamically using 3 sets of data.

Terms:
Deadline - the number of calendar days we have to deliver an invoice.
Cancel Date - the date a client requests we stop work.
Closed Date - the date we complete requested work.
Invoice Due - the Sum of (Deadline and Cancel Date) or (Deadline and Closed Date).

I only want a "Billing Due" entry populated if they cancel or close the work. Appreciate the help.

Please Login or Register  to view this content.

[Andrew-R]

Assuming the columns you show are A-D with the data starting at row 2 then in D2 put:

=IF(AND(B2="",C2=""),"",A2+MAX(B2,C2))

[toxicatom]

Thanks for the quick reply.