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

­pºâ¤é´Á½d³ò¤º¥]¬A¦h¤Ö­Ó¬P´Á¤é

­pºâ¤é´Á½d³ò¤º¥]¬A¦h¤Ö­Ó¬P´Á¤é

¦U¦ì°ª¤â

½Ð°Ý¦p¦ó­pºâ¨â­Ó¤é´Á¤¤¶¡¦³´X¦h­Ó¬P´Á¤é
(¥]¬A­º§À¨â¤Ñ)
¨Ò¦p¿é¤J1/5/2011 ¤Î 13/6/2011
«K·|­pºâ¥X¦@¦³7­Ó¬P´Á¤é

enoch

=SUMPRODUCT((WEEKDAY(ROW(INDIRECT(DATEVALUE("2011/5/1")&":"&DATEVALUE("2011/6/13"))),2)=7)*1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

hsieh

ÁÂÁª©¥D,
¥i§_±Ð§Ú¦p¦ó©ú¥Õ¤W­z¤½¦¡,
SUMPRODUCT ¤Î ROW Ú»§¹»¡©ú³£­øÃÑ¥Î
¥i¥H¦³¨ä¥L¨Ò¤l±Ð¾É¶Ü?

enoch

TOP

A1=2011/5/1
B1=2011/6/13
C1=SUMPRODUCT((WEEKDAY($A$1+ROW(INDIRECT(1&":"&(B1-A1+1)))-1,2)=7)*1)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

A1=2011/5/1
B1=2011/6/13
C1=INDEX(FREQUENCY(WEEKDAY($A$1+ROW(INDIRECT(1&":"&(B1-A1+1)))-1,2),6),2)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD