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
"Bearacade" <[email protected]> wrote
in message news:[email protected]...
>
> =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
>

[Bob Phillips]

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

--
HTH

Bob Phillips

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

"Enrique" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>