- ©«¤l
- 17
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 55
- ÂI¦W
- 0
- §@·~¨t²Î
- [²¤]
- ³nÅ骩¥»
- [²¤]
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-3-22
- ³Ì«áµn¿ý
- 2022-8-17
|
¤p§Ì«á±·Q¨ì¤@Ó¿ìªk¡A©³¤U¦A¥[¤@¦æ
=WEEKDAY(DATE($AM$1,$AN$1,COLUMN(A:A)),1)=2
ªº¼Æ¦r¡A´N·|¦³ 1.2.3....ªº¡A
µM«á¦pªG¬O1ªº¦A¥h§ó§ï¨º®æªºÀx¦s®æ¡A
¥ÎRange¥h¥]Cellsªº¡A¥hºâi¡A
Range(Cells(3,i),Cells(33,i))ªº¥hºâ¡A
¤j·§¬O³o¼Ë¡A¤W±ªº¥i¯à¬O¿ù»~ªºcells®æ¼Æ¡A
¥u¬O§â¥t¥~¤@Ó¬ã¨sªº¤èªk¼g¥X¨Ó¦Ó¤w¡A
·Ó¤W±ªº°µªk¦³¦¨¥\ò^^...
ÁÂÁª©¥D«ü±Ð¡I |
|