View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Convert Date to Age

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Enrique" wrote in message
...
I need to be able to take a purchase date from a cell and be able to put

the
age (in years) of that purchase in another cell. Is there a function that
can do that?

Thanks,
Enrique