Add fixed number of days, including weekends, but excluding a range of dates

Hi there,

I am trying to come up with a formula which will give me a date 7 days (including weekends, but excluding a range of dates in a table i.e. bank holidays etc.) after a date.

I am able to do this with a WORKDAY.INTL formula, however, i need to include weekends within the 7 days, is there an easy workaround i am missing?

Many thanks in advance for any help!

Hi & welcome to the board.
You could subtract 2 from the number of days, or subtract 1 & set the weekend argument to 11

That would indeed work! Thanks for the suggestion!

You're welcome & thanks for the feedback

Hi, please can you provide the formula that you used, I have been trying to do this for a while and am struggling

Hi Cathy,

The formula I used is

=WORKDAY.INTL(B7,F7,"0000000",$L$16:$M$23)

Where B7 is the date from which i need to count from, F17 is the number of days and $L$16:$M$23 is a selection of dates to 'exclude'.

This counts all days except those in the exclude table.

Hope that helps!

Hi,
Thank you, this does make sense, but I think I need it do something different. I need it to return the next day (including weekend but excluding hols). I should post a new question and not try to get the answer on the back of this post

The formula should work, just put '1' in the number of days from the last date.

ahhh thanks so would your formula be
=WORKDAY.INTL(B7,1,"0000000",$L$16:$M$23)

My formula is
=workday.int(G4,????,"0000000",PublicHols)
where
G4 is the start date
??? i dont know what to put here
"0000000" includes all days
PublicHols is a named range for all public holidays

Sorry for hi-jacking the thread. I have raised a new one. Thank you clownfishcoxy for helping