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

[µo°Ý] ¦³ÃöExcel ¤é´Áªí¥Ü¤è¦¡°ÝÃD!

[µo°Ý] ¦³ÃöExcel ¤é´Áªí¥Ü¤è¦¡°ÝÃD!

¦bÀx¦s®æ®æ¦¡¤º ¥i¥HÂà´«¤é´Áªí¥Ü¤è¦¡,¦ý¬O·Q°Ý¤@¤U¤U­±ªº¤è¦¡,À³¸Ó«ç¼Ë³]©w©O?

¨Ò¦p:  1/5/2011     ªí¥Ü¬°  1st may µ¥µ¥

·Ð½Ð¦U¦ìÀ°¦£¸Ñµª

thanks

=TEXT(A1,"mmm_dd")&INDEX({"st","nd","rd","th"},MIN(DAY(A1),4))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    ¥i¬O·|³y¦¨¤@­Ó°ÝÃD­C!! 21th, 22th, 23th  ¦Ó¤£¬O21st, 22nd, 23rd

TOP

¦^´_ 3# handmuch


   §À¼Æ 4¥H«á¥Îth
=TEXT(A1,"mmm_dd")&INDEX({"st","nd","rd","th"},MIN(MOD(DAY(A1),10),4))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    ­è¸Õ¤F¤@¤U¡Aµo²{¦³¤p¤pªº°ÝÃD¥X²{¦b 10st, 11st, 12nd, 13rd, 20st, 30st (¥¿½TÀ³¸Ó¬O10th, 11th, 12th, 13th, 20th, 30th)

­É¥ÎHsieh¤jªº¤½¦¡µy°µ­×§ï¤@¤U(¦³¨Çªø´N¬O¤F)::

=TEXT(A1,"mmm_dd")&IF(AND(DAY(A1)>=11,DAY(A1)<=13),"th",IF(MOD(DAY(A1),10)=0,"th",INDEX({"st","nd","rd","th"},MIN(MOD(DAY(A1),10),4))))

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD