- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 244
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-10
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-6-19 09:46 ½s¿è
¦^´_ 6# 317
¥H4#Àɮ׬°¨Ò
ì¨Ó²Ä2¦C¬O¥Ñ¨Ï¥ÎªÌ¦Û¦æ¿é¤J
§ï¥Î¤½¦¡
G2=IF(MONTH(DATE($AL$1,y,COLUMN(A1)))<>--y,"",DAY(DATE($AL$1,y,COLUMN(A1))))
G3=IF(G2="","",CHOOSE(WEEKDAY(--($AL$1&"/"&SUBSTITUTE(MID(x,FIND("]",x)+1,3),"¤ë","")&"/1")+G2-1,2),"¤@","¤G","¤T","¥|","¤","¤»","¤é"))
¦V¥k½Æ»s
¦]¬°¤u§@ªí¦WºÙ¬O¤ë¥÷¡A©Ò¥H¨Ï¥Î¤½¦@©w¸q¨ú¥X¤u§@ªí¦WºÙªº¼Æ¦r³¡¤À·í§@¤ë¥÷¡A³o¼Ë§ó§ï¤u§@ªí¦WºÙ»P¦~¥÷ªº¼ÆÈ´N¯à¥¿½TÅã¥Ü¤é´Á
¤é¾ä.rar (11.49 KB)
|
|