You'd have to make a list of holiday dates, assume these are in C1:C10 and
you want to add a number of days contained in B1 to a date in A1 you could
use this formula

=MIN(IF(ISNA(MATCH(A1+B1+{0,1,2,3,4,5},C1:C10,0)), A1+B1+{0,1,2,3,4,5}))

This assumes you never have more than 5 bank holidays on consecutive days

"TheRook" wrote:

Thanks for that, the only problem is that it seems to be assuming that we do
not work weekends but that is not the case.

Is it possible for it to assume everyday is a working day bar the ones
stated as holidays?

Regards

"Niek Otten" wrote:

From the same family as NETWORKDAYS():
WORKDAY()
You may have to format the result as Date

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"TheRook" wrote in message ...
|I am wanting to calculate an end date from a start date say 1/12 + 7 days =
| 8/12 but if 2/12 was classed as an holiday the the end date would be 9/12
|
| A have previously used networkdays using holidays as non working days but
| obviously this is to calculate from a start date to an end date, and not to
| prodicte an end date.
|
| anyone any ideas?