Month calculating

A

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
 
N

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
[email protected]

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/
 
G

Guest

=DATEDIF(A5,A66,"M")

A5 = first date
A66 = second date
M for months

Should work.


Nav.
 
A

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
 
A

Akuna

Nav, can you explain a lil more?

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

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..
 
N

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
[email protected]

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/
 
Top