Thread: How do I calculate exact difference between two dates in y,m,d.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Muhammad Javaid Hassan Muhammad Javaid Hassan is offline
external usenet poster
  
Posts: 10
Default How do I calculate exact difference between two dates in y,m,d.
I tried to callculate the difference between 14.02.1980 and 21.02.1985, but
excel does not give the exact difference in years, months and days.
I used the formula
=DATEDIF(A10,B10,"Y")&"Years, "&DATEDIF(A10,B10,"YM")&"Months,
"&DATEDIF(A10,B10,"MD")&"Days."
Reply With QuoteReply With Quote