Results 1 to 30 of 30

Nested Function Issue

Threaded View

  1. #1
    Registered User
    Join Date
    10-22-2019
    Location
    South Carolina, USA
    MS-Off Ver
    365 | 2016
    Posts
    42

    Nested Function Issue

    I am trying to set up a formula that will calculate with Networkdays() the differences between two dates with times. I need the formula to first check if the end date is a weekend or holiday (OT) and if so, just subtract the date and time (H2-G2), but if the end date is not a weekend or holiday, apply the Networkdays formula. The attached example is the exact current formula I have, which should work, however, I noticed while watching the calculation steps under the "Evaluate Formula" tool that it does register a false for the dates, however, it ignores it. I am beginning to think this may be due to me using a named range for the formula, but I cannot be sure.

    Needs:
    Formula in attachment to check End date for weekend/holiday per the list included.
    If End date is Weekend/Holiday, subtract start date from end date and return total number of hours/minutes between the two.
    If Start Date is holiday and end date is weekend, subtract start date from end date and return total number of hours/minutes between the two (This applies to holidays that fall on a Friday as some people will work OT on the following Saturday to make up hours instead of using PTO.)
    If none of the above apply, apply Networkdays() formula as listed.


    This is being used to calculate the total processing time for emails being received and responded to.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Nested Loops Issue
    By pnbhatt1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2019, 04:55 PM
  2. Replies: 2
    Last Post: 01-05-2019, 03:33 AM
  3. [SOLVED] Nested if function issue
    By Vcare in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-25-2018, 05:53 AM
  4. [SOLVED] Nested vlookup or nested IFAND function?
    By jeptik in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-11-2017, 02:27 AM
  5. Nested if function issue
    By agdavis93 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-30-2016, 03:21 PM
  6. [SOLVED] Issue with nested IF function and structured references
    By jason1983 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-28-2015, 08:13 PM
  7. Issue with too many nested IF statements
    By sjak in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-05-2008, 03:13 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