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

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

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

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

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD