算年資 字符起止日期 (13351)

C2=YEARFRAC(TEXT("R"&SUBSTITUTE(MID(B2,FIND("-",B2)+1,99),".","/"),"YYY/M/D"),TEXT("R"&SUBSTITUTE(LEFT(B2,FIND("-",B2)-1),".","/"),"YYY/M/D"))



留言