Thread: NUMBER OF YEARS BETWEEN TWO DATES - HOW TO GET
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default 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


Reply With QuoteReply With Quote