Hi,

I want to make an excel sheet, in which if i put the date of order I should get the Date of Delivery. Now the perimeters for calculating the Date of Delivery are:

1. The date of delivery is 4 working days from the date of order.
IMPORTANT : "4 working days."

2. The problem here is, How do I incorporate the Saturday, Sundays and the Festival Holidays of my company, into this formula.
I am ready to mark all the festval holidays in a calender. But how do I do it.

Hope I am clear with I want. Please come back doubts if any.

Waiting for responses.