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

[µo°Ý] ½Ð°Ý¿é¤J¦~¥÷«á.¥i¦Û°Ê±a¥X¸`¤éªº¹ê»Ú¤é´Áªº¤½¦¡

[µo°Ý] ½Ð°Ý¿é¤J¦~¥÷«á.¥i¦Û°Ê±a¥X¸`¤éªº¹ê»Ú¤é´Áªº¤½¦¡

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-6-23 17:57 ½s¿è

½Ð°Ý¦U¦ì¥ý¶i
°²³]¿é¤J¦~¥÷2009«á.
¥i¦Û°Ê±a¥X¸`¤é¹ê»Ú¤é´Á¤Î¬P´Áªº¤½¦¡
ÁÂÁÂ...

¦^´_  Hsieh

ÁÂÁª©¥D
    ¥À¿Ë¸`ªº¤½¦¡=DATE(B1,5,15-WEEKDAY(DATE(B1,5,1),2)).ÁÂÁÂ
   
   ¸t½Ï¸`ªº¤½¦¡=DATE(B1,12,25)
   ­ì¨Ó¬O¥Î=DATE($B$1,C8,D8)
ÁÂÁ±z..

TOP

¦^´_ 2# Hsieh

¥i¥H½Ð°Ýª©¥D
    ­ì¥À¿Ë¸`ªº¤½¦¡
'=DATE(B1,5,1)+IF(1<WEEKDAY(DATE(B1,5,1)),7-WEEKDAY(DATE(B1,5,1))+1+(2-1)*7,1-WEEKDAY(DATE(B1,5,1))+(2-1)*7)
¦ý¬O·|Åܦ¨
¬P´Á¤»
½Ð°Ý­þ¸Ì¤£¹ï
¥i¥H½Ð±z­×¥¿¨Ã¸ÑÄÀ¶Ü?
ÁÂÁ±z...

TOP

¦^´_ 5# Hsieh

ÀÉ®×¥N¥X¬O¬P´Á¤»
    ¸`¤é­pºâ.rar (4.17 KB)

ÁÂÁÂ..

TOP

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-6-24 11:56 ½s¿è

¦^´_ 11# gong


    ÁÂÁª©¥D
ª½±µ±N\­pºâ\¤Ä¿ï¨ú®ø
¦¨¬°±z»¡ªº1900¦~®æ¦¡
¥¦ªº¤½¦¡´N¥i¥H¥Î(¤£¥Î¦A­×§ï¤é´Á®æ¦¡¨ºÄæ)
ÁÂÁÂ...

¤]ÁÂÁ¨ä¥L¥ý¶i­Ì¤Îª©¥Dªº¦^¤å..

TOP

¦^´_ 13# gong


    GONGª©¥D
³o¼Ë¤£¦n¶Ü?
¸Õ¹L±zªº¤è¦¡´N·|ª¾¹D..¨º­Óµ{¦¡"¿ù»~"ªº¦a¤è..
¦pªG±z¨S»¡..¨S¥hRUN¹L«ç»ò·|ª¾¹D­ì¨Ó¨º­Ó¤½¦¡¬O¥i¦æªº...

¦ý¬O¦b¬Ý¦¹½g¤å³¹ªº¤H..«o¯à±q¨ä¤¤ª¾¹D
¤£¦Pªº¤½¦¡¦b¤£¦Pªº¤ºÁä³]©w¤Wªº®t²§ÂI
¦A¨Ì¾Ú¦Û¤vªº»Ý¨D..¥h°µ¿ï¾Ü
¦ý¬OÁÙ¬OÁÂÁ±z¦^³o½g¤å
¦]¬°¬OµeÀsÂI·ú...
ÁÂÁ±z..

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD