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

[µo°Ý] µoÁ~¤é ³{¤»¤é»¼©µ

[µo°Ý] µoÁ~¤é ³{¤»¤é»¼©µ

¥»©«³Ì«á¥Ñ carzyindex ©ó 2011-3-2 17:43 ½s¿è

¤½¥qµoÁ~¤é¬°¨C¤ëªº18¸¹

³{¤»¤é´N©µ¨ì¬P´Á¤@

½Ð°Ý¨ç¼Æ¸Ó«ç»ò³]©w¦û¥ÎªºÀx¦s®æ¶V¤Ö

·Pı³o°ÝÃDº¡±`¨£ªº  

20110318
20110218
20110118
20101220
20101118
20101018
20100920
20100818
20100719
20100618
20100518
20100419
20100318

¦Û¤vªº°µªkº¡ºGªº

2011/3/18
2011/2/18
2011/1/18
2010/12/18
2010/11/18
2010/10/18
2010/9/18
2010/8/18
2010/7/18
2010/6/18
2010/5/18
2010/4/18
2010/3/18
¥ý¥Îweekday§PÂ_¬P´Á´X¦pªG¬P´Á¤»+2¬P´Á¤é+1
¸÷¨D²¤Æ

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-3-2 22:29 ½s¿è

¥ÎWEEKDAY ©Î¥ÎMOD ³£¤@¼Ë­n¥ÎIF ¥h§PÂ_,¦pªG¤£¼W¥[Äæ¦ì,´N­n¥ÎVBA¥h§PÂ_18¤é¬O§_¬°¶g¥½¦Aª½±µ§â18¤é­×§ï¬°¤U¤@­Ó¬P´Á¤@ªº¤é´Á.
§_«h¥Îªø¤½¦¡
=IF(MOD(DATE(YEAR(TODAY()),MONTH(TODAY()),18),7)=0,DATE(YEAR(TODAY()),MONTH(TODAY()),20),IF(MOD(DATE(YEAR(TODAY()),MONTH(TODAY()),18),7)=1,DATE(YEAR(TODAY()),MONTH(TODAY()),19),DATE(YEAR(TODAY()),MONTH(TODAY()),18)))

TOP

¦^´_ 2# ANGELA


    ­ì¨Ó¤½¦¡¬O³o¼Ë¥Îªº¡A¯u¤£¬O´¶³qªºµu°Ú

TOP

a1¿é¤J2011/3/18
a2=EDATE(DATE(YEAR(A1),MONTH(A1),18),-1)+CHOOSE(WEEKDAY(EDATE(DATE(YEAR(A1),MONTH(A1),18),-1),2),0,0,0,0,0,2,1)
©¹¤U©Ô

TOP

¦^´_ 4# oobird


    choose³o­Ó¨ç¼Æ´X¥G³Q¿ò§Ñ¤F,¯uºÞ¥Î,ÁÂÁ«ü¾É.

TOP

=DATE(2011,ROW(),18)+MID("0000012",WEEKDAY(DATE(2011,ROW(),18)),1)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-3-4 08:24 ½s¿è

=DATE(2011,ROW(),18)+MID("0000021",WEEKDAY(DATE(2011,ROW(),18)),1)
ÅÇ¥S¤]¬O§Úªº±Ò»X¦Ñ®v,ÁÂÁªø¤[¨Óªº±Ð¾É,mid¨ç¤]¥Îªº§®

TOP

=DATE(2011,ROW(),18)+MID("0000021",WEEKDAY(DATE(2011,ROW(),18)),1)
MID³o©Û¤Ó±j¤F
¤£¬O¤@¯ë¤H·|·Q¨ìªº
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD