µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» ·Q½Ð°ÝEXCEL¬O§_¦³¨ç¼Æ¯àºâ¥X¤ë©P¼Æ?
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
·Q½Ð°ÝEXCEL¬O§_¦³¨ç¼Æ¯àºâ¥X¤ë©P¼Æ?
joyce_shan
µoµu®ø®§
¥[¬°¦n¤Í
joyce_shan
·í«eÂ÷½u
UID
16824
©«¤l
5
¥DÃD
1
ºëµØ
0
¿n¤À
17
ª÷¿ú
17
ÂI¦W
0
§@·~¨t²Î
win xp
³nÅ骩¥»
Office 2003
¾\ŪÅv
10
©Ê§O
¤k
¨Ó¦Û
TAIWAN
¦b½u®É¶¡
4 ¤p®É
µù¥U®É¶¡
2014-3-6
³Ì«áµn¿ý
2014-4-5
¤p¾Ç¥Í
©«¤l
5
¥DÃD
1
ºëµØ
0
¿n¤À
17
ÂI¦W
0
§@·~¨t²Î
win xp
³nÅ骩¥»
Office 2003
¾\ŪÅv
10
©Ê§O
¤k
¨Ó¦Û
TAIWAN
µù¥U®É¶¡
2014-3-6
³Ì«áµn¿ý
2014-4-5
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2014-3-6 21:11
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
·Q½Ð°ÝEXCEL¬O§_¦³¨ç¼Æ¯àºâ¥X¤ë©P¼Æ?
EXCEL
§Úª¾¹DEXCEL¦³³]¦~©P¼Æ,¦ý§Ú·Qnªº¬O¤ë©P¼Æ,¨Ò¦p:2014/9/6¬O9¤ëªº²Ä¤@©P,¥H¦¹Ãþ±À.
¦¬ÂÃ
¤À¨É
sunnyso
µoµu®ø®§
¥[¬°¦n¤Í
sunnyso
·í«eÂ÷½u
UID
13329
©«¤l
605
¥DÃD
92
ºëµØ
0
¿n¤À
648
ª÷¿ú
648
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
7
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
macau
¦b½u®É¶¡
409 ¤p®É
µù¥U®É¶¡
2013-4-5
³Ì«áµn¿ý
2019-2-10
°ª¤¤¥Í
©«¤l
605
¥DÃD
92
ºëµØ
0
¿n¤À
648
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
7
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
macau
µù¥U®É¶¡
2013-4-5
³Ì«áµn¿ý
2019-2-10
2
#
µoªí©ó 2014-3-6 22:33
|
¥u¬Ý¸Ó§@ªÌ
=INT((13+DAY(A1)-WEEKDAY(A1-5))/7)
ss
TOP
aer
µoµu®ø®§
¥[¬°¦n¤Í
aer
·í«eÂ÷½u
UID
5928
©«¤l
192
¥DÃD
16
ºëµØ
0
¿n¤À
238
ª÷¿ú
238
ÂI¦W
311
§@·~¨t²Î
windows xp
³nÅ骩¥»
office 2007
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
228 ¤p®É
µù¥U®É¶¡
2011-8-8
³Ì«áµn¿ý
2024-12-23
¤¤¾Ç¥Í
©«¤l
192
¥DÃD
16
ºëµØ
0
¿n¤À
238
ÂI¦W
311
§@·~¨t²Î
windows xp
³nÅ骩¥»
office 2007
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2011-8-8
³Ì«áµn¿ý
2024-12-23
3
#
µoªí©ó 2014-3-7 08:52
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
joyce_shan
=MONTH(A1)&"¤ë²Ä"&ROUNDUP((INT((WEEKDAY(DATE(YEAR(A1),MONTH(A1),1),2)-1)+DAY(A1))/7),0)&"¶g"
TOP
p212
µoµu®ø®§
¥[¬°¦n¤Í
p212
·í«eÂ÷½u
UID
6266
©«¤l
618
¥DÃD
17
ºëµØ
0
¿n¤À
663
ª÷¿ú
663
ÂI¦W
1
§@·~¨t²Î
WINDOWS 7
³nÅ骩¥»
OFFICE 2013
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
Pingtung
¦b½u®É¶¡
164 ¤p®É
µù¥U®É¶¡
2011-9-2
³Ì«áµn¿ý
2024-7-5
°ª¤¤¥Í
©«¤l
618
¥DÃD
17
ºëµØ
0
¿n¤À
663
ÂI¦W
1
§@·~¨t²Î
WINDOWS 7
³nÅ骩¥»
OFFICE 2013
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
Pingtung
µù¥U®É¶¡
2011-9-2
³Ì«áµn¿ý
2024-7-5
4
#
µoªí©ó 2014-3-7 09:32
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ p212 ©ó 2014-3-7 09:40 ½s¿è
¦^´_
1#
joyce_shan
pºâì«h¡G
«ü©w¤é´Á¤§¶g§Ç
´î¥h
«ü©w¤é´Á·í¤ë²Ä¤@¤Ñªº¶g§Ç
+1
=
WEEKNUM(A1)
-
WEEKNUM(DATE(YEAR(A1),MONTH(A1),1))
+1
WEEKNUM(serial_num,return_type)¡A¨ä¤¤return_type±Ä¹w³]È(
¤@¶g±q¬P´Á¤é¶}©l
)
½Ð°Ñ¦Ò¡I
TOP
joyce_shan
µoµu®ø®§
¥[¬°¦n¤Í
joyce_shan
·í«eÂ÷½u
UID
16824
©«¤l
5
¥DÃD
1
ºëµØ
0
¿n¤À
17
ª÷¿ú
17
ÂI¦W
0
§@·~¨t²Î
win xp
³nÅ骩¥»
Office 2003
¾\ŪÅv
10
©Ê§O
¤k
¨Ó¦Û
TAIWAN
¦b½u®É¶¡
4 ¤p®É
µù¥U®É¶¡
2014-3-6
³Ì«áµn¿ý
2014-4-5
¤p¾Ç¥Í
©«¤l
5
¥DÃD
1
ºëµØ
0
¿n¤À
17
ÂI¦W
0
§@·~¨t²Î
win xp
³nÅ骩¥»
Office 2003
¾\ŪÅv
10
©Ê§O
¤k
¨Ó¦Û
TAIWAN
µù¥U®É¶¡
2014-3-6
³Ì«áµn¿ý
2014-4-5
5
#
µoªí©ó 2014-3-7 18:21
|
¥u¬Ý¸Ó§@ªÌ
ÁÂÁ¤j¤j¡AÀ°¤F§Ú«Ü¤jªº¦£©O
TOP
ÀR«ä¦Û¦b :
§g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·