Year formula

[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

 

[Jacob Skaria]

Try
=IF(DATEDIF(A1,TODAY(),"y")>=60,"60 or above","")

OR year to year comparison
=IF(YEAR(TODAY())-YEAR(A1)>=60,"60 or above","")

 

[T. Valko]

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")

 

[Robert]

=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

 

[Jacob Skaria]

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

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