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

[µo°Ý] ­pºâ¡u¬Y¤@¤ë¤À«ü©w¬P´Áªº­Ó¼Æ¡v¤§²Õ¦X¨ç¼Æ¦p¦ó³]©w¡H

[µo°Ý] ­pºâ¡u¬Y¤@¤ë¤À«ü©w¬P´Áªº­Ó¼Æ¡v¤§²Õ¦X¨ç¼Æ¦p¦ó³]©w¡H

½Ð°Ý¦p¥Á°ê103¦~5¤ë¤À§O¦³¦h¤Ö­Ó¬P´Á¤»¡H¬P´Á¤é¡H
(¸ê®Æ¤À¥¬¡GÀx¦s®æA3­È¬°¡u103¡v¡AÀx¦s®æB3­È¬°¡u5¡v)
·q½Ð¦U¦ì«e½ú½ç±Ð¡AÁÂÁ¡I

FIG.JPG (23.72 KB)

FIG.JPG

¥»©«³Ì«á¥Ñ softsadwind ©ó 2013-12-31 16:38 ½s¿è

¦^´_ 1# p212


    C3=SUMPRODUCT((WEEKDAY(ROW(INDIRECT(DATE($A$3+1911,B3,1)&":"&DATE($A$3+1911,B3+1,0))),2)=6)*1)
    C4=SUMPRODUCT((WEEKDAY(ROW(INDIRECT(DATE($A$3+1911,B3,1)&":"&DATE($A$3+1911,B3+1,0))),2)=7)*1)
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 2# softsadwind


    ©ÎªÌ
   C3  =INT((WEEKDAY(DATE($A$3+1911,B3,1)-6,2)+DATE($A$3+1911,B3+1,0)-DATE($A$3+1911,B3,1))/7)
   C4 = INT((WEEKDAY(DATE($A$3+1911,B3,1)-0,2)+DATE($A$3+1911,B3+1,0)-DATE($A$3+1911,B3,1))/7)
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 1# p212

C3 =SUMPRODUCT(--(TEXT(DATE(1911+$A3,$B3,ROW(1:31)),"maaaa")=$B3&LEFT(C2,3)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD