Maybe this: =12*(YEAR(B1)-YEAR(A1))+MONTH(B1)-MONTH(A1)