Use NETWORKDAYS to return the workdays and wrap in IF to get blank the weekends: =IF(WORKDAY(A1-1,1)=A1,NETWORKDAYS(EOMONTH(A1,-1)+1,A1),"").
確定! 回上一頁