=CountIf(DataRangeB:B,"<=" & DATE(YEAR(TODAY())-3;MONTH(TODAY());DAY(TODAY())))
--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music
"Brent E" wrote:
Good day,
I have a series of data including a date col. What is the criteria statement
I should use in the CountIf formula to determine the no. of records where the
date is 3 years or more prior to the current date in cell B2?
Pseudo criteria something like:
CountIf(DataRangeB:B, <= B2 - 3 yrs)
Thanks in advance,