View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brent E Brent E is offline
external usenet poster
 
Posts: 74
Default CountIf to determine Date - 3 yrs

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,