Forum Discussion
IFS formula many conditions
Hello, Every month I pull a report of status on completed e-learnings compared to the deadline set for completing it. I am trying to make a template where I can paste the RAW data each time to sa...
after many hours of juggling, here are the updated formulas
=IF(L2="Not completed"; IF(TODAY()>M2; "Overdue"; IF(AND(M2<TODAY(); L2>M2); "Overdue"; "Still Time to Complete")); IF(L2>M2; "Overdue"; IF(L2<=M2; "Completed On Time"; "Still Time to Complete")))
| Start Date K2 | Completion Date L2 | Deadline (K2 + 30 days) M2 | Satus |
| 21/06/2023 | 21/06/2023 | 21/07/2023 | Completed On Time |
| 21/06/2023 | 16/08/2023 | 21/07/2023 | Overdue |
| 21/06/2023 | 21/07/2023 | 21/07/2023 | Completed On Time |
| 21/06/2023 | Not completed | 21/07/2023 | Overdue |
| 21/09/2023 | Not completed | 21/10/2023 | Still Time to Complete |