½Ð°Ý100¦~ªº¤Ñ¼Æ¸Ó¦p¦óºâ??
- ©«¤l
- 102
- ¥DÃD
- 28
- ºëµØ
- 0
- ¿n¤À
- 200
- ÂI¦W
- 3
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2025-1-26
|
½Ð°Ý100¦~ªº¤Ñ¼Æ¸Ó¦p¦óºâ??
½Ð°Ý¦U¦ì¤j¤j¡G
¦]¾AÓï100¦~...³\¦h¤½¦¡³£¤£¯à¥Î·|¥X²{¿ù»~°T®§.....½Ð°Ý¤j¤j
°ÝÃD¤@¡Gn¦p¦ó¦bE2Äæ¦ì³]¤½¦¡,Åý¨ä¦Û°Êºâ¥XB2Äæ,§Y¶i³f¤é¦Ü100¦~©³ªº¤Ñ¼Æ¦@
´X¤Ñ?(¸Ô¦pªþ¥ó)
°ÝÃD¤G¡Gn¦p¦ó¦bE3Äæ¦ì³]¤½¦¡,Åý¨ä¦Û°Êºâ¥XC3Äæ,§Y¥X³f¤é¦Ü·í¤ë©³ªº¤Ñ¼Æ¦@´X
¤Ñ?(¸Ô¦pªþ¥ó) |
|
|
|
|
|
|
- ©«¤l
- 77
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- winXP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-12-24
- ³Ì«áµn¿ý
- 2011-3-2
|
¥»©«³Ì«á¥Ñ asus103 ©ó 2011-1-5 08:34 ½s¿è
¦^´_ 1# jumky
¦pªþ¥ó
³oÀ³¸Ó¤£¬O³Ì¦nªº¤èªk¡A´N¥ýÀ³«æÅo |
|
ASUS
|
|
|
|
|
- ©«¤l
- 102
- ¥DÃD
- 28
- ºëµØ
- 0
- ¿n¤À
- 200
- ÂI¦W
- 3
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2025-1-26
|
¦^´_ 2# asus103
asus103¤j¤j±z¦n¡G
ÁÂÁ±zÄ@恴À°§Ú¸Ñ¨M°ÝÃD...¥i§Úªºµ¥¯Å¦ü¥GµLªk¥´¶}ªþ¥ó....
¯à§_½Ð§Aª½±µ±N¤½¦¡po¤W¨Ó...¦Ó¤£¥Îªþ¥óªº¤è¦¡©O...ÁÂÁ±z...^^ |
|
|
|
|
|
|
- ©«¤l
- 77
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- winXP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-12-24
- ³Ì«áµn¿ý
- 2011-3-2
|
¦^´_ 3# jumky
³]©w¸û¬°Ác½Æ
D2 =LEFT(B2,SEARCH(".",B2)-1)
E2 =DATEVALUE(TEXT(1911+VALUE(D2),"####")&"-12-31")-DATEVALUE(TEXT(1911+VALUE(D2),"####")&"-"&LEFT(RIGHT(B2,5),2)&"-"&RIGHT(B2,2))
D3 =LEFT(C2,SEARCH(".",C2)-1)
E3 =(TEXT(1911+VALUE(D3),"####")&"-"&LEFT(RIGHT(C2,5),2)&"-"&RIGHT(C2,2))-DATEVALUE(TEXT(1911+VALUE(D3),"####")&"-01-01")
¨Ï¥Î»¡©ú¡G
1.©¹¤U½Æ»s¤½¦¡®É¡A½Ð¿ï¨úD2¨ìE3«á¦A¦V¤U©Ô
2.¤ë¡B¤é½Ð¥H2¦ì¼Æ¿é¤J
©ß¿j¤Þ¥É
§Æ±æ¥ý¶i̤]¯à«üÂI |
|
ASUS
|
|
|
|
|
- ©«¤l
- 183
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 322
- ÂI¦W
- 0
- §@·~¨t²Î
- win 7
- ³nÅ骩¥»
- office 2013
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-6-18
- ³Ì«áµn¿ý
- 2017-9-26
|
¦]¬°¤£ª¾¼Ó¥D§Aªº¤é´Á®æ¦¡¡A·|³y¦¨¿ù»~¡A¦pªG·QÅýÀÉ®×Åã¥Üªº¬O100.2.15¡A¥i¥H¦bÀx¦s®æ¦¡¤¤³]©w[$-404]e.m.d;@
¿é¤J¤é´Á¬°"2011/2/15"
¤]³\´N¥i¥H¸Ñ¨M¥Á°ê100¦~ªº°ÝÃD
¥t¥~¤½¦¡¦p¤U
E2=DATEDIF(B2,DATE(YEAR(TODAY()),12,31),"D")
E3==DATEDIF(B2,DATE(YEAR(TODAY()),12,31),"M")
¤p§ÌÄmÁà¤F¡C |
|
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð
|
|
|
|
|
- ©«¤l
- 102
- ¥DÃD
- 28
- ºëµØ
- 0
- ¿n¤À
- 200
- ÂI¦W
- 3
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2025-1-26
|
asus103.chiahuo¤j¤j±z̦n...§A̪º¤½¦¡...§Ú¸Õ¹L¤F...¦ü¥G¤£¦æC...
¤§«e§Ú¦bE5Ä榳³]¤½¦¡
=DATE(--MID(C4,1,2)+1911,--MID(C4,4,2),--MID(C4,7,2))-DATE(--MID(C4,1,2)+1911,1,1)+1
¥i¶]¥X¨Óªº¬O-31.......¦]¬°100¦~....©Ò¥H¤½¦¡¥X²{²§±`...= = |
|
|
|
|
|
|
- ©«¤l
- 102
- ¥DÃD
- 28
- ºëµØ
- 0
- ¿n¤À
- 200
- ÂI¦W
- 3
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2025-1-26
|
Àɮצpªþ¥ó.....³Â·Ð¦U¦ì¤j¤j¤F...
Book1.rar (1.85 KB)
|
|
|
|
|
|
|
- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22

|
¥»©«³Ì«á¥Ñ gong ©ó 2011-1-5 22:46 ½s¿è
1.¤é´Á´NÀ³¸Ó¥Î¤é´Á®æ¦¡´N¥i§K°£¤@¤Á§xÃø
2.¸óÄæ¤è¦¡¤£¬O¦nªº¤è¦¡,«Øij¤À§OÂ\¦bE&FÄæ,¤è«K¤U©Ô¤½¦¡¥\¯à
G12=DATE(YEAR($B12)+1,1,)-B12+1
H12=EOMONTH($C12,0)-$C12
3.°w¹ï§Aªº²{¦³®æ¦¡³B²z½Ð°Ñ¦Ò
E2=DATE(SUBSTITUTE($B2,".","",2)+1912,1,)-DATE(SUBSTITUTE($B2,".","",2)+1911,ROUND(MOD(SUBSTITUTE($B2,".","",1)/100,100)*100,0),MOD(SUBSTITUTE($B2,".","",1),1)*100)+1
E3¦Û¤v¦pªkªw»s¬Ý¬Ý |
-
-
¥¼©R¦W.GIF
(20.75 KB)
|
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 44
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2025-2-20
               
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-1-5 22:24 ½s¿è
¦^´_ 7# jumky
GONGª©¥D»¡ªº¹ï®æ¦¡n¥¿½T
Y¥H§Aªº¤è¦¡¤½¦¡·|«Ü³Â·Ð
D2=--LEFT(B2,FIND(".",B2)-1)
D3=--LEFT(C2,FIND(".",C2)-1)
E2=DATE(D2+1912,1,1)-DATEVALUE(SUBSTITUTE(SUBSTITUTE(B2,LEFT(B2,FIND(".",B2)-1),LEFT(B2,FIND(".",B2)-1)+1911),".","/"))
E3=EOMONTH(DATEVALUE(SUBSTITUTE(SUBSTITUTE(C2,LEFT(C2,FIND(".",C2)-1),LEFT(C2,FIND(".",C2)-1)+1911),".","/")),0)-DATEVALUE(SUBSTITUTE(SUBSTITUTE(C2,LEFT(C2,FIND(".",C2)-1),LEFT(C2,FIND(".",C2)-1)+1911),".","/"))
4®æ¤@°_¦V¤U½Æ»s |
|
¾Ç®üµL²P_¤£®¢¤U°Ý
|
|
|
|
|
- ©«¤l
- 102
- ¥DÃD
- 28
- ºëµØ
- 0
- ¿n¤À
- 200
- ÂI¦W
- 3
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2025-1-26
|
¦^´_ 9# Hsieh
gong¤j¤j±z¦n¡G
¦]¬°¨ºÓ®æ¦¡¬O¤½¥qµ¹ªº¬J©w®æ¦¡..µLªk§ï...©Ò¥H......µLªk°µÅܧó....
Hsieh¤j¤j±z¦n¡G
E2Ä檺¤½¦¡¦³¦¨¥\....¥iE3Ä檺¤½¦¡·|¥X²{#NAME?....... |
|
|
|
|
|
|