+ Reply to Thread
Results 1 to 2 of 2

Subtracting Hold Days from Network Days Formula

  1. #1
    Registered User
    Join Date
    08-20-2012
    Location
    Glasgow
    MS-Off Ver
    Excel 2007
    Posts
    77

    Subtracting Hold Days from Network Days Formula

    Hi,

    The formula below works out product ontime delivery by calculating the difference between two stored dates (start date) Q and (shipment date) R, this formula excludes weekends and public holidays. it then returns a 1 or 0 value depending on whether it is within a 4 day on time delivery range.

    However, i now have a new field which is 'time on hold'. I want to subtract the 'time on hold', which is recorded in number of days, from the shipment date. however, i want the days it takes off the shipment date not to include weekends and holidays.

    =IF(NETWORKDAYS(Q14302,R14302,HolidayRange)-1<=4,1,0)


    Thanks in advance,

    David

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,702

    Re: Subtracting Hold Days from Network Days Formula

    Try using WORKDAY function, e.g. if days on hold is in column S try this formula

    =IF(NETWORKDAYS(Q14302,WORKDAY(R14302,S14302*-1,HolidayRange),HolidayRange)-1<=4,1,0)
    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)

Tags for this Thread

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