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

[µo°Ý] ®æ¦¡¤Æ³]©w°ÝÃD

¦^´_ 10# emma
©w¸qªº°g«ä¦³¬Ý¶Ü?
¸Ì­±¹ï©ó°Ñ·Óªº»¡©ú¨S¬ÝÀ´§a?¤£µMÀ³¸Ó¤£·|¤£À´¬°¦ó¬OA4
§A¿ï¨ú¤£¦PÀx¦s®æ¡A¨º­ÓA4³£·|Åܪº
¨º­Óx¬Oºâ¥X§@¥ÎÀx¦s®æ»P¤é´ÁÄæ¦ìªº¬Û¹ï¦ì¸m
·í§@¥ÎÀx¦s®æ¦bAÄæ¡A¨º»òX·|µ¥©ó0
·í§@¥ÎÀx¦s®æ¦bBÄæ¡A¨º»òX·|µ¥©ó-1
·í§@¥ÎÀx¦s®æ¦bCÄæ¡A¨º»òX·|µ¥©ó-2
·í§@¥ÎÀx¦s®æ¦bDÄæ¡A¨º»òX·|µ¥©ó-3
·í§@¥ÎÀx¦s®æ¦bEÄæ¡A¨º»òX·|µ¥©ó-4
·í§@¥ÎÀx¦s®æ¦bGÄæ¡A¨º»òX·|µ¥©ó0
·í§@¥ÎÀx¦s®æ¦bHÄæ¡A¨º»òX·|µ¥©ó-1
¥H¦¹Ãþ±À
·|¦b0~-4´`Àô¡A©Ò¥H­n¤U³o¼Ëªº®æ¦¡±ø¥ó§AÀ³¸Ó¦b¿ï¨úA4:E4ªº®É­Ô
¦¹®É§@¥ÎÀx¦s®æ¬OA4
¿é¤J®æ¦¡±ø¥ó¤½¦¡=WEEKDAY(OFFSET(A4,,x),2)>=6
«K¯à°÷¥h§PÂ_ OFFSET(A4,,x)³o­Ó¦ì¸mªº­È
³o¦ì¸m¦]¬°x¬O0©Ò¥H´N«ü¨ì¤FA4³o­ÓÀx¦s®æ
³]©w§¹¦¨«á©p´«¦¨¿ï¨úB4µM«á¦b®æ¦¡¤Æ±ø¥ó³W«h¤¤ ¬d¬Ý¤½¦¡
Åܦ¨¤F=WEEKDAY(OFFSET(B4,,x),2)>=6
¦¹®Éx=-1¡AOFFSET(B4,,x)´N«ü¨ì¤FA4¤F
©Ò¥HA4:E4ªºOFFSET¨ç¼Æ­pºâ±o¨ìªº¦ì¸m³£·|¬OA4
­pºâA4ªº¬P´Á´X´Nª¾¹D¬O¤£¬O©P¤»¡B¤é¤F
³]©w§¹A4:E4ªº ®æ¦¡¤Æ±ø¥ó«á½Æ»s®æ¦¡©¹¤U¨ê¨ì²Ä31¤éªº¦C¦ì
³o¼Ë´N¸m¦¨¤@­Ó¤ëªºªí®æ
µM«á©¹¥kªÅ¤@Äæ¶K¤W³o­Óªí®æ´N§¹¦¨¤F

¼g³o¼Ë¤@¤j¦ê¤£ª¾¹D§A¯à§_²z¸Ñ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

°Ñ¦Ò

100¦~«×±Æ¥ðªí.rar (33.19 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ emma ©ó 2010-11-29 15:08 ½s¿è

¦^´_ 11# Hsieh


ÁÂÁÂHsieh¶W¯Åª©¥D¤£¹½¨ä·Ðªº¦A¦¸¸Ñ»¡¡A§Ú¤F¸Ñ¤F¡A´N¥u®t¦b³o¤@¨B¡u®æ¦¡¤Æ±ø¥ó«á½Æ»s®æ¦¡©¹¤U¨ê¡v¡A
´N¬O³o»ò²³æªº°Ê§@¨S¡u®©¡v¥X¨Ó¡AÁÙ²§·Q¤Ñ¶}ªº¥H¬°­n¤@­Ó¤@­ÓÀx¦s®æ¥h³]¥¦= =a
½Ð­ì½Ì¤pªº¸ê½è·M²Â~~³Ò·Ð±z³s³o»ò¤pªº°Ê§@ÁÙ­n¤@¤@¸Ñ»¡¤~©ú¥Õ¡A§Ú·|¦n¦n¤Ï¬Ùªº

TOP

«D±`·PÁÂHsieh ¶W¯Åª©¥D»Pgongª©¥D¡A
¤G¦ìªº¤è®×¬Ò®M¦æµL»~¡A¦ýgongª©¥Dªº¤è¦¡©|¦b²z¸Ñ¤¤(®¤¤pªº¸ê½è·M²Â )

¥t¥~¤pªº·Q¦A°Ý¤@­ÓµL²áªº°ÝÃD¡A´N¥u¬O¯Â¦n©_¦Ó¥H¡A
´N¬O¦p·s¤W¶Çªº¡u³ø¦W²Î­pªí991129¡v¡A·Q­n¦Û°Ê®æ¦¡¤Æ³]©w¦p¤U
1.EÄæ»PFÄ檺¦r«¬ÃC¦â«O«ù¤£ÅÜ
2.³ø¦Wª¬ªp¬°¡u¤w³ø¦W¡v¡A¨ä¸Ó¦C©³¦â³]¬°¡u¶À¦â¡v
¥i¥H¶Ü?¸Ó«ç»ò³]¡A¦]¬°§Ú·Q¤£¥X­Ó©Ò¥HµM¡A
¥Îªº¤èªk¬O¥ý¦Û°Ê¤Æ¿z¿ïFÄæ¿ï¡u¤w³ø¦W¡v¡A¦A°é¿ï¨ä½d³ò¶ñ¤W©³¦â¡C

¡ô³o­Ó¤èªkÀ³¸Ó¬O³Ì²«K¦n¥Îªº¤F§a?¦ýÁÙ¬O·Q¦A¨DÃÒ¤@¤U


2010-11-29_175855.jpg
2010-11-29 18:15
³ø¦W²Î­pªí991129.rar (2.17 KB)

TOP

¦^´_ 14# emma


1. ¿ï¨úA2:G11¡A¦¹®ÉA2¬°§@¥ÎÀx¦s®æ
2. ¤½¦¡=$F2="¤w³ø¦W"
¥¼©R¦W.png
2010-11-29 22:36
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 15# Hsieh


·PÁÂHsieh¶W¯Åª©¥Dªº¼ö¤ß¦^ÂСA½Ð°Ýª©¥D©Ò¨Ï¥Îªº¬O2007ª©ªº¥\¯à¶Ü?
§Ú¨Ï¥Îªº¬O2003ª©¡A§ä¤£¨ì¨ä¬ÛÃöªº³]©w>"<a

TOP

¿ïa2:g11
®æ¦¡>>³]©w®æ¦¡¤Æ±ø¥ó>>¤½¦¡
=$F3="¤w³ø¦W"
¥¼©R¦W.GIF
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 18# shyufc

³o­Ó°Q½×¤£´N¬O§A©Ò»¡ªº®ÄªG¶Ü?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥L¬OÀH«K½Æ»s«e­±ªº¤º®e¨Ó¸ò©«¡A¸ò¥»¨S¥h¤F¸Ñ¥DÃD»¡ªº¬O¤°»ò¡C
¤w§R¤F¥L¦h½g³o¼Ëªº¸ò©«¡AÁÙ¦b§V¤O¤¤¡K

TOP

Ãö©óWeekday³o­Ó¨ç¦¡
§Ú«ÜµL²á¦bA1:A31¿é¤J1~31
¦bB2ª½±µ¨Ï¥Î¤F¤½¦¡WEEKDAY(A1,2)
·íµ²ªG¥X²{«á§Ú¥X²{2­Ó°ÝÃD

¤@¡B·Ó²z»¡A1ªº­È¨Ã«D¤é´Á...¬°¦ó¥L¤´µM¥i¥H¶Ç¦^1~7ªº¼Æ­È
¤G¡BB1ªº­È¬°7
§Ú¬d¬Ý¤µ¦~(2010¦~)1¤ë1¤é¬°¬P´Á¤­, ­Y¥Lª½±µ§ì¨ú¤µ¦~ªº²Ä¤@¤Ñ, À³¸Ó­n¶Ç¦^5¤~¹ï
­Y§ì¹j¦~(2011¦~)1¤ë1¤é¬°¬P´Á¤», À³¸Ó­n¶Ç¦^6¤~¹ï
³Ì«áª½±µ±N¸Ó±N¸ÓÄæ®æ¦¡§ï¬°¤é´Á¤~µo²{¸ÓÄæ¦ì¬°1900/1/1
¦]¬°windowsªº¤é´ÁµLªk³]¬°1990¦~µLªkÅçÃÒ¬O§_¯uªº¬°¬P´Á¤é
©Ò¥H¤S¦bE1ª½±µ¿é¤J1900/1/1, D1=WEEKDAY(E1,2)
¬Ý°_¨Ó¥L¬O§ì¨ú³o­Ó¤é´Á¨S¿ù
¥i¬OA1¦b³]©w¦¨¤é´Á®æ¦¡«e(¤]¸Õ¹L¨ä¥L¨Ã«D¤é´Áªº®æ¦¡)
¬°¦óweekday·|¦Û°Ê±N¸ÓÄæ¦ìªº¼Æ­ÈÂà´«¦¨¤é´Á?

TOP

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