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?