Thread: Year formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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