Calculate the difference between two dates

[bsnapool]

Hi All

Anyone halp me hear, Im trying to count the number of months between 2 dates where sometimes this can go over 12 months.

i have so far:

=MONTH($Z$1)-MONTH(G2)

Any help??

 

[Peter_SSs]

Addition to this, is this any way I could add the days on to this formulae??

Is this what you mean?
=DATEDIF(G2,Z1,"m")&"months, "&DATEDIF(G2,Z1,"md")&" days"

 

[bsnapool]

Peter

Spot on, nice one.