<div>
You may use difference between dates and divide by 30, so in column c you put:<br />
=(B1-A1)/30<br />
<br />
make sure to format column c as numbers with 0 decimal places
</div>


You may use difference between dates and divide by 30, so in column c you put:
=(B1-A1)/30

make sure to format column c as numbers with 0 decimal places

<div>
Thanks for the feed back let me test to see end result 
</div>


Thanks for the feed back let me test to see end result

<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
How would you acturally calculate the number of months between two dates:-<br />
<br />
Col A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Col B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Col C<br />
1 Feb 2011 &nbsp; &nbsp; &nbsp; &nbsp;30 April 2011 &nbsp; &nbsp; &nbsp;3 months<br />
<br />
so the date in col A always has to be the start of the month and the date in col b the end of the month. (results in col C)<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp;
</div>
</div>


Hi Experts

How would you acturally calculate the number of months between two dates:-

Col A                  Col B                  Col C
1 Feb 2011        30 April 2011      3 months

so the date in col A always has to be the start of the month and the date in col b the end of the month. (results in col C)

       

calculating the number sof months between to dates

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.