software

I am trying to find out if there is a formula in excel that would let me note
the word quot;completequot; 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

=IF(A1=quot;quot;,D1-C1,quot;Completequot;)quot;vtchiokimquot; wrote:

gt; I am trying to find out if there is a formula in excel that would let me note
gt; the word quot;completequot; in one cell if another cell has a date in it and if there
gt; is no date in the cell then a number is stated.
gt;
gt; Example:
gt;
gt; In A1: 12/13/05 or blank
gt; In B1: Number of days left to complete (D1-C1...these are dates) if A1 does
gt; not have a date
gt; In C1: todays date
gt; In D1: date needed

=IF(ISBLANK(A1),D1-C1,quot;Completequot;)
quot;vtchiokimquot; wrote:

gt; I am trying to find out if there is a formula in excel that would let me note
gt; the word quot;completequot; in one cell if another cell has a date in it and if there
gt; is no date in the cell then a number is stated.
gt;
gt; Example:
gt;
gt; In A1: 12/13/05 or blank
gt; In B1: Number of days left to complete (D1-C1...these are dates) if A1 does
gt; not have a date
gt; In C1: todays date
gt; In D1: date needed