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

¨D¤ëªì¦Ü¤µ¤é¤u§@¤Ñ¼Æ(¦©°£°²¤é)

¨D¤ëªì¦Ü¤µ¤é¤u§@¤Ñ¼Æ(¦©°£°²¤é)

¨D¤ëªì¦Ü¤µ¤é¤u§@¤Ñ¼Æ(¦©°£°²¤é) , ¦pªþ¥ó

¨D¤ëªì¦Ü¤µ¤é¤u§@¤Ñ¼Æ(¦©°£°²¤é).rar (7.26 KB)

¥»©«³Ì«á¥Ñ joblyc017 ©ó 2017-11-15 14:15 ½s¿è

¦^´_ 1# 074063

    NETWORKDAYS.INTL ¨ç¼Æ
   
   
    ­YµLªk¨Ï¥ÎNETWORKDAYS.INTL¨ç¼Æ¡A¥i°Ñ¦Ò¤U¹Ï§@ªk¡G
   

TOP

A1=±Ò¤î¤é ¥i³] 2017/11/01
A2=ºI¤î¤é ¥i³] 2017/11/15
¨Ï¥Î¦p¤U²[¼Æ§Y¤é´Á¬Û´î(¦©¶g¤»¶g¤é)
·í¤éºâ+1 ¤£ºâ¤£»Ý+1
=A2-A1-SUM(INT((A2-{1,7})/7)-INT((A1-{1,7}-1)/7))+1
ù

TOP

¦^´_ 3# rouber590324


    ÁÂÁÂrouber590324¤j¤j¸Ñµª:)

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD