+ Reply to Thread
Results 1 to 3 of 3

Workday.INTL or Workday function issue

  1. #1
    Forum Contributor
    Join Date
    03-07-2006
    Location
    India
    MS-Off Ver
    MSOffice 2016 Professional 64 bit
    Posts
    108

    Workday.INTL or Workday function issue

    Hi,

    I am using Workday.INTL function to determine a list of working days (excluding Saturdays & Sundays) for all 12 months listed in a particular column B, starting from a particular day say, Today() in Cell A1. I have a list of holidays in a column E. Workday.INTL function uses the holiday list to determine each working day starting from the day in cell A1.

    The problem arises when the starting date in Cell A1 is a Holiday that is entered in the Holiday list. Workday still recognizes this date as a working day and displays it in the Column B date list.

    I have attached a sample book illustrating my problem. Can someone advise on why this is happening & an alternative way to overcome this problem?

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-17-2012
    Location
    Ulsan, South Korea
    MS-Off Ver
    Excel 2013
    Posts
    215

    Re: Workday.INTL or Workday function issue

    workday.intl.xlsx

    Hi junoon,

    Please see attached for one possible solution. I wrote the formula in such a way that if the date in A1 appears in the holidy list, it would increment the date by one day. I've highlight it in red on the attachment, all you need to do is replace it with a value/date that you would rather have instead.

    Hope this helps.

  3. #3
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Workday.INTL or Workday function issue

    You can fix the problem by making a small change to your original formula, instead of subtracting 1 from ROWS subtract it from the date like this:

    =WORKDAY($A$1-1,ROWS($A$3:$A3),holiday_list)
    Audere est facere

+ 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