+ Reply to Thread
Results 1 to 4 of 4

Count number of times a date is over 3 years in a column

  1. #1
    Registered User
    Join Date
    11-06-2003
    MS-Off Ver
    2013
    Posts
    75

    Count number of times a date is over 3 years in a column

    I need a formula to count the number of times a date in a column is over 3 years from the current date.

    Example is attached. I am using Excel 2003, Thanks so much. dcoates
    Attached Files Attached Files
    Last edited by dcoates; 08-22-2011 at 12:02 PM.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Count number of times a date is over 3 years in a column

    Try this formula

    =COUNTIF(B5:B100,"<"&DATE(YEAR(B2)-3,MONTH(B2),DAY(B2)))
    Audere est facere

  3. #3
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Count number of times a date is over 3 years in a column

    Using your posted workbook, this regular formula returns the count
    of instances where the "Date Training" is more than 3 years ago:
    =COUNTIF(B5:B18,"<"&EDATE(TODAY(),-36))

    In your example, the formula returns: 1 (2008-08-20 is more than 3 years prior to today)

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  4. #4
    Registered User
    Join Date
    11-06-2003
    MS-Off Ver
    2013
    Posts
    75

    Re: Count number of times a date is over 3 years in a column

    Both suggestions worked. Thank you daddylonglegs and Ron for your quick response. That helped tremendously.

+ 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