字符起止日 算年資 (13432)

日期：

B2=TEXT(SUM(DATEDIF("r"&SUBSTITUTE(LEFT(A2,FIND("-",A2)-1),".","-"),"r"&SUBSTITUTE(MID(A2,FIND("-",A2)+1,99),".","-"),{"y","ym","md"})*10^{4,2,0}),"0年00月00天")



留言

張貼留言