View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karthik
 
Posts: n/a
Default challenging formula(for me), counting days between dates for multiple years

Sorry i am not clear of your query but this formula will give you the
duration between 2 dates

in A1 enter the first date, B1 enter the second date and in C1
=datedif(A1,B1,"d")
d represents days
m represents months
y represents years

Hope this is on similar lines