C2=TEXT(SUM(MOD(INT((DATEDIF("r"&A2,"R"&B2,"D")+1)*7^{-1,0}),{1E9,7})*{10,1}),"0!W0!D")
另解{=TEXT(SUM(MOD(INT((SUM(("r"&A2:B2)*{-1,1})+1)*7^{-1,0}),{1E9,7})*{10,1}),"0!W0!D")
另解=INT((DATEDIF("r"&A2,"R"&B2,"D")+1)/7)&"W"&MOD(DATEDIF("R"&A2,"r"&B2,"D")+1,7)&"D"
留言
張貼留言