+ Reply to Thread
Results 1 to 4 of 4

Combining an IF function and WORKDAY function

  1. #1
    Registered User
    Join Date
    11-14-2017
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    6

    Combining an IF function and WORKDAY function

    I'm trying to set up a field using the following formula =IF(V3="Yes","COMPLETE",IF(D3="","",IF(D3>1/1/17,=(WORKDAY (D3+10))). I can get it to work if I just use the DATE function and add 3 days, but I want it to return a workday date. CAn this be done? Thank you in advance.

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Combining an IF function and WORKDAY function

    First problem is this
    D3>1/1/17
    that is NOT saying Is D3 Greater than Jan 1st 2017.
    It's actually saying is D3 Greater than 1 divided by 1 divded by 17
    That should be written lik
    D3>"1/1/17"+0
    or
    D3>DATE(2017,1,1)

    Then the syntax for Worday would be WORKDAY(D3,3)

    Try
    =IF(V3="Yes","COMPLETE",IF(D3="","",IF(D3>DATE(2017,1,1),WORKDAY(D3,3))))

  3. #3
    Registered User
    Join Date
    11-14-2017
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    6

    Re: Combining an IF function and WORKDAY function

    This fixed it. Thank you so much for your help and the quick response!!!

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Combining an IF function and WORKDAY function

    You’re welcome

+ 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. Nested IF Function with WORKDAY function
    By marielouise1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2014, 03:00 PM
  2. [SOLVED] Workday function help
    By emina002 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-10-2013, 08:47 AM
  3. Workday.INTL or Workday function issue
    By junoon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2013, 03:14 PM
  4. [SOLVED] workday function
    By shaknark in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-02-2012, 11:41 PM
  5. Workday function
    By Saky in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-31-2011, 09:56 AM
  6. Using the Workday function
    By marty6 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2006, 10:23 PM
  7. Workday function
    By RUSH2CROCHET in forum Excel General
    Replies: 4
    Last Post: 05-17-2006, 02:40 PM
  8. [SOLVED] Excel Workday Function with another function
    By Monique in forum Excel General
    Replies: 2
    Last Post: 04-27-2006, 08:15 AM

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