January 18, 2019 12:54 pm
I need a formula that will return a date that does not include weekends or holidays.
Notification Date 1/18/19
Due Date (formula that counts 20 business days from the notification date and excludes holidays). It should return 2/16/19 because MLK day is on
January 10, 2019 2:57 pm
I am in the Medical Device industry. I am looking for some bench marking information around what a well rounded CAPA system Metric should look like.
For example: What is the typical percentage of CAPA types in your CAPA System. For example: Random numbers here:
October 5, 2018 5:02 pm
Please, I need help with a formula.
If the status is NOT Complete and the Due Date is IN THE PAST, "Missed". Otherwise it should indicate "On Track".
Status: NOT "Complete", AND Defined Due Date: "In the past", "Missed"
Status: NOT "Complete", AND Defined Due Date: "In the future", "On