software

Hi,

I have two dates: 1/1/01 amp; 5/25/04
How can i write a formula that will show the number of months from 1/1/01
thru 5/25/04? This should show 53. I don't need days but months.

Thanks,


A3=end date
A2=start date

=MONTH(A3)-MONTH(A2)
Months between two dates in the same year=(YEAR(A3)-YEAR(A2))*12 MONTH(A3)-MONTH(A2)
Months between two dates over a year apartHope it helps--
goober
------------------------------------------------------------------------
goober's Profile: www.excelforum.com/member.php...oamp;userid=19838
View this thread: www.excelforum.com/showthread...hreadid=496569=DATEDIF(A1,B1,quot;mquot;)with 1/1/2001 in A1 and 5/25/2004 in B1

for info about datedif

www.cpearson.com/excel/datedif.htm

don't know where you got 53 from? It's either 40 or 41 depending on how you
count

--
Regards,

Peo Sjoblom

(No private emails please)quot;billyquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I have two dates: 1/1/01 amp; 5/25/04
gt; How can i write a formula that will show the number of months from 1/1/01
gt; thru 5/25/04? This should show 53. I don't need days but months.
gt;
gt; Thanks,Hi,

You can try the formula =DATEDIF(Start date,end date,quot;mquot;). For eg, where
Start date is in cell A1 and end date in cell B1, use =DATEDIF(A1,B1,quot;mquot;).

However, this formula would compute only completed months elapsed
between start date and end date.

Regards

Govind.

billy wrote:
gt; Hi,
gt;
gt; I have two dates: 1/1/01 amp; 5/25/04
gt; How can i write a formula that will show the number of months from 1/1/01
gt; thru 5/25/04? This should show 53. I don't need days but months.
gt;
gt; Thanks,

On Wed, 28 Dec 2005 18:11:02 -0800, quot;billyquot; gt;
wrote:

gt;Hi,
gt;
gt;I have two dates: 1/1/01 amp; 5/25/04
gt;How can i write a formula that will show the number of months from 1/1/01
gt;thru 5/25/04? This should show 53. I don't need days but months.
gt;
gt;Thanks,

How can there be 53 months from 1 January 2001 to 25 May 2004 given that there
are only twelve months in a year???--ron

All.

Thanks for responding to my question with an answer. I actually meant 41
months instead of 53. I added an extra year. Sorry for the confusion.

quot;billyquot; wrote:

gt; Hi,
gt;
gt; I have two dates: 1/1/01 amp; 5/25/04
gt; How can i write a formula that will show the number of months from 1/1/01
gt; thru 5/25/04? This should show 53. I don't need days but months.
gt;
gt; Thanks,

On Wed, 28 Dec 2005 20:07:02 -0800, quot;billyquot; gt;
wrote:

gt;All.
gt;
gt;Thanks for responding to my question with an answer. I actually meant 41
gt;months instead of 53. I added an extra year. Sorry for the confusion.
gt;
gt;quot;billyquot; wrote:
gt;
gt;gt; Hi,
gt;gt;
gt;gt; I have two dates: 1/1/01 amp; 5/25/04
gt;gt; How can i write a formula that will show the number of months from 1/1/01
gt;gt; thru 5/25/04? This should show 53. I don't need days but months.
gt;gt;
gt;gt; Thanks,

OK, but there are still issues in your specifications.

For example, in your dates, May is not a full month, so the number of full
months is actually 40 and not 41. How do you want to resolve this?

And on a related note, how do you want to resolve month counts if the start
date does not begin at the first day of the month?

e.g. How many months between 1/15/05 and 3/3/05?--ron