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

[µo°Ý] ½Ð°Ý«ç­pºâ "¤µ¤Ñ + 2­Ó§@¤Ñ" (¤£­pºâ¬P´Á¤é¤Î¤½²³°²´Á)

[µo°Ý] ½Ð°Ý«ç­pºâ "¤µ¤Ñ + 2­Ó§@¤Ñ" (¤£­pºâ¬P´Á¤é¤Î¤½²³°²´Á)

¦U¦ì¦n¡A¥»¤H²Ä¤@¦¸¥X¶K, ½Ð«ü±Ð^^

°ÝÃD¦p¤W, §Æ±æ­pºâ+2 ªº¤é¤l (¬P´Á¤@¦Ü¬P´Á¤»¬°¤u§@¤Ñ)

¨Ò¤l
1. ¿é¤J 9/24/2015 (¬P´Á¥|), ­pºâ«áÀ³¬° 9/26/2015 (¬P´Á¤»)
2. ¿é¤J 9/25/2015 (¬P´Á¤­), ­pºâ«áÀ³¬° 9/29/2015 (¬P´Á¤G)
3. ¿é¤J 9/26/2015 (¬P´Á¤»), ­pºâ«áÀ³¬° 9/30/2015 (¬P´Á¤T)
4. ¿é¤J 9/30/2015 (¬P´Á¤T), ­pºâ«áÀ³¬° 10/3/2015 (¬P´Á¤»)

°²´Á
09/28/2015 (¬P´Á¤@)
10/01/2015 (¬P´Á¥|)
10/21/2015
12/25/2015
12/26/2015

¥»©«³Ì«á¥Ñ p212 ©ó 2015-8-12 16:04 ½s¿è

¦^´_ 1# tangowong
°²³]¦bÀx¦s®æA1¿é¤J¤é´Á¡A1#¨ÒÁ|ªº¡u°²´Á¡v¸ê®Æ¦ì©óD1:D5
«hÀx¦s®æB1¿é¤J¤½¦¡
=WORKDAY.INTL(A1,2,11,$D$1:$D$5)
½Ð°Ñ¦Ò¡I
ª`¡G¿é¤J¡u¤é´Á¡v®É¡A½Ð¥HExcel±µ¨üªº®æ¦¡¿é¤J¡C

TOP

¤£¦n·N«ä, §Úªº¤½¥q¤£¤ä«ù Excel 2010 ¤½¦¡, ½Ð°Ý¦³¨S¤èªk¦b 2007 ª©¥»?

TOP

°²³]¦bÀx¦s®æA2¿é¤J¤é´Á¡AB2¿é¤J¤Ñ¼Æ¡AH:H¿é¤J¡u°²´Á¡v
«hÀx¦s®æC2¿é¤J¤½¦¡
{=SMALL(((WEEKDAY(A2+ROW($1:$365),2)=7)+ISNUMBER(MATCH(A2+ROW($1:$365),H:H,)))*10^9+A2+ROW($1:$365),B2)}
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¤Ó§Q®`¤F, ÁÂÁ«ü±Ð

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD