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

The first two parts of your requirement are clear and can be accomplished as
follows. I don't understand the third parameter.

=if(isnumber(search(a1,"incomplete)),today(),if(is number(month(a1)),a1,if(...)))
--
Brevity is the soul of wit.


"Robert F" wrote:

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

=B1-IF(A1="incomplete",TODAY(),A1)
--
David Biddulph

"Robert F" <Robert wrote in message
...
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