Add dates by Skipping user defined week ends and Public Holidays

[nagovind]

Dear All,

This is regarding adding dates

For ex. i have the date of 13.11.2013 in cell A1

I need to add 10 working days and get the result in B1 (26.11.2013)

In between this 10 working days i have 2 days weekend (Thu and Frid) and one public Holiday on 17.11.2013

How to calculate this in excel

Please advise

Actually i have to form a table for 1 year schedule

Please guide how to do this

Regards
Govind

 

[Hui]

Govind

Have a look at the Workday.intl function
It allows you to add a number of days to a date an use any combination of days as week ends and Holidays
Its is only available in excel 2010+

eg: =WORKDAY.INTL(A1,10,6,B2)
where B2 has 17/11/2013

I get 30/11/2013 as the correct answer not 26/11/2013

Refer below:

13-Nov Wed
14-Nov Thu
15-Nov Fri
16-Nov Sat
17-Nov Sun
18-Nov Mon
19-Nov Tue
20-Nov Wed
21-Nov Thu
22-Nov Fri
23-Nov Sat
24-Nov Sun
25-Nov Mon
26-Nov Tue
27-Nov Wed
28-Nov Thu
29-Nov Fri
30-Nov Sat

 

[nagovind]

Dear Hui,

Thank you very much

I got it

Thanks for your help

Sincerely
Govind