=if(month(b2)=month(b7),1,month(b2)-month(b7))
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"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?