I am trying to create a formula in excel (and am new to formula creation)
that will do the following:

- if the cell has the word "incomplete" in it, use today's date
- if the cell has a date in it, use that date
- take the difference of the date in that cell (either the date entered in
the cell, or today's date if "incomplete" is entered) and the date in another
cell

I don't have to have the word "incomplete" in the cell - the cell could be
blank, if it is easier.

Please help!

Robert