A8中填寫 例如：2010/10/15

A9中填寫如下公式得出結果 5

=IF(DAY(A8)>=10,IF((MONTH(NOW())-MONTH(A8))<0,MONTH(NOW())-MONTH(A8)+(YEAR(NOW())-YEAR(A8))*12,MONTH(NOW())-MONTH(A8))-1,IF((MONTH(NOW())-MONTH(A8))<0,MONTH(NOW())-MONTH(A8)+(YEAR(NOW())-YEAR(A8))*12,MONTH(NOW())-MONTH(A8)))

=IF(DAY(A8)>=10,IF((MONTH(NOW())-MONTH(A8))<0,MONTH(NOW())-MONTH(A8)+(YEAR(NOW())-YEAR(A8))*12,MONTH(NOW())-MONTH(A8)),IF((MONTH(NOW())-MONTH(A8))<0,MONTH(NOW())-MONTH(A8)+(YEAR(NOW())-YEAR(A8))*12,MONTH(NOW())-MONTH(A8))+1)