CountIf to determine Date - 3 yrs
Hi Brent
=COUNTIF(DataRangeB:B,"<="&TODAY()-1095)
or
=COUNTIF(DataRangeB:B,"<="&B2-1095)
Best rgds
Chris Lav
"Brent E" wrote in message
...
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,
|