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

[µo°Ý] ¦p¦ó±N¶g¤»¤Î¶g¤éµ¹¬D¿ï¥X¨Ó ?

[µo°Ý] ¦p¦ó±N¶g¤»¤Î¶g¤éµ¹¬D¿ï¥X¨Ó ?

5¤ëªº¤é¾äªí¦p¤U :

¤é´Á         ¬P´Á
   1¡@¡@¡@¡@¤é
   2¡@¡@¡@¡@¤@
  3¡@¡@¡@¡@¤G
  4¡@¡@¡@¡@¤T
  5¡@¡@¡@¡@¥|
¡@¡D
¡@¡D
¡@¡D

¬D¿ïµ²ªG¦p¤U¡G
¶g¤»¡@¡@¡@¶g¤é
                        1
  7¡@¡@¡@¡@   8
14            15
21            22
28            29

AÄæ¤é´ÁBÄæ¬P´Á
C1=IF(COUNTIF(B:B,$B$1)<ROW(),"",TEXT(INDEX(A:A,SMALL(IF($B$1:$B$31=$B$1,ROW($1:$31),100),ROW(A1))),"D"))
¦pªGªÅ¥Õ¥Î
¶g¤é=IF(SMALL(IF(MOD(ROW(INDIRECT("A40664:A40694")),7)=1,ROW($1:$31),100),ROW(A1))=100,"",SMALL(IF(MOD(ROW(INDIRECT("A40664:A40694")),7)=1,ROW($1:$31),100),ROW(A1)))
³£¬O°}¦C¤½¦¡
¶g¤»§ï=0

TOP

¦^´_ 2# ANGELA

¨º¦pªG­n¦P®É§ä¥X¶g¤»¤Î¶g¤éªº¤é´Á,¤½¦¡­n¦p¦ó§ó§ï?

¶g¤»¤Î¶g¤é
       1
     7
     8
   14
   15
   21
   22

ÁÂÁÂ !

TOP

{=IF(SMALL(IF(MOD(ROW(INDIRECT("A40664:A40694")),7)<2,ROW($1:$31),100),ROW(A1))=100,"",SMALL(IF(MOD(ROW(INDIRECT("A40664:A40694")),7)<2,ROW($1:$31),100),ROW(A1)))}

TOP

°}¦C¤½¦¡
{=IF(ROW(A1)>SUMPRODUCT((WEEKDAY(ROW($40664:$40694),2)>5)*1),"",SMALL(IF(WEEKDAY(ROW($40664:$40694),2)>5,ROW($40664:$40694),""),ROW(A1)))}
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦pªG¸ê®Æ¬O¾î¦¡ªº¸Ü¡A¦p¦ó¦P®É±N¬P´Á¤»¤Î¬P´Á¤é¬D¿ï¥X¨Ó©O :

¤­¤ë¥÷ªº¤é¾ä¦p¤U¡A

¢ÏÄæ¡@¡@¢ÐÄæ¡@¡@¢ÑÄæ¡@¡@¢ÒÄæ¡D¡D¡D¡D¡D
¤é´Á          1          2           3
¬P´Á          ¤é            ¤@             ¤G

¬D¿ïµ²ªG¦p¤U¡G

¬P´Á¤»¤Î¬P´Á¤é¡@¡@1  7  8  14  15¡D¡D¡D

ÁÂÁ¡I

TOP

¤½¦¡¤¤ªºROW(A1) §ï¦¨ COLUMN(A1)

TOP

¦pªG­n§ä¨C­Ó¤ëªº¬P´Á¤».¤éªº¸Ü¡A­n«ç»ò§@©O¡H

ÁÂÁ¡I

TOP

°}¦C¥Î¦h¤F·|³y¦¨µ{¦¡ªº­t¾á,¤ÏÀ³·|«ÜºC,¤×¨ä¬O½ÆÂøªº°}¦C.
{=IF(ROW(A1)>SUMPRODUCT((WEEKDAY(ROW($40664:$40694),2)>5)*1),"",SMALL(IF(WEEKDAY(ROW($40664:$40694),2)>5,ROW($40664:$40694),""),ROW(A1)))}
40664¥i¥H¥Î¤½¦¡date(2011,5,1)´À´«
40694 ¥Î date(2011,6,0)´À´« ¤»¤ëªº²Ä0¤Ñ§Y¬O¤­¤ë©³ µ¥©óDATE(2011,5,31)
¥i¦ba1¿é¤J 2011 b1¿é¤J1 ¥Î¤U¦C¤½¦¡§Y¥i²£¥Í¾ã¦~ªº
b2=IF(ROW(A1)>SUMPRODUCT((WEEKDAY(ROW(INDIRECT(DATE($A$1,$B$1+COLUMN(B1)-1,1)&":"&DATE($A$1,$B$1+COLUMN(B1),0))),2)>5)*1),"",SMALL(IF(MOD(ROW(INDIRECT(DATE($A$1,$B$1+COLUMN(A1)-1,1)&":"&DATE($A$1,$B$1+COLUMN(A1),0))),7)<2,ROW(INDIRECT(DATE($A$1,$B$1+COLUMN(A1)-1,1)&":"&DATE($A$1,$B$1+COLUMN(A1),0)))),ROW(A1)))

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD