+ Reply to Thread
Results 1 to 5 of 5

IF formula using dates not producing correct result

  1. #1
    Registered User
    Join Date
    10-14-2014
    Location
    Memphis, TN
    MS-Off Ver
    10
    Posts
    3

    IF formula using dates not producing correct result

    Please see the attachment.The formula I'm using is in the formula bar in the screenshot. The circled row shows the error. Why is the IF formula not working properly when comparing these two dates?
    Attached Images Attached Images
    Last edited by Snelms; 10-14-2014 at 03:49 PM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,648

    Re: IF formula using dates not producing correct result

    Hi,

    You didn't upload the workbook as an attachment. We prefer them to mere pictures.

    Do both G& & K7 contain date numbers?
    Test with =ISNUMBER(G7) & ISNUMBER(K7)

    What results do you get?
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: IF formula using dates not producing correct result

    I just tried the EXACT formula on a sample sat of data I created and it worked correctly.

    Can you post your data so we can take a look?

    Also, try:

    Please Login or Register  to view this content.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  4. #4
    Registered User
    Join Date
    10-14-2014
    Location
    Memphis, TN
    MS-Off Ver
    10
    Posts
    3

    Re: IF formula using dates not producing correct result

    I figured it out. The highlighted Column is a complicated formula with lots of nested IFs. When I hard coded that column the formula works correctly.

    Thanks all!

  5. #5
    Registered User
    Join Date
    10-14-2014
    Location
    Memphis, TN
    MS-Off Ver
    10
    Posts
    3

    Re: IF formula using dates not producing correct result

    I can't post the spreadsheet as it is sensitive data. I will also try to use the Value function mikeTRON so as to not create a duplicate hard coded cell.

+ 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] Code result wrong but formula correct result
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-11-2014, 12:26 PM
  2. [SOLVED]Formula producing wrong result
    By tobu56 in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 10-26-2013, 08:59 PM
  3. Replies: 3
    Last Post: 11-24-2011, 06:18 AM
  4. SUM function not producing correct result
    By angiebro in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-28-2010, 06:10 PM
  5. IF formula with correct formatting in result
    By tmp4 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2006, 12:15 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