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

[µo°Ý] ¤é´Á°Ï¶¡¤¤¦p¦³°²¤é, S3Äæ¦ìÅã¥Ü2

[µo°Ý] ¤é´Á°Ï¶¡¤¤¦p¦³°²¤é, S3Äæ¦ìÅã¥Ü2

I3 = 2013/01/03
R3 = ¥Ñ¬Y¨ç¼Æµ²ªG¨ú±o 3
S3 = I3 + R3 ³o¤§¶¡ªº¤é´Á¦pªG~¦³°²¤é(¤»¤é) S3=Åã¥Ü2

¤]´N¬O»¡ 2013/01/03 + 3 = 2013/01/06
¨º 2013/01/03 ~ 2013/01/06 °Ï¶¡¦pªG¦³°²¤é Åã¥Ü2
¨ç¼Æ±oª¾¥i¯à¥Ñ¥H¤U¨ú±o°Ï¶¡¬O§_¦³°²¤é, ¦³Åã¥Ü2 ¨S¦³Åã¥Ü 0
=IF(--(SUMPRODUCT(WEEKDAY(ROW(INDIRECT(I3+R3&":"&I3+R3)),2)>5)),2,0)

¦ý¬O«ç±o¥Xªºµ²ªG³£¬OS3=0
À³¸Ó¬O INDIRECT(I3+R3&":"&I3+R3) ²q·Q³oÃ䦳°ÝÃD!!

¤£ª¾¹D¬O§_¦³¤j¤j¦³¸Ñ, ©Î¬O¨ä¥L¨ç¼Æ¥i¥H¹F¨ì!!
½Ð¦U¦ì¤j¤jÀ°¦£¤@¤U, ÁÂÁÂ!!

¦^´_ 1# tacoolla


    =(SUMPRODUCT((WEEKDAY(ROW(INDIRECT("A"&I3&":A"&I3+R3)),2)>5)*1)>0)*2
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    «D±`·PÁ Hsieh ª©¥DªºÀ°¦£!! ¦¨¥\¤F! ³o¬O§Ú­nªº¨ç¼Æ, ÁÂÁ±z³á!! :)

TOP

=IF(WEEKDAY(I3,2)+R3>5,2,0) ?

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD