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!
Bookmarks