Formula to find the target date from the start date with few criteria.

Hi All,

I have to find the target date from the start date but it should exclude weekends(saturday and sunday).

say example, i have two kinds of products milk and medicine.

i want to calculate the dispatch timings.So i am capturing the start_date and the target date.

For Milk, the target date should be start_date + 3 business days.
For Medicine, the target should be start_date + 7 business days.


But on the above both cases, the calculation should exculde the weekends between two dates(start date and target date).

start_date like 12/7/13 10:20 AM.

Thanks in Advance

Thinker