ªð¦^¦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´Áªº¤½¦¡
ÁÂÁÂ...

¦^´_ 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

³o¼Ë¦n¶Ü
¦]¬°·|¦]¥Î¨º¥x¹q¸£¦Ó²§
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

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

¦^´_ 11# gong


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

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

TOP

1
¨ì©³¬O1904/1/2
ÁÙ¬O1900/1/1
¤GªÌ³£¹ï,
­n¬Ý¤u¨ã>¿ï¶µ>­pºâ>1904¦~¤é´Á¨t²Î¬O§_¦³¤Ä
¦³¤Äªº¬°1904/1/2
¨S¤Äªº¬°1900/1/1
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥t¸Ñ: =DATE(A1,5,)-WEEKDAY(DATE(A1,5,),2)+14

TOP

F9=WEEKDAY(E9,1)
­È¬°1
ªí¥Ü¬°1900/1/1
·í¤Ñ¬°¬P´Á¤»©Ò¥HF9Åã¥Ü¬P´Á¤»

«ØijF9=E9
®æ¦¡³]¬°¬P´Á§Y¥i

¨ä¥Lªº¬P´Á¤]³£¦³°ÝÃD
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

weekday¶Ç¦^¬O1~7ªº¼Æ¦r
§A®æ¦¡³]¦¨¤é´Á
¹ê»Ú­È¬O1
©Ò¥H¥L¬O³Q»{¬°1904/1/2
¨Ã«D2010/5/9
F9¤½¦¡§ï¬°=E9«Kª¾
¨ä¾l°²´Á¤]¬O¤@¼Ë
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# Hsieh

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

ÁÂÁÂ..

TOP

¥À¿Ë¸`¸Õ¸Õ³o¼Ë¬Ý¬Ý
=DATE(B1,5,14)-MOD(DATE(B1,5,)-1,7)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD