Year formula
Try
=IF(DATEDIF(A1,TODAY(),"y")=60,"60 or above","")
OR year to year comparison
=IF(YEAR(TODAY())-YEAR(A1)=60,"60 or above","")
--
Jacob
"Robert" wrote:
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
|