On Tue, 11 Feb 2014 22:51:11 +0000, Colin Hayes wrote:


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


cpearson.com has information regarding the datedif function.

Try changing "ym" to just "m"