We have column G containing the dates formatted:

**3/10/2006**

and we have column P containing only the number of months, i.e.:

**9**

I tried

**=MONTH(G2)-MONTH(P2)**, but if the month in column G is greater than the month in column P, I need to count FROM G to P. For example, assume:

G = 11/31/1991 and P = 09, the difference I need to calculate is FROM 11 to 09, which would be 10 months. The formula above gives me -2 months. I need it to calculate the difference in months going forward if that makes any sense. I also need the result to be in NUMBER format (which the MONTH formula gives). We will use that result to multiply with a rate.

I know our formatting is weird, but this is the data we have to work with and it's a couple of thousand rows. Thank you.