Thread: CALCULATE THE ACTUAL AGE IN TERMS OF YEARS, MONTHS AND DAYS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
  
Posts: 2,480
Default CALCULATE THE ACTUAL AGE IN TERMS OF YEARS, MONTHS AND DAYS
Hi

With earliest date in A1 and latest date in A2
=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months
"&DATEDIF(A1,B1,"md")&" days"

--

Regards
Roger Govier

"jr" wrote in message
...
so it shows a result of "15 years 4 months and 6 days" for example.

Reply With QuoteReply With Quote