Could you suggest a formula to look at the value of one cell and, if the
value of that cell is 00/00/0000 (a cell formated as a date field), look at
the value of another cell and make a calculation?

I posted this previously, but was not specific about the 00/00/0000 cell value

Thanks.