+ Reply to Thread
Results 1 to 3 of 3

If Statements and Difference between Dates

  1. #1
    Registered User
    Join Date
    Salt Lake, UT
    MS-Off Ver
    Excel 2010

    If Statements and Difference between Dates


    I am building a spreadsheet to track different dates along our sales process. Unfortunately I am stumped on a formula so any help would be great!
    The problem I am having is the "Value if True" statement, everything is below-

    =IF(G2>BB1, =G2-BB1, "Past Due")

    Logical Test
    G2 > BB1 (Greater)
    G2-Date of item within contract
    BB1-This is "=Today()" so it resets to today's date

    Value if True
    I would like to have the difference of days between "Todays Date" and the Date from the contract
    Example: if it is May 17 today, and my item is due May 18, it would display 1 day

    Value if False
    If G2 is greater than Todays Date, I would like it to read "Past Due"

    Any thoughts on this?

  2. #2
    Forum Contributor
    Join Date
    United States
    MS-Off Ver

    Re: If Statements and Difference between Dates

    You need to take the equals sign out of the Value if True area. It should be

    Please Login or Register  to view this content.
    That will do the math I believe you are after.

    Hope this helps.
    Mark threads as Solved
    Star those that help

  3. #3
    Forum Expert
    Join Date
    MS-Off Ver
    Excel 2010

    Re: If Statements and Difference between Dates

    let A1 contain =today()

    let the due date be in column G

    so for row 2 it would be

    =if(g2>=$a$1,g2-$a$1,"Past Due by "&$a$1-g2&" days")

+ 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] Difference between two dates
    By ckk403 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-24-2013, 06:02 PM
  2. difference between two dates
    By allems in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2011, 06:09 AM
  3. Difference between Dates
    By venu_creative in forum Excel General
    Replies: 8
    Last Post: 03-02-2010, 09:00 AM
  4. Difference between dates
    By rvlira in forum Excel General
    Replies: 4
    Last Post: 03-12-2009, 03:22 PM
  5. [SOLVED] difference between dates
    By RGB in forum Excel General
    Replies: 2
    Last Post: 07-21-2006, 07:45 AM

Tags for this Thread


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