Convert Date to Age

[Enrique]

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

 

[Bearacade]

=INT((TODAY()-A1)/365.25)

Assuming that A1 is where your invoice date is

HTH

 

[Enrique]

Wow,

Thanks for the quick response. That's exactly what I needed.

Enrique

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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