½Ð°Ý¦p¦ópºâ:ú¶O¨ì´Á¤é¡B¤U¦¸¦¬¶O°_©l¤é¡Bpºâ¨âÓ¤é´Á¶¡¤ë¼Æ
- ©«¤l
- 334
- ¥DÃD
- 139
- ºëµØ
- 0
- ¿n¤À
- 621
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWSXP
- ³nÅ骩¥»
- OFFICE2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥x¥_¿¤
- µù¥U®É¶¡
- 2010-8-5
- ³Ì«áµn¿ý
- 2022-11-3
|
½Ð°Ý¦p¦ópºâ:ú¶O¨ì´Á¤é¡B¤U¦¸¦¬¶O°_©l¤é¡Bpºâ¨âÓ¤é´Á¶¡¤ë¼Æ
½Ð°Ý¦p¦ópºâ:
ú¶O¨ì´Á¤éC2Àx¦s®æ
¤U¦¸¦¬¶O°_©l¤éD2Àx¦s®æ
pºâ¨âÓ¤é´Á¶¡¤ë¼ÆB7Àx¦s®æ |
-
-
Book8.zip
(6.66 KB)
|
joyce
|
|
|
|
|
- ©«¤l
- 7
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-12-28
- ³Ì«áµn¿ý
- 2017-6-13
![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif)
|
EXCEL¤dÅܸU¤Æ¦A¥[¤WVBA¦³±o¾ÇÅo |
|
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 197
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-9-7
![2023¦~¥þ¶Ô¼ú³¹ 2023¦~¥þ¶Ô¼ú³¹](images/common/2023.png) ![2022ªê¦~¥þ¶Ô¼ú³¹ 2022ªê¦~¥þ¶Ô¼ú³¹](images/common/hu.gif) ![2021¤û¦~¥þ¶Ô¼ú³¹ 2021¤û¦~¥þ¶Ô¼ú³¹](images/common/niu.gif) ![2020¹«¦~¥þ¶Ô¼ú³¹ 2020¹«¦~¥þ¶Ô¼ú³¹](images/common/shu.gif) ![2019 ½Þ¦~¥þ¶Ô¼ú³¹ 2019 ½Þ¦~¥þ¶Ô¼ú³¹](images/common/zhu.gif) ![2018 ª¯¦~¥þ¶Ô¼ú³¹ 2018 ª¯¦~¥þ¶Ô¼ú³¹](images/common/gou.gif) ![2017 Âû¦~¥þ¶Ô¼ú³¹ 2017 Âû¦~¥þ¶Ô¼ú³¹](images/common/ji.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2013³D¦~¥þ¶Ô¼ú³¹ 2013³D¦~¥þ¶Ô¼ú³¹](images/common/she.gif) ![2012Às¦~¥þ¶Ô¼ú³¹ 2012Às¦~¥þ¶Ô¼ú³¹](images/common/long.gif) ![½×¾Â°^Äm¾±³¹ ½×¾Â°^Äm¾±³¹](images/common/medal5.gif) ![¼ö¤ß¤½¯q¾±³¹ ¼ö¤ß¤½¯q¾±³¹](images/common/medal15.gif) ![2011¨ß¦~¥þ¶Ô¼ú³¹ 2011¨ß¦~¥þ¶Ô¼ú³¹](images/common/tu.gif)
|
¦^´_ 4# leiru
§Aªº¤½¦¡¥u®t¤@¤Ñ¡A¨º´N¬Ý§Apºâ¬O§_¦³¥]§t°_°W¤é´Á
C7="®t¶Z¡G"&DATEDIF(A7,B7+1,"Y")&"¦~"&DATEDIF(A7,B7+1,"YM")&"¤ë"&DATEDIF(A7,B7+1,"YD")&"¤é"
C10="®t¶Z¡G"&DATEDIF(--TEXT(19110000+A10,"0000-00-00"),--TEXT(19110000+B10,"0000-00-00")+1,"Y")&"¦~"&DATEDIF(--TEXT(19110000+A10,"0000-00-00"),--TEXT(19110000+B10,"0000-00-00")+1,"YM")&"¤ë"&DATEDIF(--TEXT(19110000+A10,"0000-00-00"),--TEXT(19110000+B10,"0000-00-00")+1,"YD")&"¤é"
Book8.zip (7.45 KB)
|
|
¾Ç®üµL²P_¤£®¢¤U°Ý
|
|
|
|
|
- ©«¤l
- 334
- ¥DÃD
- 139
- ºëµØ
- 0
- ¿n¤À
- 621
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWSXP
- ³nÅ骩¥»
- OFFICE2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥x¥_¿¤
- µù¥U®É¶¡
- 2010-8-5
- ³Ì«áµn¿ý
- 2022-11-3
|
¦^´_ 3# Hsieh
½Ð°ÝC7¤ÎC10Àx¦s®æªº¤½¦¡¸Ó¦p¦ó³]©w©O
ÁÂÁÂ |
-
-
Book8.zip
(7.13 KB)
|
joyce
|
|
|
|
|
- ©«¤l
- 116
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 190
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2002
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2010-11-17
- ³Ì«áµn¿ý
- 2024-8-20
|
¦^´_ 1# leiru
§Aªº°ÝÃDÀ³¬Oc2¥X²{»~¿ù,edateªº»¡©ú:¶Ç¦^¬YÓ start_date (¶}©l¤é´Á) ¤§«e´XÓ¤ë©Î«á´XӤ몺¬Y¤@¤Ñªº¤é´Á®É¶¡§Ç¦CÈ¡CEDATE ¥i¥Î¨Ópºâ¨ì´Á¤é´Á¡C½ÐÀˬdÀɮפ¤ªºA2¨Ã¤£¬O¤é´Á®æ¦¡ |
|
|
|
|
|
|