Month calculating

  • Thread starter Thread starter Akuna
  • Start date Start date
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
 
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/
 
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
 
Nav, can you explain a lil more?

I don´t quite understand your solution.... sorry... :rolleyes
 
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..
 
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/
 
Back
Top