Date Formula
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?
|