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

¦Û°Ê±a¥X©Ò»Ý¤é´Á

¦Û°Ê±a¥X©Ò»Ý¤é´Á

·Q¥ÎA1ªº¤é´Á±a¥X3¤é,5¤é,10¤éªº¹ê»Ú¤é´Á(¤£§t°²¤é)

Book1.rar (3.02 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2014-10-24 12:05 ½s¿è

¦^´_ 1# yan2463
Àx¦s®æA2¤é´Á¬°2014/10/20
¹ïÀ³Àx¦s®æH1¤§3 ¤é¦¬½Lªº¡u3 ¤é¡v¤é´Á¬° =WORKDAY(A2,2) ¡÷ 10¤ë22¤é
¹ïÀ³Àx¦s®æJ1¤§5 ¤é¦¬½Lªº¡u5 ¤é¡v¤é´Á¬°=WORKDAY(A2,4) ¡÷ 10¤ë24¤é
¹ïÀ³Àx¦s®æL1¤§10 ¤é¦¬½Lªº¡u10 ¤é¡v¤é´Á¬°=WORKDAY(A2,9) ¡÷ 10¤ë31¤é
½Ð°Ñ¦Ò¡I

TOP

¥»©«³Ì«á¥Ñ yan2463 ©ó 2014-10-24 13:14 ½s¿è

¦^´_ 2# p212


    ¸Õ¤F¦ý¬O¥X²{¿ù»~°T®§
    §Ú¬O¥Î2003ªº

TOP

¦^´_ 3# yan2463


   
§Ú¬O¥Î2003ªº
¤u§@ªí«ü¥O [¤u¨ã]->[¼W¯q¶°] ¤Ä¿ï "¤ÀªR¤u¨ã½c"
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 4# GBKEE
ÁÂÁÂ,ÁöµM¤½¥qªº¹q¸£µLªk¦w¸Ë¤ÀªR¤u¨ã

TOP

¦^´_ 5# yan2463

¤£¯à¥ÎWORKDAY®É¡A´N¥u¯à¤gªk·Ò¿û

=SMALL((WEEKDAY(A2+{0,1,2,3}+{0;4;8;12},2)>5)*99+A2+{0,1,2,3}+{0;4;8;12},3)
=SMALL((WEEKDAY(A2+{0,1,2,3}+{0;4;8;12},2)>5)*99+A2+{0,1,2,3}+{0;4;8;12},5)   
=SMALL((WEEKDAY(A2+{0,1,2,3}+{0;4;8;12},2)>5)*99+A2+{0,1,2,3}+{0;4;8;12},10)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ML089

ÁÂÁÂ,¥i¥H¥Î¤F,
¥i§_¦A½Ð°Ý¤@¤U
¦pªG¦³«D©P¥ð¤G¤éªº°²¤é,
¥i¥H¥[¤J¥ð°²¤é¤¤¶Ü

TOP

¦^´_ 6# ML089

¯uªº·P®¦,¦ý¯uªº¬Ý¤£À´
¥i§_³Â·ÐÀ°§Ú¸Ñµª

TOP

¦^´_ 7# yan2463

¥[¤J°²¤é¶·¥t¥~«Ø¥ß°²¤éªí
´£¨Ñ3ºØ¤½¦¡»PWORKDAY¨ç¼Æ¬Û¤ñ¸û

WORKDAY»P¤½¦¡¤ñ¸û.rar (18.79 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 8# yan2463

=SMALL((WEEKDAY(A2+{0,1,2,3}+{0;4;8;12},2)>5)*99+A2+{0,1,2,3}+{0;4;8;12},3)

{0,1,2,3}+{0;4;8;12} ·|²£¥Í 0~15 ¼Æ¦r

WEEKDAY(A2+{0,1,2,3}+{0;4;8;12},2)>5)*99 ´N¬O§PÂ_ A2¤é´Á+0 ~15¤é«á­Y¬°¬P´Á¤­¥H¤W(¬P´Á¤»¡B¬P´Á¤é)®É¬° 99¡A¸Ó¤é´N·|±Æ¨ì«á­±¥hÁקK³QSMALL¿ï¨ú

­pºâ¥Ü·N¹Ï
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD