With the first date in G1 and the 2nd date in G2 try:
=DATEDIF(G2,G1,"m")
If the dates will not always be witht he earliest date in G1 then use:
=DATEDIF(MIN(G2,G1),MAX(G2,G1),"m")
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"Londoner" wrote in message
...
Hi there
I have 2 dates and i want to calculate the difference in months not years
Any help will be appreciated
Thanks
Londoner