Excel: Formula for Multiple IFs condition


Hi, Please help your assistant for multiple ifs condition.

Due Date Status
1/23/2018 3:58:13 PM 1 - 2 weeks
2/13/2018 10:55:43 AM OK
1/29/2018 10:11:13 AM > 1 week
1/15/2018 3:58:13 PM 2 - 3 weeks
i want to have formula in column status based on due date and today, sample like above Please let me know if you need more details thanks in advance Reza


This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of January 31, 2018.


For more resources for Microsoft Excel