这个是我曾经写过的一个,给你参考
=WORKDAY(H9,J9-(NETWORKDAYS(H9,H9,'Holiday & work On weekend'!$B$2:$H$100)>0),'Holiday & work On weekend'!$B$2:$H$100)-COUNTIFS('Holiday & work On weekend'!$K$1:$K$100,">="&Timeline!H9,'Holiday & work On weekend'!$K$1:$K$100,"<="&WORKDAY(H9,J9,'Holiday & work On weekend'!$B$2:$H$100))
'Holiday & work On weekend'!$B$2:$H$100是节假日所在的区域,'Holiday & work On weekend'!$K$1:$K$100是节假日变为工作日日期所在的区域