NETWORKDAYS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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
 
Back
Top