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

[µo°Ý] ¦Û°Ê²£¥Í¯S©w¤é´Á¥\¯à

[µo°Ý] ¦Û°Ê²£¥Í¯S©w¤é´Á¥\¯à

¥»©«³Ì«á¥Ñ iceandy6150 ©ó 2021-10-30 00:43 ½s¿è

¤j®a¦n
§Ú¦³¤@­Ó°V½mªí¡A©w´Á¿ì²z°V½m¡A«ö·Ó±è¦¸¨«
¥Ø«e¦Û¤v¥Î¨ç¼Æ¥h³B²z
·Q½Ð°Ý¦p¦ó¨Ï¥Î«ö¶s¦Û°Ê²£¥Í? ÁÂÁÂ

¦]¬°±è¦¸¬O¤@¦ê¤å¦r
¦³®É­Ô¤S­nÂà´«¬°¤é´Á®æ¦¡¡AÁÙ­n¥[´î¤ë¥÷¡A¤é¤S¬O©T©w­È
¤£ª¾¹D¦³¨S¦³§ó¦n§ó§Öªº³B²z¤èªk
Åý§Ú¥u­n¶ñ¤J±è¦¸¡A«ö¤U¦Û°Ê²£¥Í«ö¶s¡A«á­±ªº®æ¤l©Ò»Ý­nªº³£¯à¦Û°Ê¥X²{
(¨Ò¦p§Ú¶ñ¤J¤»­Ó±è¦¸¡A«á­±³£·|¦Û°Ê²£¥Í)
ÁÂÁÂ


ºñ¦â¬O°ò·Ç¡A¤§«á¬O¥Î¨ç¼Æ¥h³B²z
¥Ø«eµ²°V´úÅç¤é¬O¶ZÂ÷ªì¯Å°V¶}½Ò¤é8.5­Ó¤ë«á¿ì²z
§Ú¤]·Q¼W¥[¤@­Ó¥\¯à¡AÅý§Ú¥i¥H¿ï¾Ü­n´X­Ó¤ë«á¿ì²z(³Ì§C¬O6¡A¦]¬°¤TºØ°Vµ²§ô«á¤~¯àµ²°V´úÅç)
°V½m½Òµ{ªí.rar (15.59 KB)
«¢Åo~¤j®a¦n§r

¦^´_ 1# iceandy6150

¤£¦n·N«ä¡A¬Ý¤£¤ÓÀ´±z¹ê»Ú»Ý¨D¡A½Ð¦b»¡©ú¸Ô²Ó¡AÁÂÁÂ

¦]¬°±è¦¸¬O¤@¦ê¤å¦r>>¤@¦ê¤å¦r¦b­þ¸Ì?¡A­n¦p¦ó³B²z?
¦³®É­Ô¤S­nÂà´«¬°¤é´Á®æ¦¡¡AÁÙ­n¥[´î¤ë¥÷¡A¤é¤S¬O©T©w­È>>¥i¥HÁ|¹ê»Ú½d¨Ò»¡©ú¶Ü?
¤£ª¾¹D¦³¨S¦³§ó¦n§ó§Öªº³B²z¤èªk
Åý§Ú¥u­n¶ñ¤J±è¦¸¡A«ö¤U¦Û°Ê²£¥Í«ö¶s¡A«á­±ªº®æ¤l©Ò»Ý­nªº³£¯à¦Û°Ê¥X²{
(¨Ò¦p§Ú¶ñ¤J¤»­Ó±è¦¸¡A«á­±³£·|¦Û°Ê²£¥Í)>>³W«h¬O¤°»ò?
ÁÂÁÂ

TOP

¬Ý¤£À´ÅÞ¿è, ¥ý±N¤½¦¡¾ã²z¤@¤U:
Xl0000794.rar (14.24 KB)

"µ²°V´úÅç¤é"³W«h¤£²M·¡, ¤j¬ù§ìµÛ°µ, ¦p:8­Ó¤ë, À³¬Oº¡8­Ó¤ë--¥ç§Y²Ä9­Ó¤ë

vba¥i±N²Ä1¤Î2¦æ«O¯d¤½¦¡, ¦A¨Ì©Ò»Ý±è¦¸¼Æ©¹¤U¶K¤J§Y¥i

TOP

¦^´_ 3# ­ã´£³¡ªL

©êºp¡A­«ÀY»¡¤@¦¸
³W«h¬O³o¼Ë
¨C­Ó¤ë³ø¦W¤À¬°¤W¥b¦æ¤ë(1¸¹¨ì15¸¹)  ¥H¤Î¤U¥b¤ë(16¸¹¨ì¤ë©³)
¥H²Ä¤@¦æ¬°¨Ò¡A¦b104¦~7¤ë1~15³øªº¤H
¥s°µ1040801±è (¨C±è¤H¼Æ¤£¤@©w¡A¦³¦h¦³¤Ö¡A¥»®×¨Ò¼È®É¤£ºÞ¤H¼Æ)

ªì¯Å°V½m¬°´Á¤@­Ó¤ë
1040801±èªº¤H¡A¶}©l°V½m¤é¬°104/08/01,­n³q¹Lªì¯Å°V½m¥²¶·­n´úÅç¡A´úÅç¤é¦bµ²§ô¤ë¥÷ªº22¸¹(©Ò¥H¬O104/08/22)

¤¤¯Å°V½m¬°´Á¤T­Ó¤ë
1040801±èªº¤H¡A¤¤¯Å¶}©l°V½m¤é¬O104/09/01 (¦]¬°¤K¤ë¾ã­Ó¤ë¬Oªì¯Å°V½m),¤T­Ó¤ë´N¬O¤E¡B¤Q¡B¤Q¤@
´úÅç¤é¦bµ²§ô¤ë¥÷ªº22¸¹(©Ò¥H¬O104/11/22)

°ª¯Å°V½m¬°´Á¨â­Ó¤ë
1040801±èªº¤H¡A°ª¯Å¶}©l°V½m¤é¬O104/12/01,­Ó¨â¤ë´N¬O¤Q¤G¡B©ú¦~ªº¤@¤ë
´úÅç¤é¦bµ²§ô¤ë¥÷ªº22¸¹(©Ò¥H¬O105/01/22)

³o¤TºØ°V½m³£­n³q¹L¡A³Ì¤Ö¬O¤»­Ó¤ë
¤§«á·|¦w±Æ¤@­Óµ²°V´úÅç
µ²°V´úÅç¤é¡A¤£¬O¦b01¸¹´N¬O15¸¹¡A³o¨âºØ

¦³®É­Ô¬O¤»­Ó¤ë«á°¨¤W´úÅç
¦³®É­Ô¬O¤C­Ó¤ë«á

§Ú¶Kªº®×¨Ò¬O8.5­Ó¤ë«á´úÅç
(1040801±èªº¤H¡A¶}©l°V½m¤é¬°104/08/01,µ²°V´úÅç¤é¬°105/03/15)
¦pªG§ï8­Ó¤ë«á´úÅç¡Aµ²°V´úÅç¤é¬°105/03/01

¦Ó¤U¥b¤ëªº¤H¡A¥s°µ1040816±è
¤TºØ°V½mªº¶}©l¤é³£¬O16¸¹
´úÅç¤é¦bµ²§ô¤ë¥÷ªº06¸¹
§Ú¶Kªº®×¨Ò¬O8.5­Ó¤ë«á´úÅç
(1040816±èªº¤H¡A¶}©l°V½m¤é¬°104/08/16,µ²°V´úÅç¤é¬°105/04/01)


Á`³W«h¾ã²z¤@¤U

¤@¡B§Ú¥u­n¿é¤J±è¦¸¡A±è¦¸¬O¤@­Ó¦r¦ê(¨Ò¦p1100901)¡A«á­±·|¦Û°Ê²£¥Í¨Ãºâ¦n¦UÄæ¦ì¤é´Á¡A(®æ¦¡¬°110/09/22³o¼Ë)

¤G¡B¤W¥b¤ë³ø¦Wªº¤H¡A¤TºØ°V½mªº¶}©l¤é³£¬O01¸¹¡F´úÅç¤é¦bµ²§ô¤ë¥÷ªº22¸¹
    ¤U¥b¤ë³ø¦Wªº¤H¡A¤TºØ°V½mªº¶}©l¤é³£¬O16¸¹¡F´úÅç¤é¦bµ²§ô¤ë¥÷ªº06¸¹

¤T¡Bµ²°V´úÅç¤éªº²£¥Í¡A¥i¥HÅý§Ú¦Û¥Ñ¿é¤J(¾ï¦â³¡¤À)¡A¨Ã¥B³Ì§C¬O6°_¸õ(·|¦Û°ÊÀˬd)
«¢Åo~¤j®a¦n§r

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2021-10-31 10:25 ½s¿è

¦^´_ 4# iceandy6150

¨Ì§AÁ|ªº¨Ò¤l:±è¦¸ 1040801
>> µ²´ú 8.5¤ë >> 105/03/15
©¹«e±Àºâ
>> µ²´ú 7.5¤ë >> 105/02/15
>> µ²´ú 6.5¤ë >> 105/01/15 ---°ª¯Å´úÅç 105/01/22  --- µ²´ú¦­¤_°ª´ú???
>> µ²´ú 6.0¤ë >> 105/01/01 ---°ª¯Å´úÅç 105/01/22  --- µ²´ú¦­¤_°ª´ú???
===============
±è¦¸ 1040816
>> µ²´ú 8.5¤ë >> 105/04/01
©¹«e±Àºâ
>> µ²´ú 7.5¤ë >> 105/03/01
>> µ²´ú 6.5¤ë >> 105/02/01 ---°ª¯Å´úÅç 105/02/06  --- µ²´ú¦­¤_°ª´ú???
>> µ²´ú 6.0¤ë >> 105/01/16 ---°ª¯Å´úÅç 105/02/06  --- µ²´ú¦­¤_°ª´ú???

============================

TOP

«Øij2¦C¤Î3¦C³£§ï¬° excel¤é´Á(¦è¤¸¤é´Á) ¿é¤J¡A
¦A®æ¦¡¤Æ¬°¤¤¤å¤é´Á
±è¦¸®æ¦¡¤Æ emmdd
³ø¦WºI¤î®æ¦¡¤Æ e/mm/¤ë©³
¨ä¥L¹j¦¡¤Æ e/mm/dd

A4 ¥H«áªº¤½¦¡´N¥i¥H¤j¶q´î¤Æ
A4 =EDATE(A2,1)
¥k©Ô¤U©Ô

¨ä¥L A2:I3 ¥t¦³¤½¦¡¸ÔÀÉ®×
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ­ã´£³¡ªL

¶â...§Ú·Q³o­Ó¬O­pºâ¤è¦¡ªº®t²§
³Ì§Ö¯àµ²°V´úÅçÀ³¸Ó­n¦b...°ª¯Å´úÅçµ²§ô«á¡A³Ì±µªñªº01¸¹©Î15¸¹

±è¦¸ 1040801
>> µ²´ú 8.5¤ë >> 105/03/15
©¹«e±Àºâ
>> µ²´ú 7.5¤ë >> 105/02/15
>> µ²´ú 7.0¤ë >> 105/02/01
>> µ²´ú 6.5¤ë >> 105/01/15 ---°ª¯Å´úÅç 105/01/22  --- µ²´ú¦­¤_°ª´ú???
>> µ²´ú 6.0¤ë >> 105/01/01 ---°ª¯Å´úÅç 105/01/22  --- µ²´ú¦­¤_°ª´ú???

°ª¯Å´úÅç 105/01/22---«h³Ì¦­µ²´ú¬°105/02/01

¥H¤ë¤À¨Ó¬Ý1040801±è
08~¹j¦~02¡A¬°8+6=14 (12¶i¤@¦~...¾l2)
¼Æ¾Ç­pºâ¡A8¤ë¤w¸g¦Û¤vºâ¤@­Ó¤ë¤F¡A©Ò¥H§Ú¤~·|»¡³Ì§C6

¦pªG¤âºâ,8¤ë­nºâ¡A08,09,10,11,12,01,02¡A³o¼Ë¬O¨¬¤C­Ó¤ë¡A¤]´N¬Oµ²´ú 7.0¤ë >> 105/02/01

===============
±è¦¸ 1040816 ¥ç¦P
---°ª¯Å´úÅç 105/02/06  --- «h³Ì¦­µ²´ú¬°105/02/15
08~¹j¦~02¡A¬°8+6=14 (12¶i¤@¦~...¾l2)

¹ï¤F¡A¦]¬°³o¨Ç¤é´Á¥X¨Ó¡A­n¦X¨Ö¦C¦L¨ìWORD¥h
©Ò¥H¦pªG¥Î¦Û­qe/mm//dd¡A¥i¯à·|¥X²{¿ù»~
¤é´Á¥i¯àÁÙ¬O­nºû«ù¦r¦ê "105/02/15"¡A³o¼Ë¦X¨Ö¦C¦L¤~¤£·|¥X¿ù

©Ò¥H¬O¤£¬O¥ý±q¦r¦ê-->¤é´Á¡A¥[´î«á¦AÅܦ^¦r¦ê ?
ÁÂÁÂ
«¢Åo~¤j®a¦n§r

TOP

¦^´_ 3# ­ã´£³¡ªL

ª©¥D¤j±z¦n
±z´£¨ÑªºÀÉ®×¥i¥H·Ç½T¨Ï¥Î

¦ý¬Oµ²°V´úÅç¤é¡A¬O01,15³o¨âºØ¡A±zªº¤½¦¡¥X¨Ó¬O01,16³o¨âºØ
¤£ª¾¹D«ç»ò­×§ï? ÁÂÁÂ

¥t¥~¡A§Ú¬°¤FÅýWORD¦X¨Ö¦C¦L¥i¥H¥¿±`Ū¨ú
¥²¶·§â"¤é´Á"§ï¦¨"¦r¦ê"
§Úªº¤èªk¬O¦b¤u§@ªí2¥h³]©w
¤ñ¦pB2=TEXT(¤u§@ªí1!B2,"e/mm/dd")
µM«á§â¤½¦¡±qB2©ì¦²¨ì~¥k©³¡A¦b©ì¦²¨ì~¤U©³

¦A±q¤u§@ªí2ªºA1¡ACtrl+Shift+¥k  ¡ACtrl+Shift+¤U
´N¥i¥H¾ã­Ó½Æ»s°_¨Ó¡A¨ì¤u§@ªí3ªºA1¡A¶K¤W "­È"
´N¤j¥\§i¦¨°Õ

¥u¤£¹L¡A¤£¾å±o¬°¦ó·|¥X²{©_©Çªº´£¿ô

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

TOP

¦^´_ 8# iceandy6150

­«·s°µ, ¤é´Á³£¬O¥Á°ê¦~¤ë¤é(¤å¦r«¬ºA):
Xl0000794-1.rar (14.73 KB)

1) ­Y§Aªºª©¥»µLªk¨Ï¥Î "r"&104/01/01..Âন¦è¤¸¦~, ´N¤ñ¸û³Â·Ð
2) ·sª©excel¹ï¼Æ­È©Î¤é´Á«¬ºA, ¦Ó¥H¤å¦r«¬ºA³B²z®É, ¤j³¡¥÷·|´£¥Ü¤Î¼Ð¥Ü, ¨Ã¤£§«Ãª¥¿±`¨Ï¥Î

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD