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
|