+ Reply to Thread
Results 1 to 5 of 5

Getting a Yes/No response using network days

  1. #1
    Registered User
    Join Date
    04-24-2017
    Location
    Cincinnati, OH
    MS-Off Ver
    2010
    Posts
    6

    Getting a Yes/No response using network days

    I am trying to figure out a formula to get a "y" or a "n" response to whether two given dates are within 2 days of each other. I have used used the network days function to get the days apart, and now just need help figuring out the rest.

    =IF(COUNT(F1180,O1180)=2,NETWORKDAYS(O1180,F1180),"") ??????????

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Getting a Yes/No response using network days

    Something like this?

    Please Login or Register  to view this content.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    04-24-2017
    Location
    Cincinnati, OH
    MS-Off Ver
    2010
    Posts
    6

    Re: Getting a Yes/No response using network days

    Plugging that formula in is only giving me "Y" as an answer.

  4. #4
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Getting a Yes/No response using network days

    This formula assumes F1180 is the starting date. Is this a correct assumption?

  5. #5
    Registered User
    Join Date
    04-24-2017
    Location
    Cincinnati, OH
    MS-Off Ver
    2010
    Posts
    6

    Re: Getting a Yes/No response using network days

    Nope, I had to switch it, the O collum is my start date. But that helped me get this figured out. This is the formula that is working for me now.

    =IF(COUNT(F1,O1)=2,IF(NETWORKDAYS(O1,F1)<=3,"Y","N"),"")

    Because the data I am working with is not always complete I needed the count function to keep the data clean, which also necessitated the last quotation marks to give me a blank space instead of a False value. All this was due to the fact that I have another formula that then takes this data and figures the average of "Y" vs"N".

    This is all to keep me from having to do the math in my head when I am plugging all my data in, which is being used to figure out whether or not my employees are calling my customers in the given time range.

    Thanks!

+ 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. Network days error
    By AMacG in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-21-2015, 12:23 PM
  2. network days
    By fentiger79 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-28-2014, 04:54 PM
  3. Formula that will count response days with conditions
    By zince14 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2013, 12:13 AM
  4. [SOLVED] Subtracting Hold Days from Network Days Formula
    By david1987 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-17-2012, 08:30 AM
  5. Network days
    By fithawk in forum Excel General
    Replies: 13
    Last Post: 11-05-2011, 06:17 PM
  6. [SOLVED] Network Days
    By dinadvani via OfficeKB.com in forum Excel General
    Replies: 3
    Last Post: 07-21-2006, 06:10 AM
  7. [SOLVED] Excel Re-Calc causes network traffic and very slow response times.
    By toc1957 in forum Excel General
    Replies: 0
    Last Post: 06-07-2006, 01:50 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