Forum Discussion
IF Function
Hello! I have to indicate overdue status to passed date if status is not paid. could you please help me.
Hi Zhazira,
Good day to you,
Please find formula for solution. Please test the formula once again before you execute.
The formula is combination of IF, IF AND programme and using DATEVALUE function.
The due date you have not mentioned so I have taken today date i.e 09/05/2017 this is one of main criteria to test the formula.
IF(A2<DATEVALUE("09/05/2017"),"NOT OVERDUE",IF(AND(A2>=DATEVALUE("09/05/2017"),B2="NOT PAID"),"OVERDUE","NOT OVERDUE"))
| Date | Status | Result | Criteria: "Due date is 09/05/2017". | ||||
| 01-May-17 | PAID | NOT OVERDUE | |||||
| 09-May-17 | PAID | NOT OVERDUE | |||||
| 01-May-17 | Not Paid | NOT OVERDUE | |||||
| 09-May-17 | Not Paid | OVERDUE |
Please revert back if you found anything wrong or need any further assistance.
Regards,
Manoj P.