NETWORKDAYS

C

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
 
R

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
Click to expand...

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


--ron
 
C

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
 
R

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
Click to expand...

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