NUMBER OF YEARS BETWEEN TWO DATES - HOW TO GET
 

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

NUMBER OF YEARS BETWEEN TWO DATES - HOW TO GET
 

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

NUMBER OF YEARS BETWEEN TWO DATES - HOW TO GET
 

=DATEDIF(A1,B1,"y")

HTH
--
AP

"AJAY KUMAR DIXIT" <AJAY KUMAR a écrit dans
le message de news: ...
How can I calculate or know the exact age(Number of years) between two
dates