Hello Everyone,

I've been wracking my brain all day and I'm hoping someone can help me.

I need my worksheet to populate due dates based on the date materials are received. I manually enter the date that I receive the materials, and need my due date to auto populate in another column. The tricky part is that my due dates are in business days. I created a julian calendar that excludes the weekends to assist me.

Essentially I want to enter a date (IE 20 [February 2nd is the 20th workday of the year excluding my companies holidays]). and have it return 4 business days later. (2/6).

If possible i'd like the formula to produce a blank (" ") cell if the receive date is empty as well.

Can someone help me?

Thank you!