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

¥À¿Ë¸`=DATE(B1,5,15-WEEKDAY(DATE(B1,5,1),2))
¬P´Á¤é
¸t½Ï¸`=DATE(B1,12,25)
¬P´Á=TEXT(E8,"aaaa")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

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

¦^´_ 4# PD961A


    ¨S§A»¡ªº²{¶H£«
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

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

TOP

¦^´_ 5# Hsieh

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

ÁÂÁÂ..

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

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

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

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

TOP

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

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD