NUMBER OF YEARS BETWEEN TWO DATES - HOW TO GET

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

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

--
Gary's Student


"AJAY KUMAR DIXIT" wrote:

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

=DATEDIF(A1,B1,"y")

HTH
--
AP

"AJAY KUMAR DIXIT" <AJAY KUMAR DIXIT@discussions.microsoft.com> a écrit dans
le message de news: 77320314-8FA3-46B7-A2E0-45F2117113E2@microsoft.com...
> How can I calculate or know the exact age(Number of years) between two
> dates