add days, excluding holidays but including weekends

[Afactor]

Hello,
I have excel 2010 and am trying to figure out how I can add x number of days to a specific start date. The calculation is to include weekends, but if the end date falls on a holiday go to the following day. Any help would be greatly appreciated!!!

Thanks

 

[admiral100]

Hi,

give this a try ....

=WORKDAY.INTL(A2,B2,"0000000",holidays)

 

[Afactor]

Thanks for the response. I tried you suggestion but the only problem is that it extends the end date if there is a holiday anywhere in between the start and end date. I am thinking I might need to do a nested if function

 

[admiral100]

Hi,

Just reminds you that holidays = your range that contain the date of holidays (for example C3:C30)

=WORKDAY.INTL(A2,B2,"1111111",holidays) >> Should return only the total days that = holidays
=WORKDAY.INTL(A2,B2,"0000000") >> Should return all days include weekend without holidays.

So if it not work as you expected
=WORKDAY.INTL(A2,B2,"0000000",holidays) >> Should return all days include weekend and include holidays .

Try to =WORKDAY.INTL(A2,B2,"0000000")-WORKDAY.INTL(A2,B2,"1111111",holidays)