I forgot to mention that if the difference is 0, i would like the cell to
remain blank instead of showing the 0.

"Shannan" wrote:

Hi,
I am trying to find a formula that will subtract the dates from two columns
and give me the difference in months. I had " =MONTH(AD15)-MONTH(Y15)", but
i've just realized that if one date is 2007-09-08 and the other is
2006-11-27, then the formula i was using does not account for the years being
different and gives me an answer of -2. How do i account for the years?
Thanks.

Shannan