text: 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? =(year(a4)-year(a3))*12 +month(a4)-month(a3)  (all in the one cell, obviously)  it's nice to be appreciated, but 10 points would be better! ☺