Return dates based on julian weekday only calendar

[jguzman1990]

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!

[Bernie Deitrick]

The tricky part is you are re-inventing the wheel.

With 2/2/15 in cell A2, the formula

=WORKDAY(A2,4,$J$1:$J$19)

where J1:J19 have dates of holidays, will return the date 2/6

[jguzman1990]

well that was easy. I had no idea that formula existed.

Thank you!!!

[Bernie Deitrick]

oops - I forgot the blanks part:

=IF(A2="","",WORKDAY(A2,4,$J$1:$J$19))