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

IFªº¤é´Á°ÝÃD

IFªº¤é´Á°ÝÃD

½Ð±Ð¤é´Áªº§PÂ_¤½¦¡ Book2.zip (7.03 KB)
¦pªG¹w¥æ¤é´Á¤p©ó2012/03/31,¥æ³f¤ë¥÷´NÅã¥Ü2012-03,
¦pªG¹w¥æ¤é´Á¦b2012/04¤ë¥÷,¥æ³f¤ë¥÷´NÅã¥Ü2012-04
¦pªG¹w¥æ¤é´Á¦b2012/05¤ë¥÷,¥æ³f¤ë¥÷´NÅã¥Ü2012-05
¦pªG¹w¥æ¤é´Á¦b2012/06¤ë¥÷,¥æ³f¤ë¥÷´NÅã¥Ü2012-06

=TEXT(LOOKUP(A2,{40544,40999,41029,41060,41090},{40999,41029,41060,41090,41121}),"yyyy-mm")
AÄæ­n§ï¦¨¤é´Á®æ¦¡¡C

TOP

¦^´_ 1# VANESSA

=IF(--(TEXT(A2,"yyyy-m-")&1)<DATE(2012,4,1),"2012-3",YEAR(A2)&"-"&MONTH(A2))

TOP

§Ú¸Õ¥i¥H¤F,ÁÂÁÂ,¥t½Ð°Ýtextªº«e­±¥[--¬OÅܦ¨¤é´Áªº·N«ä¶Ü?
¨º¦pªG¤£¥[--´N¬O¤å¦rªº·N«ä¶Ü

TOP

¦^´_ 4# VANESSA

=TEXT(IF(--A2<DATE(2012,4,1),DATE(2012,3,1),A2),"yyyy-mm")
--´N¬O±j¨îÂন¼Æ­È¡A
TEXT±o¨ìªº¬O¦r¦ê
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤F¸Ñ¤F,ÁÂÁ¶Wª©

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD