IF command with In Progress, Overdue, and Closed results?
 

Hi All,

I have some date information, headings are Due Date, Actual Date
Returned, and Date Today.
I would like to use a formula to give the correct responses such as
Closed, In progress and Overdue.
If the actual date returned is filled in, I would like excel to return
"Closed", however if the actual date returned cell is empty, I would
like excel to check if the due date is less than Today and return
Overdue, or In progress if the date is in the future.

Is this possible?

IF command with In Progress, Overdue, and Closed results?
 

hi,
if your dates looked like this
columnA ColumnB columnC columnD
Row1 due date accual day today statuss
row2 1/8/2008 1/3/2008 1/4/2008 Closed
Row3 1/3/2008 1/4/2008 overdue
row 4 1/5/2008 1/4/2008 inprocess

use this formula.
=IF(B40,"Closed",IF(NOW()A4,"overdue","inprocess "))

regards
FST1


" wrote:

Hi All,

I have some date information, headings are Due Date, Actual Date
Returned, and Date Today.
I would like to use a formula to give the correct responses such as
Closed, In progress and Overdue.
If the actual date returned is filled in, I would like excel to return
"Closed", however if the actual date returned cell is empty, I would
like excel to check if the due date is less than Today and return
Overdue, or In progress if the date is in the future.

Is this possible?

IF command with In Progress, Overdue, and Closed results?
 

On 4 Jan, 13:58, FSt1 wrote:
hi,
if your dates looked like this
* * * * * * columnA * ColumnB * * columnC * * *columnD
Row1 * due date * accual day * *today * * * * statuss
row2 * 1/8/2008 * 1/3/2008 * * * 1/4/2008 * *Closed
Row3 * 1/3/2008 * * * * * * * 1/4/2008 * *overdue
row 4 * 1/5/2008 * * * * * * * * * * *1/4/2008 * *inprocess

use this formula.
=IF(B40,"Closed",IF(NOW()A4,"overdue","inprocess "))

regards
FST1



" wrote:
Hi All,

I have some date information, headings are Due Date, Actual Date
Returned, and Date Today.
I would like to use a formula to give the correct responses such as
Closed, In progress and Overdue.
If the actual date returned is filled in, I would like excel to return
"Closed", however if the actual date returned cell is empty, I would
like excel to check if the due date is less than Today and return
Overdue, or In progress if the date is in the future.

Is this possible?- Hide quoted text -

- Show quoted text -

Many Thanks
This works great!!!!

IF command with In Progress, Overdue, and Closed results?
 

glad to help/
regards
FSt1

" wrote:

On 4 Jan, 13:58, FSt1 wrote:
hi,
if your dates looked like this
columnA ColumnB columnC columnD
Row1 due date accual day today statuss
row2 1/8/2008 1/3/2008 1/4/2008 Closed
Row3 1/3/2008 1/4/2008 overdue
row 4 1/5/2008 1/4/2008 inprocess

use this formula.
=IF(B40,"Closed",IF(NOW()A4,"overdue","inprocess "))

regards
FST1



" wrote:
Hi All,

I have some date information, headings are Due Date, Actual Date
Returned, and Date Today.
I would like to use a formula to give the correct responses such as
Closed, In progress and Overdue.
If the actual date returned is filled in, I would like excel to return
"Closed", however if the actual date returned cell is empty, I would
like excel to check if the due date is less than Today and return
Overdue, or In progress if the date is in the future.

Is this possible?- Hide quoted text -

- Show quoted text -

Many Thanks
This works great!!!!