Results 1 to 4 of 4

Employee End Date with WORKDAY.INTL() function using Hire Date

Threaded View

  1. #1
    Registered User
    Join Date
    03-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    33

    Question Employee End Date with WORKDAY.INTL() function using Hire Date

    How can I adjust/manipulate the WORKDAY. INTL() function so that it accepts the HIRE DATE instead of the first WORK DATE and still return the correct end date?

    For example -

    Employee is working a Saturday/Sunday ONLY schedule with no holidays. Start day is 4/14/18 (Saturday) and they are scheduled to work for 5 full work days.

    In this case,

    A1 = 4/14/18
    A2 = 5
    A3 = =WORKDAY.INTL(A1,A2-1,"1111100")

    That will correctly return 4/28/18 as the last day the employee will be working.

    However, if I put A1 as a day that does not fall on a Sat/Sun, e.g. A1 = 4/13/18 (Friday), A3 will spit out 4/22/18 which is incorrect. Putting in 4/9 to 4/12 (Monday to Thursday) all returns the same result.

    How can I have WORKDAY.INTL ignore the days before the first actual workday?

    Thanks!
    Last edited by XLOOKUP; 08-23-2017 at 11:22 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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
  2. Start Date/End Date without Workday Function
    By RC88 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-01-2016, 12:07 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