Month calculating

[Akuna]

Hi,

I need to calculate the months between tow dates, from diferent years
Can´t find any formula that works fine..... any one help please
Thanks!

Mik

 

[Norman Harker]

Hi Akuna!

Try:
=DATEDIF(A1,A2,"m")

Counts the completed months between the earlier date (A1) and the
later date (A2).

For details of this mysterious function see:

http://www.cpearson.com/excel/datedif.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/

 

[Peo Sjoblom]

One way

=DATEDIF(Start_Date,End_Date,"m")

see:

http://www.cpearson.com/excel/datedif.htm

 

[Guest]

=DATEDIF(A5,A66,"M")

A5 = first date
A66 = second date
M for months

Should work.


Nav.

 

[Akuna]

1st of all, thanks for such quick answers!

Now, on to the problem....

I´ve already tried to use the DATEDIF function, somehow it´s no
working. I treid to put the dates in diferent formats, such as mm-yy
mm-yyyy, yy-mm and so on.... it never works.

I´m confused here :confused

 

[Akuna]

Nav, can you explain a lil more?

I don´t quite understand your solution.... sorry... :rolleyes

 

[Peo Sjoblom]

What do you mean it is not working, did Excel crash? It should return an
integer
between 0 and 1251 as of today. If it is not working your dates are not
dates.
Use real dates like 01/31/2004 or 31-01-2004 etc..

 

[Norman Harker]

Hi Nav!

If you have dates that a recognised by Excel as dates in A1 and A2 and
as long as A1 is earlier than A2

=DATEDIF(a1,a2,"m")

If you want a hard coded working example:

=DATEDIF("23-Feb-2002","26-Jul-2004","m")
Returns 29


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/