+ Reply to Thread
Results 1 to 5 of 5

IF WORKDAY Formula - where to add WORKDAY?

  1. #1
    Registered User
    Join Date
    02-29-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2016
    Posts
    64

    IF WORKDAY Formula - where to add WORKDAY?

    Hi All

    I have written the formula below to calculate the difference between 2 dates in G12 and H12. It also calculates the difference between dates in S1 and G12 if H12 is empty.

    I only want to count WORKDAYs but I am unable how to structure the formula. Have tried a few things but can't get it.

    =IF(G12="","",IF(H12="",$S$1-G12,H12-G12))

    Any help greatly appreciated.

    Thanks
    Greg

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,040

    Re: IF WORKDAY Formula - where to add WORKDAY?

    Try this: =IF(G12="","",IF(H12="",NETWORKDAYS(G12,$S$1),NETWORKDAYS(G12,H12)))
    Click the * to say thanks.

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    7,007

    Re: IF WORKDAY Formula - where to add WORKDAY?

    Ignore my solution which I've now deleted from embarrassment :o(
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,794

    Re: IF WORKDAY Formula - where to add WORKDAY?

    You need to use the NETWORKDAYS function, so try this:

    =IF(G12="","",IF(H12="",NETWORKDAYS(G12,$S$1),NETWORKDAYS(G12,H12)))

    Note that the start date comes before the end date in the parameter list. You can also take account of any holidays that are scheduled.

    Hope this helps.

    Pete

  5. #5
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    422

    Re: IF WORKDAY Formula - where to add WORKDAY?

    Here is a more compact version:

    =IF(G12="","",NETWORKDAYS(G12,IF(H12="",$S$1,H12)))

+ 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 & IF Formula Mod
    By DBExcelDB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-27-2018, 03:31 PM
  2. Help with WORKDAY formula
    By Melbourne93 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-13-2015, 04:03 AM
  3. WORKDAY Formula
    By Simoin in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-05-2014, 08:32 AM
  4. Workday in formula
    By WiserGuy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2014, 11:30 AM
  5. Workday.INTL or Workday function issue
    By junoon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2013, 03:14 PM
  6. Workday Formula
    By Blake 7 in forum Excel General
    Replies: 2
    Last Post: 02-14-2012, 05:19 AM
  7. Workday Formula
    By Gos-C in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2005, 03:47 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