Question: In MS Excel, what formula should I use to work out the amount of months between 2 dates? I have a column with a list of dates my car was serviced - this column is formatted as "dd/mm/yyyy". I need to work out (in the next column) how many months have passed between the service dates. Can anyone help me with a formula to work this out?

Answer: =(YEAR(A4)-YEAR(A3))*12\n+MONTH(A4)-MONTH(A3)\n\n(all in the one cell, obviously)\n\nIt's nice to be appreciated, but 10 points would be better! ☺
This question from the Yahoo Q&A forum is categorized in the topic: Science & Mathematics