one way:
=SUMPRODUCT(--(DATEDIF(A1:A3,TODAY(),"y")<=60))
for the usage of -- in SUMPRODUCT formulae, see
http://www.mcgimpsey.com/excel/doubleneg.html
In article ,
"crander8" wrote:
I am trying to calculate the % of people under a certain age. In the
COUNTIF() funtion, how do I calculate the age and then compare it to the
chosen value?
e.x. =COUNTIF(A1:A3,(calculate age) <=60)
7/14/1932
4/28/1951
11/11/1939