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

On Thu, 27 Jul 2006 11:25:02 -0700, Connie Martin
wrote:

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


=WORKDAY(H29+6+7*(D29="TBG"),1,'C:\My Documents\Projects\Canadian
Non-Workdays.xls'!NonWorkDays2006)


--ron

Thank you so much, Ron. That works beautifully! I've had an awful time
trying to get back into this newsgroup and get to my post to see if anyone
answered. Kept getting "Sorry, this page isn't available" message.
Grrrr-rrr! Anyway, finally, I succeeded. Thanks so much! Connie

"Ron Rosenfeld" wrote:

On Thu, 27 Jul 2006 11:25:02 -0700, Connie Martin
wrote:

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


=WORKDAY(H29+6+7*(D29="TBG"),1,'C:\My Documents\Projects\Canadian
Non-Workdays.xls'!NonWorkDays2006)


--ron

On Fri, 28 Jul 2006 11:06:02 -0700, Connie Martin
wrote:

Thank you so much, Ron. That works beautifully! I've had an awful time
trying to get back into this newsgroup and get to my post to see if anyone
answered. Kept getting "Sorry, this page isn't available" message.
Grrrr-rrr! Anyway, finally, I succeeded. Thanks so much! Connie

Glad to help. Thanks for the feedback.
--ron