+ Reply to Thread
Results 1 to 3 of 3

Calculate work days when off days are not normally Sat & Sun?

  1. #1
    Registered User
    Join Date
    03-28-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    13

    Calculate work days when off days are not normally Sat & Sun?

    I was wondering how would one calculate
    the total number of working days for the mo
    when the normal days off do not fall on the
    traditional Sat & Sun.

    My off days are normally Thurs & Sun.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Calculate work days when off days are not normally Sat & Sun?

    A1: first of month date....01-Aug-2013

    This regular formula returns the number of workdays in that month, where days off are Thursdays and Sundays:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Note: if there will be holidays, enter them in a range of cells and reference that range.
    Example:
    with holiday dates in F1:F10
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    03-28-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Calculate work days when off days are not normally Sat & Sun?

    Quote Originally Posted by Ron Coderre View Post
    A1: first of month date....01-Aug-2013

    This regular formula returns the number of workdays in that month, where days off are Thursdays and Sundays:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Note: if there will be holidays, enter them in a range of cells and reference that range.
    Example:
    with holiday dates in F1:F10
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Is that something you can work with?
    This definitely will work Ron! I did read through the
    office tutorial regarding networkdays.intl but when
    I input the 0001001 into the function it didn't work.
    What i was missing was the quotation marks.

    Thank you for your help and quick reply!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1