excel 如何计算每月的最后一个工作日答:=DATE(YEAR(NOW()),MONTH(NOW())+1,0)当前月的最后一个工作日 =IF(WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW())+1,0),2)=6,DATE(YEAR(NOW()),MONTH(NOW())+1,0)-1,IF(WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW())+1,0),2)=7,DATE(YEAR(NOW()),MONTH(NOW())+1,0)-2,DATE(...