+ Reply to Thread
Results 1 to 4 of 4

Excel Date/Tolerance formula

  1. #1
    Registered User
    Join Date
    03-21-2012
    Location
    Michigan, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Excel Date/Tolerance formula

    I have a workbook I'm creating and want to pull data from one worksheet (raw data) into another (summary). I want my summary worksheet to display a "YES" or "NO" answer depending on whether my ending dates fall within a 14 day tolerance, either 14 days before or after the scheduled date. For instance, if my project was scheduled to finish on June 1 but actually finished June 14, then it is with the 14 day tolerance before or after and I want the cell to display "YES" If outside that window, then the cell should display "NO". Help please.

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,866

    Re: Excel Date/Tolerance formula

    =if(abs(A1 -B1)<=14; "yes","no")
    a1=june 1
    b1=june 14

    Is this what you want?
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    03-21-2012
    Location
    Michigan, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Excel Date/Tolerance formula

    It appears that Excel doesn't like '14'. When I put in this formula, I get an error msg and then 14 is highlighted. Any thoughts? Thank you.

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,866

    Re: Excel Date/Tolerance formula

    =if(abs(A1 -B1)<=14; "yes","no")
    It is not 14 but de semicolon that excel doesn't like:

    =if(abs(A1 -B1)<=14, "yes","no")

+ 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. Tolerance Formula based on Different Levels - Nested If?
    By dminar11 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-18-2013, 01:38 PM
  2. Formula to calculate tolerance negative & postive
    By nd4spd in forum Excel General
    Replies: 3
    Last Post: 08-04-2011, 04:20 AM
  3. formula for true/false tolerance percent
    By geeve420 in forum Excel General
    Replies: 4
    Last Post: 08-07-2009, 01:59 PM
  4. Replies: 1
    Last Post: 05-10-2006, 11:00 PM
  5. [SOLVED] Tolerance Stack Excel Worksheet
    By MTUSNOW in forum Excel General
    Replies: 0
    Last Post: 09-07-2005, 07:05 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