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 ,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IF formula question 3
Calculate difference in dates 11
Calculate age with an end date 3
Update Upon Opening based on DATEIF NOW() 10
changed DOB to age, but if no DOB need cell to be empty. 4
Summary of Difference between dates in years, months, days 3
datedif 1
Totalling Formulas 10

Back
Top