I am trying to find out if there is a formula in excel that would let me note
the word "complete" in one cell if another cell has a date in it and if there
is no date in the cell then a number is stated.

Example:

In A1: 12/13/05 or blank
In B1: Number of days left to complete (D1-C1...these are dates) if A1 does
not have a date
In C1: todays date
In D1: date needed