Strictly speaking, you should check for month and year being the same.

Hope this helps.

Pete

On Jul 10, 6:47*pm, FSt1 wrote:
hi
i didn't use you cell address to test this but it works. make the
adjustments to fit your data.
=IF(MONTH(C2)-MONTH(B2)=0,1,MONTH(C2)-MONTH(B2))

regards
FSt1



"charlie" wrote:
I need a formula that will subtract March from June returning only the number
of months. For example:
6/1/08-3/1/08=3
6/1/08-3/15/08=3
6/1/08-4/15/08=2
6/1/08-5/15/08=1

However, 6/1/08-6/1/08 also need to = 1

What I have right now is 6/1/08 in cell B2 and the date to subtract in cell
B7 with this formula:
SUM(MONTH(B2)-MONTH(B7))
I get the result that I need with all of the above except for when using
6/1/08 in cell B7. *How can I modify the formula so that any time that date
is used it will also return a 1?- Hide quoted text -

- Show quoted text -