NUMBER OF YEARS BETWEEN TWO DATES

NUMBER OF YEARS BETWEEN TWO DATES - HOW TO GET

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AJAY KUMAR DIXIT - 16 May 2006 10:09 GMT

How can I calculate or know the exact age(Number of years) between two dates

Reply to this Message

Gary''s Student - 16 May 2006 10:14 GMT

Use DATEDIF():

if A1 and A2 contain:
1/15/1985
12/31/2005

then:
=DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " &
DATEDIF(A1,A2,"md") & " days"

will display:
20 years, 11 months, 16 days

Signature

Gary's Student

> How can I calculate or know the exact age(Number of years) between two dates

Reply to this Message

Ardus Petus - 16 May 2006 10:17 GMT

=DATEDIF(A1,B1,"y")

HTH
--
AP

> How can I calculate or know the exact age(Number of years) between two
> dates

Reply to this Message