Share via

Networkdays.intl

Anonymous
2014-03-07T11:59:38+00:00

hi, i want to ask: i have an MS Excel 2007 and i have a problem with it, that is with NETWORKDAYS.INTL function i can't find it in my function list or formulas. how you can help me? thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2014-03-07T13:09:24+00:00

Hi,

So the only day for the weekend is Friday, the other 6 days are included. Try this where holidays is a named range that contains your holiday dates.

Start date in A2

End date in b2.

=SUMPRODUCT((WEEKDAY(ROW(INDIRECT(A2&":"&B2)))<>6)*ISNA(MATCH(ROW(INDIRECT(A2&":"&B2)),Holidays,0)))

Was this answer helpful?

0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-03-07T14:03:28+00:00

    thanks a lot i appreciate your help 

    You're welcome, you might now like to mark my response as answer.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-03-07T13:59:55+00:00

    thanks a lot i appreciate your help

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-03-07T12:41:03+00:00

    thanks Mike i am trying to calculate workdays between two dates and with holiday dates and Friday weekend

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-03-07T12:28:16+00:00

    Hi,

    That function was first introduced in Excel 2010 so you don't have it in Excel 2007. There are workarounds, please explain what you're trying to do and someone will help.

    Was this answer helpful?

    0 comments