I'm trying to create a formula that will tell management when an employee has been credentialed and can start. Credentialed will vary on which of the required items they already have and each item take a different amount of time to process. So, I'm trying to have it where for employee X they can say ok they have a license, and NPI but they are missing a DEA (4 Weeks processing, Medicaid (6 Weeks Processing) and Medicare (6 weeks processing). what is the estimated start date. I can't figure how to to do this. I keep getting the formula to add all of the estimated processing times but if I apply for lets say the Medicaid and medicare application on the same day they each take 6 weeks on average to process and approve so it should not be 12 weeks but really only 6 weeks from today, the only time it would be greater than 6 weeks is if I didn't apply for the applications on the same day, example, I apply for Medicaid today and 2 weeks in the furture I apply for the Medicare. Can anyone help please.