Dates count to be done which are 65 yrs older than refence cell

[Ram Mher]

Actually i want to count that how many dates are available in the data which are 65 years older than the date which are provided as “Effective Date” .

please help me anyone.

 

[AlanSidman]

In F5 =COUNTIF($B$5:$B$17,">"&DATE(1955,3,28))

 

[Ram Mher]

Thanks a lot for the nice support.