202208081422月數 (10332)

D2=DATEDIF(B2,C2,"M")+1+(DAY(B2)>DAY(C2))

另解{=SUM(TEXT(B2:C2,"EM")*{-1,1})+1+(YEAR(B2)<>YEAR(C2))*2

另解{=ROUNDUP(YEARFRAC(B2,C2)*12,)+(DAY(B2)>=DAY(C2))

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank