+ Reply to Thread
Results 1 to 3 of 3

WORKDAY.INTL help

  1. #1
    Registered User
    Join Date
    01-25-2021
    Location
    Maryland
    MS-Off Ver
    2016
    Posts
    2

    WORKDAY.INTL help

    I’m trying to use the workday.intl function to exclude Sundays and holidays and INCLUDE Saturdays in the argument but return ONLY workdays, no Saturdays, sundays, or holidays. The formula I have now is simple enough but since I include Saturdays in the argument, it is also returning Saturdays in the due date. I need to tell the formula to skip To the next working day when returning the date. So from the start date, I need to count 4 days, including Saturday in the count, and return the next business day, NOT including Saturdays (or sundays or holidays). COL A is the start date and COL B is the due date, and H2:H12 are holidays. So for example I have:

    =WORKDAY.INTL(A24,4,11,$H$2:H$11)

    Where A24=1/26. So B24 is returning 1/30 but since 1/30 is a Saturday I need it to return 2/1 which is the following Monday. Any help is appreciated!!

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,706

    Re: WORKDAY.INTL help

    you could, perhaps, wrap an outer WORKDAY using same holiday range

    =WORKDAY(WORKDAY.INTL(...)-1,1,$H$2:$H$11)

    the above takes result of the INTL calc, subtracts one day and then moves to next working day on Mon-Fri basis, excl. Public Holidays.

  3. #3
    Registered User
    Join Date
    01-25-2021
    Location
    Maryland
    MS-Off Ver
    2016
    Posts
    2
    It worked beautifully!! Thank you so much!

+ 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. =WORKDAY.INTL need help with weekend
    By eli-vergara in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2020, 04:40 PM
  2. WORKDAY.INTL in Excel 2007 to exclude Fri/Sat
    By Samanar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-02-2017, 06:05 PM
  3. [SOLVED] Help with Workday.intl
    By NeedForExcel in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-30-2015, 07:01 AM
  4. [SOLVED] WORKDAY.INTL function for excel 2007
    By turist in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2013, 02:20 AM
  5. Workday.intl problems
    By JacoKanban in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-06-2013, 06:40 PM
  6. Workday.intl function--Holidays help
    By bluskye425 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2013, 02:28 PM
  7. Workday.INTL or Workday function issue
    By junoon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2013, 03:14 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