+ Reply to Thread
Results 1 to 13 of 13

WORKDAY.INTL Formula not excluding Sundays!

Hybrid View

  1. #1
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: WORKDAY.INTL Formula not excluding Sundays!

    For an estimated end time taking into account NO production on Sunday and the lengths of breaks, try this formula:
    Formula: copy to clipboard
    =LET(nd,H4/J4/24/(1-SUM(O3:Q3)+SUM(O2:Q2)),t,WORKDAY.INTL(C4,nd,11)+MOD(nd,1)+MOD(C4,1),t+(WEEKDAY(t)=1))
    Disclaimer: This formula does take into account the length of the daily breaks, but does not take into account when those breaks are exactly. However, the formula takes into account exactly when it is Sunday.
    Attached Files Attached Files

+ 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. [SOLVED] No of days in a Month excluding Sundays
    By grcshekar in forum Excel General
    Replies: 10
    Last Post: 04-13-2020, 12:43 PM
  2. =TODAY()-1 Excluding Sundays
    By Dan27 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-10-2016, 08:53 AM
  3. Replies: 2
    Last Post: 09-18-2015, 10:41 AM
  4. Replies: 10
    Last Post: 04-27-2015, 06:33 PM
  5. excluding holidays and sundays
    By balundl in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-25-2013, 12:38 PM
  6. Replies: 5
    Last Post: 12-11-2012, 01:20 AM
  7. Dates Excluding Sundays
    By gailb14 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 12-07-2007, 12:16 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