Calculate months between two dates

  Gary Wood 20:43 19 Jun 2007
Locked

I have two columns of dates in Excel and need to know the number of months between each pair (rounded down, rather than up). The dates are all British format (i.e. 19/06/2007 is 19 June 2007). All the formulas I can find assume an American style date. Can anyone tell me the correct formula?

Thanks,

Gary

  Noldi 20:48 19 Jun 2007

=MONTH(A1-B1) then format the cells acordingly.

Noldi

  Noldi 20:49 19 Jun 2007

Sorry wrong just checked it.

Noldi

  VoG II 20:50 19 Jun 2007

With first date in A5, later date in B5

=DATEDIF(A5,B5,"m")

(allegedly).

  postie24 20:54 19 Jun 2007

Dont forget "claimed" :))

  Gary Wood 22:39 19 Jun 2007

Thanks VoG - that worked perfectly.

Gary

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Best of the Grad Shows 2017: University of the West of England (UWE)

Best value Mac: Which is the best £1249 Mac to buy

Les meilleures GoPro 2017