每日排程

熱烈參與勳章

1^# 跳轉到 »

發表於 2021-6-1 13:48 | 顯示全部帖子

(CHOOSE(WEEKDAY(O$6,2),"週一","週二","週三","週四","週五","週六","週日")="週六")+(CHOOSE(WEEKDAY(O$6,2),"週一","週二","週三","週四","週五","週六","週日")="週日") 可改 MOD(O$6-2,7)>4

google"EXCEL迷" blog 或google網址:https://hcm19522.blogspot.com/

靜思自在 : 不要小看自己，因為人有無限的可能。