Q2:Q3輸入放假起訖日B2{=IF(MEDIAN(SUBSTITUTE(B$1,"月","/")*1,SUBSTITUTE($Q$2:$Q$3,"月","/")*1)-SUBSTITUTE(B$1,"月","/")=0,"OFF",IF(MEDIAN(SUBSTITUTE(B$1,"月","/")*1,SUBSTITUTE(请假表!$D2:$E2,"月","/")*1)-SUBSTITUTE(B$1,"月","/")=0,"請假","V"))
B16:O19=IF(MEDIAN(B$15,$Q$16:$Q$17)=B$15,"OFF",IF(MEDIAN(B$15,$M9:$N9)=B$15,"請假","V"))
留言
張貼留言