NETWORKDAYS

[Connie Martin]

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

 

[Ron Rosenfeld]

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

 

[Connie Martin]

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]

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