Date Formula

[charlie]

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?

 

[Gary Brown]

=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

 

[FSt1]

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

 

[Pete_UK]

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

Hope this helps.

Pete

 

[Gary Brown]

Good point, Pete.

=if(and(month(b2)=month(b7),year(b2)=year(b7)),1,if(year(b2)=year(b7),month(b2)-month(b7),month(b2)+12-month(b7))

Not tested.

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