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

  • Thread starter Thread starter bradlej
  • Start date Start date
B

bradlej

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?
 
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(B4>0,"Closed",IF(NOW()>A4,"overdue","inprocess"))

regards
FST1
 
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(B4>0,"Closed",IF(NOW()>A4,"overdue","inprocess"))

regards
FST1







- Show quoted text -
Click to expand...

Many Thanks
This works great!!!!
 
Back
Top