- ©«¤l
- 65
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 120
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-15
- ³Ì«áµn¿ý
- 2010-7-16
|
¥»©«³Ì«á¥Ñ victorl ©ó 2010-6-6 02:38 ½s¿è
¸É¥R»¡©ú john2006168 ¤j¤jªº°ÝÃD
¦]¬°ìÀx¦s®æ¬°¤é´Á®æ¦¡¡F¦]¬°¦bExcel¤¤¤é´Á¬O¥H1900/1/1·í¦¨²Ä1¤é¥hp¼Æ¡A©Ò¥H2010/6/5=40334¡A ·í¨ú¥Î¤é´Á®æ¦¡¬O·|ÁÙ즨¼ÆÈ¡A©Ò¥H RIGHT(Àx¦s®æ,1) ·íÀx¦s®æ¬°2010/6/5 ®ÉÅã¥Üªº¬O"4"¡A john2006168 ¤j¤j¯»¥Î¤ß¦³¸Õ¹L©Ò¥H¥Î[SUM(1+RIGHT(Àx¦s®æ,1))] ¥[1³B²z¡A¦ý¶È¾A¥Î©ó¬Y¨Ç¤é´Á¡A¦]¬°¸Ó§@ªkÅã¥Üªº¥u¦³1¤é~10¤é(¦]¬°¤@¼ÆÈ"Ó¦ì¼Æ"ªºªí²{¥u¦³0~9¡A+1«á´N§e²{1~10°Õ) |
|