+ Reply to Thread
Results 1 to 3 of 3

Formula Counting Days Including weekends, excluding Holidays

  1. #1
    Registered User
    Join Date
    01-08-2019
    Location
    Antwerp Belgium
    MS-Off Ver
    2016
    Posts
    2

    Formula Counting Days Including weekends, excluding Holidays

    Hi everyone,

    I am searching for a formula to count days including weekends but excluding holidays (or certain days that I can choose by putting them in a list)
    When I get a document posted on a server, I need to count 30 days until I give an answer. (Lets call this the "response time") In those 30 days, weekends are included. So it's just the creation date of the document +30days. But with the christmass holidays nobody works so the end date (30days) needs to be extended . e.g. the last workday was 21/12/18 and the first workday of the new year was 07/01/19 so when a document comes in on 20/12/18 I count one day until 21/12 and I need to count 29 days after 07/01/19. And I need to put this in a formula.

    Online I only find formulas to exclude weekends and holidays, or only weekends, but I can't find a formula which only exclude holidays.

    Is there someone who can help me please?

    Many thanks!

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Formula Counting Days Including weekends, excluding Holidays

    =WORKDAY.INTL(A1,30,"0000000",$K$1:$K$20), in KK there are holidays

  3. #3
    Registered User
    Join Date
    01-08-2019
    Location
    Antwerp Belgium
    MS-Off Ver
    2016
    Posts
    2

    Re: Formula Counting Days Including weekends, excluding Holidays

    Thank you very much!
    You have made my day!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 10-31-2014, 10:32 AM
  2. Replies: 4
    Last Post: 05-19-2014, 04:28 PM
  3. Add X Days To Dates, Excluding Weekends and Holidays
    By sianjialin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2014, 11:46 PM
  4. Calculate number of days excluding holidays and weekends
    By david1987 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2012, 08:17 AM
  5. Calculate number of days, excluding weekends and holidays
    By cloyd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-26-2012, 04:37 PM
  6. List Dates Excluding Holidays but Including weekends
    By GuyHudson in forum Excel General
    Replies: 6
    Last Post: 09-22-2010, 05:58 AM
  7. [SOLVED] Formula for adding days to a date excluding weekends and holidays?
    By Jake via OfficeKB.com in forum Excel General
    Replies: 2
    Last Post: 01-25-2006, 04:03 PM

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