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

[µo°Ý] ½Ð°Ý¤é´Á¥[´î¡B§PÂ_¡A¦X¨Ö¦C¦Lªº°ÝÃD

[µo°Ý] ½Ð°Ý¤é´Á¥[´î¡B§PÂ_¡A¦X¨Ö¦C¦Lªº°ÝÃD

¦U¦ì¤j¤j¦n

¤p§Ì¹J¨ì¤é´Á³B²z¤Wªº§xÃø

1.¦pªG¦bEXCEL¨Ï¥Î¦è¾ä¡A¨Ò¦p¦bA1¿é¤J2015/3/5¡A¨ºA1·|Åã¥Ü¦è¾ä¨S¿ù
    ¦Ó¥B¥i¥H¥ÎYEAR()¡BMONTH()µ¥¨ç¼Æ¶i¦æ­n¦h3­Ó¤ëªº¹Bºâ
    ¨Ò¦pB1=YEAR(A1)&MONTH(A1)+3&DAY(A1)
    ¦n³B¬O¦pªG¤ë¥÷+3«á¡AÅܦ¸¦~¡A·|¦Û°Ê¶i¦ì
   ¦ý¬O¦pªG¦X¨Ö¦C¦L¨ìWORD¥h¡A©Î¬O¶×¤J¨ìACCESS¥h¡A·|Åܦ¨42068
   ³o¼Ë´N¨S»³¤F

2.¥t¥~¦pªGA1©ñ¤J1040305¡A³o¬O³q¥Î®æ¦¡¡A¦ý¬O­n¥[´î©Î§PÂ_¡A¤ñ¦p­n±q³o¤Ñ¦h3­Ó¤ë
   §Ú´N±o¦bB2¡A©ñ¤J=MID(A1,1,3)&TEXT(MID(A1,4,2)+3,"00")&MID(A1,6,2)
  ¤]´N¬O·í¦¨¤å¦r¨Ó³B²z¡A³o¼Ë¦X¨Ö¦C¦L¨ìWORD´N¬O¥¿±`Åã¥Ü1040605
  ¥i¬O³o¤èªk´N­n¦Û¤v¥h¼gIF§PÂ_·|¤£·|¦³¹j¦~ªº°ÝÃD

¥H¤W¨â­Ó°ÝÃD¬O§_¦³¸Ñ?  ¤S¥i¥H¤è«K¨Ï¥Î¤é´Á®æ¦¡¥h°µ¹Bºâ¡A¦ý¤S¥i¥H¦X¨Ö¦C¦L©Î¶×¤JACCESS¤£·|¥X¿ùªº¤èªk?

ÁÂÁÂ
«¢Åo~¤j®a¦n§r

¥»©«³Ì«á¥Ñ JBY ©ó 2015-3-6 09:41 ½s¿è

1] ¥[3­Ó¤ëªº¤½¦¡ :

=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))

2] ¥[3­Ó¤ëªº¤½¦¡ :

=DATE(MID(A1,1,3),MID(A1,4,2)+3,MID(A1,6,2))

TOP

¦^´_ 2# JBY

¤j¤j±z¦n

¥Î±zªº¤è¦¡     =DATE(YEAR(G2),MONTH(G2)+3,DAY(G2))
¦bEXCEL¤Wªº½T¥i¥H¹Bºâ

¦ý¦X¨Ö¦C¦L¨ìWORD¥hªº®É­Ô¡A·|Åܦ¨¤é/¤ë/¦~
¤£¾å±o¦³¨S¦³¿ìªk¸Ñ¨M

ÁÂÁÂ
«¢Åo~¤j®a¦n§r

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD