Results 1 to 5 of 5

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

Threaded View

  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

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