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

¤é´Á ¬Û´î ¹J¨ì¤»¤é ªº°ÝÃD£»

¤é´Á ¬Û´î ¹J¨ì¤»¤é ªº°ÝÃD£»

·Q½Ð°Ý¤j¤j  ¦]¬°workday  ¤£¯à¥Î´îªº   
¨Ò¦p:  
2014/3/29   ¬O¬P´Á¤»
2014/3/30   ¬O¬P´Á¤é


A-B = 2014/3/29 ªº®É­Ô¥L·|©¹«e±À¨ì ¬P´Á¤­ ¤]´N¬O2014/3/28
C-D = 2014/3/29 ªº®É­Ô¥L¤]·|©¹«e±À¨ì ¬P´Á¤­ ¤]´N¬O2014/3/28

¦b½Ð°Ý¥i¥H¥[¤J¯S§O°²¤é¶Ü??    ÁÂÁÂ

=WORKDAY(A1+B1+1,-1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ª©¤j §Ú¬O³]©w¦¨
=WORKDAY(µ²ªG,-1,°²¤é)
¦ý¦³®É­Ô ¨º­Ó°²¤é·|¨q¤æ  ³s´¶³q¤é¤]³£ -1¤Ñ ¨Ò¦p  µ²ªG=2014/3/28
¥LÁÙ¬Oµ¹§Ú-1¤ÑÅܦ¨  ¥b2014/3/27   ¬O¤£¬O§Ú³]©wªº¦a¤è¿ù»~¤F

TOP

¦b½Ð°Ý坂¤j   ¨º­Ó+1 ªº·N«ä¬O  ?? ¤£À´¬°¤°»ò
=WORKDAY(A1+B1+1,-1)   

ÁÂÁ±zªº¦^µª ^^

TOP

¦^´_ 4# smgm1234


    =WORKDAY(µ²ªG+1,-1,°²¤é)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# smgm1234

­pºâ«áªº¤é´Á¡A¦p¹J¨ì¤»¡B¤é¤Î¯S§O°²¤é¡A¤é´Á¶·§ï¬°«e³Ìªñ¤§¤u§@¤é´Á

»s§@¸Õºâ½d¨Òµ¹§A°Ñ¦Ò¡A¤½¦¡¦b¹Ï¤ù¤¤¥]§t¯S§O°²¤é
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

«D±`·PÁª©¤jªº¸Ô²Ó±Ð¾Ç  ÁÂÁ§A  ¤S¾Ç¨ì¤F

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD