Year formula

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

I have a row of birth dates on a sheet, and need a formula to determine how
many are over 60 years old.

The cell format for the dates is 11/30/2009
 
Try
=IF(DATEDIF(A1,TODAY(),"y")>=60,"60 or above","")

OR year to year comparison
=IF(YEAR(TODAY())-YEAR(A1)>=60,"60 or above","")
 
Assume your dates are in the range A1:J1

Enter this formula in A2 and copy across to J2:

=DATEDIF(A1,NOW(),"y")

Then to count how many are greater than 60:

=COUNTIF(A2:J2,">60")
 
=if(datedif(D2,today(),"y")>=60,"60 or above","")

I tried the above formula and the cell states "60 or above" instead of
giving me a count of people over 60.

Thanks
 
To return the count of say row1 cell references A1:J1 try the below

=SUMPRODUCT((DATEDIF(A1:J1,TODAY(),"y")>=60)*(A1:J1>0))
 
Back
Top