View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Colin Hayes Colin Hayes is offline
external usenet poster
 
Posts: 465
Default Expanding Date formula


Hi

I use this formula to calculate how many months and days between two
dates :

=DATEDIF(C4,C6,"YM") & " Months, " & DATEDIF(C4,C6,"MD") & " Days"

However , it doesn't work when there is more than a year between the two
dates.

Can someone advice how to modify the formula so it incorporates the
extra multiples of 12 months if they are present? I only need to return
months and days.

Thanks