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

¤é´Á®æ¦¡2016/1/15 10:01:31 AM¡A¼Ï¯Ã¤ÀªR¿z¿ï¥u­n¦~¤ë¡A¤]´N¬O¥u­n2016/01

¤é´Á®æ¦¡2016/1/15 10:01:31 AM¡A¼Ï¯Ã¤ÀªR¿z¿ï¥u­n¦~¤ë¡A¤]´N¬O¥u­n2016/01

P1_¼Ï¯Ã¤ÀªR¤u§@ªí¬O­n§ì¨úP1_1050101Data¤u§@ªí¸ê®Æ
¦bP1_¼Ï¯Ã¤ÀªR¤u§@ªíB1Àx¦s®æªº¦p¦ó³]©w¦¨¥u¦³"¦~¤ë"(¨Ò¦p¡G2016/01)

¸ê®Æ¨Ó·½ªº¤é´Á®æ¦¡2016/1/15  10:01:31 AM¡A¦ý¬O¼Ï¯Ã¤ÀªR¿z¿ï¥u­n¦~¤ë¡A¤]´N¬O¥u­n2016/01

½Ð°Ý¦p¦ó³]©w

10501³]³Æ²Î­p.zip (7.73 KB)

joyce

¦^´_ 1# leiru
¥[¤J¤é´ÁÄæ¦ì
10501³]³Æ²Î­p.zip (8.47 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

ÁÂÁ¦^ÂÐ,§Ú¥u­nP1_1050101Data¤u§@ªí¿z¿ï¦~¤ë,§ÚFÄæ¥[¤é´Á,
²{¦b·Q°Ý¡G
¦bP1_¼Ï¯Ã¤ÀªR¤u§@ªíB1Àx¦s®æ¼Ï¯ÃP1_1050101Data¤u§@ªíFÄæ¡A¥i¬O§Ú¤£­n¦³ªÅ¥Õ¤]§Æ±æ¥i¥H·Ó¶¶§Ç±Æ¡A¤]´N¬O2016/01¡A2016/02¡D¡D¡D¡D

½Æ¥» 10501³]³Æ²Î­p.zip (10.1 KB)

joyce

TOP

¦^´_ 3# leiru


    ¬JµM¥H¤é´Á¿z¿ï´N¨S¦³¤é´Á±Æ§Ç°ÝÃD
©Î³\¬O­n¦h­«¿ï¾Ü¤é´Á¡A¨º´N¦b¼ÐÅÒ¦C¨Ã±Æ
10501³]³Æ²Î­p.zip (10 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

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

À³¸Ó¬O­n³o­Ó§a!!


10501³]³Æ²Î­pv1.rar (10.21 KB)

TOP

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


    ¤£¬O³o­Ó,§Ú«üªº¬O¦bb2Àx¦s®æ,¤U©Ô¦¡¿ï³æ,·Ó¶¶§Ç±Æ¦C2016 / 01¡A2016 / 02...

¤£¬O³o¤½¦¡=IF(B2="",F1,TEXT(B2,"yyyy / mm"))
joyce

TOP

¦^´_ 7# leiru


°w¹ï¢Ð¢±¡A¥kÁä¡A¡eÄæ¦ì³]©w¡D¶i¶¥¡f³]¡e±Æ§Ç¡f¬°»¼¼W¡I¡I¡I
10501³]³Æ²Î­pv2.rar (10.23 KB)

TOP

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


   ¤j®v ±z¦n¡G
¨Ì±z»¡©ú¡A§Ú§ä¤£¨ìÄæ¦ì³]©w¤Uªº¶i¶¥¿ï¶µ¡A§Ú¬Ý¨ìªºµe­±¦pªþÀÉ(excel2010)¡A
·PÁ±z­@¤ß«ü¾É¡C

10501³]³Æ²Î­pv2.zip (278.96 KB)

joyce

TOP

¦^´_ 9# leiru

½Ð 2010 ª©ªº¤j¤j¬Ý¬Ý§a!

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD