add days using networkdays

Hi,
I could use networkdays function to generate the difference between two dates. But, how to add specific number of days to a date, calculating only working days ?
Eg: adding 5 days to nov 28 07 should give me a result of 5 dec, ignoring 1 and 2 of dec as these days are holidays. Please help !

I'm sure this could be done with a formula (or more efficiently in code), but here's a quick hack:

Please Login or Register  to view this content.

You can use WORKDAY function,

=WORKDAY(A1,5)

where A1 contains your date. WORKDAY also allows you to specify a range of holiday dates to be excluded.

Humbug ...