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

¦p¦óÂର¤é´Á®æ¦¡

¦p¦óÂର¤é´Á®æ¦¡

§Ú¦bexcel ¥´: 09/07/2001 , ·Q¥Î¤½¦¡year(), §â¦~¥÷©â¥X¨Ó, ¦ý¥Î¤£¨ì...¬O¤£¬O§Ú¨S¦³§â09/07/2001Âର¤é´Á®æ¦¡ !!!! ¦p¦óÂà©O ?????thx!!

­Y¨S¦³¯A¤Î­pºâ¥H¦Û©w®æ¦¡À³¸Ó´N¥i¥H¤F..
Jack

TOP

¥Î¦Û­q®æ¦¡¦æ¶Ü¡H
[®æ¦¡] - [Àx¦s®æ] - [¦Û­q]¡A©ó[Ãþ«¬]¤§ªÅ®æ¡A¿é¤Jyyyy§Y¥i¡C

­Y¤£²Å¦X»Õ¤U¤§­n¨D¡A½Ð¤Å¨£¯º¡I

TOP

¦pªG¬O¥´2010/09/07¡A¥Îyear¨ç¼Æ´N¥i¥H¤F

TOP

¦^´_ 1# yan870510
mistery¥Sªº¬O­Ó¦n¤èªk, ¥t¸É¨â­Ó¤èªk°Ñ¦Ò

Âà¤é´Á®æ¦¡
=VALUE(A1)
¦A¥[©â¦~¥÷
=YEAR(VALUE(A1))
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 1# yan870510


   ¦pªG¥u¬O³æ¯Â­n¨ú¦è¤¸¦~, ¥i¥H¸Õ¸Õ¥Îright¨ç¼ÆÅo
    1.gif

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD