I have a good formula in a cell, working just fine. It is:
=NETWORKDAYS(K29,N29,'C:\My Documents\Projects\Canadian
Non-Workdays.xls'!NonWorkDays2006)-1 which gives the number of days

In another cell I have this formula, which also works just fine:
=H29+7+7*(D29="TBG") which gives a date

In the second formula I would like to adapt this NETWORKDAYS to it. For
example, if the date falls on July 3, 2006, which is not a workday and which
is listed in the file referenced in the first formula, then it would give
July 4, 2006, which is the next workday. How do I make that second formula
to work like that? Hope I'm a little clearer than mud.

Connie