Convert Date to Age
 

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

Convert Date to Age
 

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

Assuming that A1 is where your invoice date is

HTH


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=554344

Convert Date to Age
 

Wow,

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

Enrique
"Bearacade" wrote
in message ...

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

Assuming that A1 is where your invoice date is

HTH


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile:
http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=554344

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