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

­pºâ¤u§@¤é°ÝÃD

­pºâ¤u§@¤é°ÝÃD

½Ð°Ý¤j¤j­Ì¦³¤°»ò¤½¦¡¥i¥H­pºâ¤u§@¤é?

eg.
2011/1/5 - 2011/1/1 = 0¦~0¤ë4¤é
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

networkdays(start_day,end_day,[holidays])
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

ÁÂÁÂHsieh¤j¤j.
¦ý¬O¦p¦ó¥X   0Year 0Month 4Day
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¤u§@¤Ñ¼Æ§A¥H¬Æ»ò¼Ð·Ç¨Ó­pºâ¦~¤ë?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


     30¤Ñ1¤ë , 365 ¤@¦~
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

A1°_©l¤é
B1µ²§ô¤é
¤u§@¤é=INT(NETWORKDAYS(A1,B1)/365)&"¦~"&INT(MOD(NETWORKDAYS(A1,B1),365)/30)&"¤ë"&MOD(MOD(NETWORKDAYS(A1,B1),365),30)&"¤é"
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh


    ·PÁÂHsieh¤j¤j.^^
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¥»©«³Ì«á¥Ñ hugh0620 ©ó 2011-1-7 11:13 ½s¿è

¦^´_ 7# basarasy


    basarasy ~ ³o¼Ë§Aªººâªk¥i¯à·|¦³»~­ò~ ¨C¤ë¦³¤j¤ë(31)¤p¤ë(30) 2¤ë¤S¦³28¤Ñ29¤Ñªº°Ï¤À
               ­Y¶È¬O¥Î30¤Ñ¬°°ò·Ç,±o¨ìªº¸ê®Æ¥i¯à·|¦³¸¨®t

               ¤p¤pªº·Qªk,¶È¨Ñ°Ñ¦Ò
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD