- ©«¤l
- 144
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-26
- ³Ì«áµn¿ý
- 2023-6-23
|
Ãö©óWeekday³oӨ禡
§Ú«ÜµL²á¦bA1:A31¿é¤J1~31
¦bB2ª½±µ¨Ï¥Î¤F¤½¦¡WEEKDAY(A1,2)
·íµ²ªG¥X²{«á§Ú¥X²{2Ó°ÝÃD
¤@¡B·Ó²z»¡A1ªºÈ¨Ã«D¤é´Á...¬°¦ó¥L¤´µM¥i¥H¶Ç¦^1~7ªº¼ÆÈ
¤G¡BB1ªºÈ¬°7
§Ú¬d¬Ý¤µ¦~(2010¦~)1¤ë1¤é¬°¬P´Á¤, Y¥Lª½±µ§ì¨ú¤µ¦~ªº²Ä¤@¤Ñ, À³¸Ón¶Ç¦^5¤~¹ï
Y§ì¹j¦~(2011¦~)1¤ë1¤é¬°¬P´Á¤», À³¸Ón¶Ç¦^6¤~¹ï
³Ì«áª½±µ±N¸Ó±N¸ÓÄæ®æ¦¡§ï¬°¤é´Á¤~µo²{¸ÓÄæ¦ì¬°1900/1/1
¦]¬°windowsªº¤é´ÁµLªk³]¬°1990¦~µLªkÅçÃÒ¬O§_¯uªº¬°¬P´Á¤é
©Ò¥H¤S¦bE1ª½±µ¿é¤J1900/1/1, D1=WEEKDAY(E1,2)
¬Ý°_¨Ó¥L¬O§ì¨ú³oÓ¤é´Á¨S¿ù
¥i¬OA1¦b³]©w¦¨¤é´Á®æ¦¡«e(¤]¸Õ¹L¨ä¥L¨Ã«D¤é´Áªº®æ¦¡)
¬°¦óweekday·|¦Û°Ê±N¸ÓÄæ¦ìªº¼ÆÈÂà´«¦¨¤é´Á? |
|