+ Reply to Thread
Results 1 to 5 of 5

Formula to check if date is greater than or equal to current date

  1. #1
    Forum Contributor
    Join Date
    04-05-2007
    Location
    Arlington, TX
    MS-Off Ver
    Office 2010
    Posts
    164

    Formula to check if date is greater than or equal to current date

    I'm doing a conditional format for some of my cells. The issue I'm running into is I can't seem to create a formula excel can use to format dates greater than the current date >TODAY() is not working for me. The whole formula needs to see if both I3=0 and >TODAY() then format the entire row. Kinda struggling with this one. Any help is greatly appreciated.
    Office 2010

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Formula to check if date is greater than or equal to current date

    How about:

    Please Login or Register  to view this content.
    Where [your cell] is the cell you want the formatting applied to.

    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Valued Forum Contributor scottylad2's Avatar
    Join Date
    09-03-2010
    Location
    edinburgh
    MS-Off Ver
    Office 2007 Prof & Office 2010 Student Edition
    Posts
    629

    Re: Formula to check if date is greater than or equal to current date

    Quote Originally Posted by Pyrex238 View Post
    I'm doing a conditional format for some of my cells. The issue I'm running into is I can't seem to create a formula excel can use to format dates greater than the current date >TODAY() is not working for me. The whole formula needs to see if both I3=0 and >TODAY() then format the entire row. Kinda struggling with this one. Any help is greatly appreciated.
    can I3 be a date and a0? don't think so, where will the zero be and will I3 be a date?
    Windows 7 using Office 2007 & 2010

    Remember your [ code ] [ /code ] tags, makes reading soooo much easier

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Formula to check if date is greater than or equal to current date

    You don't say where the date is that you are comparing to today. Let's assume in column A. Okay, assuming your data range is A3:J500, select your range, then go to conditional formatting > new rule > use formula

    =AND($I3=0, $A3>TODAY()) and format appropriately.
    Just to be clear, if the value in column A is greater than todays date and I = 0, then the cell will change formatting.
    Does that work for you?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  5. #5
    Valued Forum Contributor scottylad2's Avatar
    Join Date
    09-03-2010
    Location
    edinburgh
    MS-Off Ver
    Office 2007 Prof & Office 2010 Student Edition
    Posts
    629

    Re: Formula to check if date is greater than or equal to current date

    As ConneXionLost said, highlight the row then go into C/F, new rule and
    apply this formula. I've put your ref to 0 im H3 =AND($I3>TODAY(),$H3=0) only thing wrong with this is CF will see an empty cell as being the same as 0. If there's a formula in there that equates to a 0 or "" though thats handled differently

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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