difference in months

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Londoner - 17 Apr 2007 15:24 GMT

Hi there
I have 2 dates and i want to calculate the difference in months not years

Any help will be appreciated

Thanks

Londoner

Reply to this Message

WLMPilot - 17 Apr 2007 15:32 GMT

Try theses out. I found them in the Excel HELP.

=MONTH(A3)-MONTH(A2)
Calculates difference in months within same year.

=(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)
Calculates difference in months for dates occurring in different years.

Les

> Hi there
> I have 2 dates and i want to calculate the difference in months not years
[quoted text clipped - 4 lines]
>
> Londoner

Reply to this Message

Sandy Mann - 17 Apr 2007 16:43 GMT

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")

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

> Hi there
> I have 2 dates and i want to calculate the difference in months not years
[quoted text clipped - 4 lines]
>
> Londoner

Reply to this Message