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

¤£©úªº¨ç¼Æ

¤£©úªº¨ç¼Æ

=WEEKDAY(A1,2)
¦U¦ì¦n¡G
        ¥H¤Wªº¨ç¼Æ¬O¥Î¼Æ¦r¨ÓÅ㠥ܬP´Á¡A¤p§Ì·Q½Ð°Ý¨ç¼Æ¤¤ªº2¦rªº§@¥Î¡CÁÂÁ¡I

¥»©«³Ì«á¥Ñ mark15jill ©ó 2012-3-12 17:17 ½s¿è

Weekday ¨ç¼Æ
½Ð°Ñ¾\     ½d¨Ò     ¯S©Ê

¶Ç¦^¤@ Variant (Integer)¡A¨ä¤º®e¬°¤@¾ã¼Æ¡A¥Nªí¬Y­Ó¤é´Á¬O¬P´Á´X¡C

»yªk

Weekday(date,[firstdayofweek])

Weekday ¨ç¼Æ»yªk¦³¤U¦Cªº«ü¦W¤Þ¼Æ¡G

³æ¤¸ »¡©ú
date ¥²­n¤Þ¼Æ¡CVariant¡A¼Æ­È¹Bºâ¦¡¡A¦r¦ê¹Bºâ¦¡¡A©Î¨ä²Õ¦X¡A¥u­n¥i¥Hªí¦¡¤@¦X²z¤é´Á§Y¥i¡C¦pªG date ¬ONull¡A«h¶Ç¦^ Null¡C
Firstdayofweek ¿ï¾Ü©Ê¤Þ¼Æ¡C±`¼Æ¡Aªí¥Ü¤@¬P´Áªº²Ä¤@¤Ñ¡C¦pªG¬Ù²¤¦¹¤Þ¼Æ¡A«h¥H vbSunday(¬P´Á¤é)¬°¹w³]­È¡C



³]©w

firstdayofweek ¤Þ¼Æ¦³¥H¤Uªº³]©w­È¡G

±`¼Æ ­È »¡©ú
vbUseSystem 0 ¨Ï¥Î NLS API ³]©w¡C
VbSunday 1 ¬P´Á¤é (¹w³]­È)¡C
vbMonday 2 ¬P´Á¤@¡C
vbTuesday 3 ¬P´Á¤G¡C
vbWednesday 4 ¬P´Á¤T¡C
vbThursday 5 ¬P´Á¥|¡C
vbFriday 6 ¬P´Á¤­¡C
vbSaturday 7 ¬P´Á¤»¡C



¶Ç¦^­È

Weekday ¨ç¼Æªº¶Ç¦^­È¦p¤Uªí©Ò¥Ü¡G

±`¼Æ ­È »¡©ú
vbSunday 1 ¬P´Á¤é¡C
vbMonday 2 ¬P´Á¤@¡C
vbTuesday 3 ¬P´Á¤G¡C
vbWednesday 4 ¬P´Á¤T¡C
vbThursday 5 ¬P´Á¥|¡C
vbFriday 6 ¬P´Á¤­¡C
vbSaturday 7 ¬P´Á¤»¡C
½Ðª`·N

¦pªG Calendar Äݩʪº³]©w¬° Gregorian¡A«h¬° date ¤Þ¼Æ¶Ç¦^ªº¾ã¼Æ¥Nªí Gregorian ¤@¶g¤¤ªº¤é´Á¡C¦pªG¤é¾ä¬O Hijri¡A«h¬° date ¤Þ¼Æ¶Ç¦^ªº¾ã¼Æ¥Nªí Hijri ¤@¶g¤¤ªº¤é´Á¡C¹ï©ó Hijri ¤é´Á¡A¤Þ¼Æ number ¬°¥ô·N¼Æ­È¹Bºâ¦¡¡A¥i¥H¥Nªí±q 1/1/100 (Gregorian Aug 2, 718) ¨ì 4/3/9666 (Gregorian Dec 31, 9999) ¤§¶¡ªº¤é´Á©M (©Î) ®É¶¡¡C

TOP

¦^´_ 1# tinching

µ½¥[¹B¥ÎEXCEL´£¨Ñ¤§¨ç¼Æ»¡©ú

TOP

©ú¥Õ¤F¡AÁÂÁ¡I

TOP

¤S¦h¾Ç¤F¤@­Ó,¨ü±Ð¤F
chenray

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD