½Ð°Ý¦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
- 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-12-12
|
¦^´_ 1# leiru
§Aªº°ÝÃDÀ³¬Oc2¥X²{»~¿ù,edateªº»¡©ú:¶Ç¦^¬YÓ start_date (¶}©l¤é´Á) ¤§«e´XÓ¤ë©Î«á´XӤ몺¬Y¤@¤Ñªº¤é´Á®É¶¡§Ç¦CÈ¡CEDATE ¥i¥Î¨Ópºâ¨ì´Á¤é´Á¡C½ÐÀˬdÀɮפ¤ªºA2¨Ã¤£¬O¤é´Á®æ¦¡ |
|
|
|
|
|
|
- ©«¤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
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 278
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-12-24
|
¦^´_ 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
- 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
|
EXCEL¤dÅܸU¤Æ¦A¥[¤WVBA¦³±o¾ÇÅo |
|
|
|
|
|
|