Adding days to a start date (including weekends & holidays); end date only on workday

What formula do I have to use in order to add a number of days to a date entered into a cell, however if the calculated date lands on a weekend or a holiday, then the date needs to go to the next business day. But for the calculation weekend and holiday days have to be counted, the end date just has to be on working day.

Any help would be appreciated.

Try WORKDAY function

ili napiši primjer pa da znamo konkretnije o čemu se radi. Na engl normalno

Thanks for the reply, but WORKDAY function is not an option, since weekends and holidays need to be included in the calculation as well.

Example:

Start date (January 1 2009) + 9 days (all days, not just business day) = January 10 2009, (but that is Saturday, so the calculation gives the first business day after it), therefore the correct date would be = January 12 2009.

I hope this formula can be done, because it would save me many days of work.

You can use IF solution:

=IF(WEEKDAY(B3+$C$1;2)=7;B3+$C$1+1;IF(WEEKDAY(B3+$C$1;2)=6;B3+$C$1+2;B3+$C$1))

Where B3 is current date and C1 is number of days you adding. If you have different days to add for each day instead of $C$1 write C3 and use formula same way

Another apporach by lookup function:

=B3+$C$1+LOOKUP(WEEKDAY(B3+$C$1;2);{1;6;7};{0;2;1})

Or this:

=B3+$C$1-MIN(0;6-WEEKDAY(B3+$C$1;2))

Hello there, =WORKDAY(B3+(C1-1),1,holidays) is a real diamond in a sense that it's elegant and sort.
If you want to add dates to a date and include both weekends and holidays in the calculation but then if the resulting date is either a weekend or a holiday, go to the next working day this is it.
It's a way to negate the obsessive compulsion of "workday" to not include weekends when counting (I suppose there could be cases when this would be useful too).
Would you be so kind as to offer your invaluable knowledge please?
I need =WORKDAY(B3+(C1-1),1,holidays) keep doing what it does as described above, but I also need it to be able to completely ignore a month or predefined ranges of dates.
When I say ignore I mean that the formula should act as if a range (August for example or some consecutive dates in A2:A5 & B2:B5) don't exist at all.
That is to say the formula should not include those dates when counting (pause counting and resume counting just after ie August or that predefined range of consecutive dates in A2:A5 & B2:B5).
What is more the resulting date cannot be (ie August or one of those predefined consecutive dates in ranges A2:A5 & B2:B5).
In sort I would like to include weekends and holidays in my calculation (ie count them but go to next working day if my calculation ends on them) and at the same time define some predefined ranges
which should be ignored/skipped completely when counting as if they didn't exist at all (basecally stop counting at the beginning of a range of dates and resume counting just after the last date in that ragne).
I've included a book so that you could maybe have a look and see if this is something you would care to spend some time.
I would like to thank you for any ideas you may come up with.
Sincerely,
Panos