Expanding Date formula

[Colin Hayes]

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

 

[Ron Rosenfeld]

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"

 

[Colin Hayes]

cpearson.com has information regarding the datedif function.

Try changing "ym" to just "m"

Hi

OK thanks for this. It's working fine now.

Grateful for your help.


Best Wishes ,