c5å ¬å¼åèï¼
=IF(DATE(2014+INT(ROW(A13)/12),MOD(ROW(A13),12)+1,1)<$C$2,"",IF(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1)>$C$3,"",IF(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1)=DATE(YEAR($C$2),MONTH($C$2),1),NETWORKDAYS(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1),$C$2),IF(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1)=DATE(YEAR($C$3),MONTH($C$3),1),NETWORKDAYS(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1),$C$3),NETWORKDAYS(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1),DATE(2014+INT(ROW(A13)/12),MOD(ROW(A13),12)+1,1)-1)))))
ç¶åä¸æå®ç°ã
追é®æ¨å¥½ï¼2015å¹´6ææ¾ç¤ºæ¯4天ï¼æ 论起å§æ¥ææä¹åï¼ææ°ç第ä¸ä¸ªæé½æ¯æé®é¢çï¼ä¾å¦
ï¼éº»ç¦å级ä¸ä¸å
¬å¼ï¼O(â©_â©)O谢谢ï¼
=IF(DATE(2014+INT(ROW(A13)/12),MOD(ROW(A13),12)+1,1)$C$3,"",IF(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1)=DATE(YEAR($C$2),MONTH($C$2),1),NETWORKDAYS($C$2,DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+2,1)-1),IF(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1)=DATE(YEAR($C$3),MONTH($C$3),1),NETWORKDAYS(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1),$C$3),NETWORKDAYS(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1),DATE(2014+INT(ROW(A13)/12),MOD(ROW(A13),12)+1,1)-1)))))