View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] bradlej@ntlworld.com is offline
external usenet poster
 
Posts: 2
Default 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?