Results 1 to 4 of 4

Date older than 3 years? (yes/no)

Threaded View

  1. #1
    Registered User
    Join Date
    04-10-2013
    Location
    DK
    MS-Off Ver
    Excel 2010
    Posts
    29

    Date older than 3 years? (yes/no)

    Dear Wizards

    I am in a need to verify many different dates related to three different items. I need to know whether the dates in column A reltad to a "type" in column B is older than 3 years (column C) and older than 4 years (column D). Sure it is a simple task, I just cant get my head around it

    See attached example.

    Thank you in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting. Anything 4.5 years old + older from todays date needs Highlight.
    By themanwithnoshoes in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-25-2012, 11:58 AM
  2. Delete lines with older date
    By VDREECK in forum Excel General
    Replies: 2
    Last Post: 01-14-2011, 03:51 AM
  3. Highlighting dates older than 4 years
    By james1234 in forum Excel General
    Replies: 2
    Last Post: 04-04-2010, 07:15 AM
  4. How to pull out an older date...
    By screenpath in forum Excel General
    Replies: 3
    Last Post: 11-14-2007, 07:37 AM
  5. [SOLVED] I want any date 90 days or older from current date change color
    By Big Abalone in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-23-2006, 12:10 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