+ Reply to Thread
Results 1 to 5 of 5

Formula to omit Specific dates

  1. #1
    Registered User
    Join Date
    10-23-2008
    Location
    florida
    Posts
    9

    Formula to omit Specific dates

    Hey all!!

    Can someone help me with a formula that will allow me to just display dates after 1/1/2005? The cells I want to omit look like the below:
    So I think it needs zsomething more than a > or < sign. I just need to display dates greater than 2005 in a column. Thank you guys again for everything!!

    1/0/1900 12:00:00 PM

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    If the only cells that you want to hide are that format, just go to Tools > Options, then on the View tab, uncheck Zero Values.

    HTH

    Jason

  3. #3
    Registered User
    Join Date
    10-23-2008
    Location
    florida
    Posts
    9

    Did not work Jaso

    I tried that and it didnt work. I attached the file I am trying to do this with. Can you help?? thank you again
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    07-09-2008
    Location
    Dallas
    MS-Off Ver
    2007
    Posts
    121
    Try this in cell C4 (and copied down column C as desired):

    =IF(YEAR(A4)>=2005,A4,"")

  5. #5
    Registered User
    Join Date
    10-23-2008
    Location
    florida
    Posts
    9
    that worked great!!! THANK YOU!!

+ 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