EXCEL的具体考勤时间包含在考勤表里? 如图,表B中B3单元格的输入公式为= if (Countifs(表A!$ A: $ A,$ A3,看A!$ b: $ b,date (2021,substitute (lookup ("seat ",$B$1:B$1)," month "),left (b $2,len (b $2)-66。=1,"/","")拉下,然后正确的公式。