Calculate months between two dates

  Gary Wood 20:43 19 Jun 07
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 07

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

Noldi

  Noldi 20:49 19 Jun 07

Sorry wrong just checked it.

Noldi

  VoG II 20:50 19 Jun 07

With first date in A5, later date in B5

=DATEDIF(A5,B5,"m")

(allegedly).

  postie24 20:54 19 Jun 07

Dont forget "claimed" :))

  Gary Wood 22:39 19 Jun 07

Thanks VoG - that worked perfectly.

Gary

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

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now