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
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
Last edited by dcoates; 08-22-2011 at 12:02 PM.
Try this formula
=COUNTIF(B5:B100,"<"&DATE(YEAR(B2)-3,MONTH(B2),DAY(B2)))
Audere est facere
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?
Both suggestions worked. Thank you daddylonglegs and Ron for your quick response. That helped tremendously.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks