- ©«¤l
- 43
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 74
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-1-17
- ³Ì«áµn¿ý
- 2020-8-24
|
¦^´_ 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)))) |
|