+ Reply to Thread
Results 1 to 5 of 5

How do I count Weekdays only in a range of dates? Exclude Holidays, weekends.

  1. #1
    Registered User
    Join Date
    03-08-2012
    Location
    Philadelphia
    MS-Off Ver
    Excel 2010
    Posts
    3

    How do I count Weekdays only in a range of dates? Exclude Holidays, weekends.

    Hello, I need to make an excel sheet that counts business days only. Not Holidays or weekends.

    My excel sheet is attached:

    Column D tells me the number of days between Column B and C.
    Column F tells me the number of days between Column C and E.
    Column H tells me the number of days between Column E and G.
    Column J tells me the number of days between Column G and I.
    Column L tells me the number of days between Column I and K.
    Column N tells me the number of days between Column K and M.
    Column P tells me the number of days between Column M and O.
    Column Q tells me the total number of days between Column B and O.

    But this is counting the weekends and holidays. I do not want it to count those.

    Column S and T has the Holidays that we have off at my company-I do not want them counted. I just want to count the business days.
    Column V and W has the dates and days(Monday, tuesday, etc) in case it is needed for the formula.

    So what formula do I need to put in Columns D, F, H, J, L, N, P to get the number of business days? Any help is greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: How do I count Weekdays only in a range of dates? Exclude Holidays, weekends.

    http://www.mrexcel.com/forum/showthread.php?t=388315
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    03-08-2012
    Location
    Philadelphia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: How do I count Weekdays only in a range of dates? Exclude Holidays, weekends.

    Alright, I updated my file. Now I put the formula =NETWORKDAYS() so that it only counts weekdays.

    But I still don't understand how to exclude holidays.???

  4. #4
    Registered User
    Join Date
    03-08-2012
    Location
    Philadelphia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: How do I count Weekdays only in a range of dates? Exclude Holidays, weekends.

    =NETWORKDAYS.INTL(Start_Date, End_Date, [Weekend], [Holidays])

    This is one of the formulas. I know what to put for start and end date. But what do I put in the other spaces so that it excludes holidays?

    I tried these, but it gives me an error:

    =NETWORKDAYS.INTL(B2, C2, [1], [T2:T14])
    =NETWORKDAYS.INTL(B2, C2, [1], [T])

    1 in [Weekend] signifies Saturday and Sunday according to Excel.

  5. #5
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2010 plus
    Posts
    730

    Re: How do I count Weekdays only in a range of dates? Exclude Holidays, weekends.

    Hi
    Networkdays () has a third argument to exclude the holidays as

    Networkdays(start_date,end_date, holidays)

    In holidays give the range where you have typed the dates for holiday other than weekend.

    Regards
    Mark the thread as solved if you are satisfied with the answer.


    In your first post under the thread tools.

    Mahju

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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