ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°Ý«e½ú­Ì¡A¤ë¾äªí¦p¦Ò¼{¸É¯Z¤é¡A¤½¦¡¦p¦ó­×¥¿¡HÁÂÁ±z¡I

[µo°Ý] ½Ð°Ý«e½ú­Ì¡A¤ë¾äªí¦p¦Ò¼{¸É¯Z¤é¡A¤½¦¡¦p¦ó­×¥¿¡HÁÂÁ±z¡I

¤ë¾äªí.zip (7.79 KB)
½Ð°Ý«e½ú­Ì¡A¤ë¾äªí¦p¦Ò¼{¸É¯Z¤é¡A¤½¦¡¦p¦ó­×¥¿¡HÁÂÁ±z¡I

¦^´_ 1# aer

A4=IFERROR(IF(WORKDAY.INTL(A3,1,1,$H$3:$H$15)>EOMONTH($A$3,0),"",IF(COUNTIF($I$3:$I$15,A3+1)=1,A3+1,WORKDAY.INTL(A3,1,1,$H$3:$H$30))),"")
¤U©Ô

TOP

¦^´_ 2# aer

­×¥¿¤½¦¡
A4=IFERROR(IF(A3+1>EOMONTH($A$3,0),"",IF(COUNTIF($I$3:$I$15,A3+1)=1,A3+1,IF(WORKDAY.INTL(A3,1,1,$H$3:$H$30)>EOMONTH($A$3,0),"",WORKDAY.INTL(A3,1,1,$H$3:$H$30)))),"")
¤U©Ô

TOP

¤W¯Z¤é ¥[¸É¯Z¤é(·j´M¿é¤J½s¸¹13062) googleºô§}:https://hcm19522.blogspot.com/
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# hcm19522

ÁÂÁ±z´£¨Ñªº¸Ñªk¡I

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD