Expanding Date formula

  • Thread starter Thread starter Colin Hayes
  • Start date Start date
C

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
 
cpearson.com has information regarding the datedif function.

Try changing "ym" to just "m"
Click to expand...


Hi

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

Grateful for your help.


Best Wishes ,
 
Back
Top