I have an Excel Question:

I have quarterly dates in Row 1, and I have "new capital committed" values in Row 4, and I am writing formulas in the columns (A-Z).

Is there any way to write a formula that gives me the difference (in months) between the current quarter I am in and the quarter in which the capital was committed?

For example: If cell D1 has 6/30/2013 in it, and cell A4 has 9/30/2012 in it, is there a formula that I can use to get the number of months difference between those two dates, USING a dynamic formula so I can copy and past the formula to other parts of the excel file?

Thank you!

R1

`=(year(d1) - year(a4)) * 12 + (month(d1) - month(a4))`

– Barranka Jun 25 '13 at 23:00