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: 1
Default How do I calculate exact difference between two dates in y,m,d.
I want to calculate the difference between two dates exactly in years, months
and days. Say between the dates 14-02-1980 to 28-02-1985. The difference is 5
years, 0 months and 14 days including both the starting and ending dates. But
excel does not give the exact answer. Pl help me.
Reply With QuoteReply With Quote