ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] 2010/9/5=¬P´Á¤»

[µo°Ý] 2010/9/5=¬P´Á¤»

1.
³]A1=2010/9/5
B1=weekday(A1,2)
½Ð°Ý¬°¤°»òB1·|µ¥©ó¬P´Á¤»??
¦b¨ç¼Æ¤Þ¼Æ»¡©ú Return_type
¨Ï¥Î2¥Nªí¬P´Á¤@=1¨ì¬P´Á¤é=7
¬O¤°»ò­ì¦]·|¼vÅT¨ì¬P´Áªº§PÂ_??

2.
·íB1=weekday(A1)¡A¦³¤°»ò¤è¦¡¥i¥HÅýB1¥uÅã¥Ü"¤é"??

1.
B1=weekday(A1,2)=7......7=¬P´Á¤é
weekday¨ç¼Æ±N¬P´Á¤éÅã¥Ü¬°7
·íB1=7,³]©wÀx¦s®æ®æ¦¡¬°¬P´Á,¹ê»Ú¤º®e¬O1900/1/7Åã¥Ü¬P´Á¤»
¦]¬°1=1900/1/1
2=1900/1/2....¨Ì¦¹Ãþ±À

2.
B1=A1
¦Û­qÀx¦s®æ®æ¦¡ [$-804]aaa;@
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¦^´_ 2# asimov
­ì¨Ó¦p¦¹XD...§ÚÁÙ¥H¬°§Úªº¹q¸£¼²¨¸¤F-.-"""
¨º½Ð°Ý..Àx¦s®æ®æ¦¡­n³]©w¬°¤°»ò¡A¤~¯à¥¿±`Åã¥Ü¬P´Á?

TOP

=IF(WEEKDAY(A1)=1,"¤é",TEXT(WEEKDAY(A1,2),"[DBNum1]"))
®æ¦¡¬°³q¥Î§Y¥i¡C

TOP

¦^´_ 4# oobird
·PÁÂasimov ¡Boobird¨â¦ìÄÀºÃ
¦n¥ÎªºText¨ç¼Æ~~
¤]´N¬O»¡¡A­Y­n¥¿±`ªºÅã¥Ü¬P´Á
§Ú´N¨S¿ìªk¦A§Q¥Î¥¦­ì¥»ªº¼Æ­È§@¹Bºâ¡C

TOP

¤]´N¬O»¡¡A­Y­n¥¿±`ªºÅã¥Ü¬P´Á
§Ú´N¨S¿ìªk¦A§Q¥Î¥¦­ì¥»ªº¼Æ­È§@¹Bºâ¡C

¨ä¹ê§A¥i¥H¤°»ò¨ç¼Æ³£¤£¥Î¡Ab1¿é¤J:=a1
¦A§ïb1ªº®æ¦¡¬°¬P´Á¡C

TOP

¦^´_ 6# oobird
­è¬Ý¨ìHsieh¤j¶Kªº¤½¦¡¡A¤]¬O¥Î=a1
¥¿¦b·Q«ç»òÅܦ¨¼Æ­È¤F
­ì¨Ó®æ¦¡­n³]©w¬P´ÁXD

TOP

·s¤B¹Á¸Õ¥H¤U¤½¦¡¡A¥ç±o¨ì¦¹µ²ªG¡I

=TEXT(A1,"aaaa")

­Y¦³¤£§´µ½ªº¦a¤è¡AÀµ½Ð¤£­n¨£¯º¡I¨Ã½Ðª½±µ«ü¥X¡A¦nÅý·s¤B±q¤¤¾Ç²ß¡I¡I

TOP

¦^´_ 1# solely


=RIGHT(TEXT(A1,"aaa"))

TOP

asimov ¥S
ªº
B1=A1
¦Û­qÀx¦s®æ®æ¦¡ [$-804]aaa;@
³o­Ó¥Îªk­È±o±ÀÂË

¤£¹L»Ýxp¥H¤Wµ¥¯Å¤~¯àÅã¥Ü¥\¯à
¤°»ò³£¨S¦³§ïÅܪº­ì¥Ä­ì¨ý
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD