- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
B11=IF(AND(A11<>"",COLUMN()>2),IF(MONTH(DATE(LEFT($A11,3)+1911,MID($A11,5,2),A11+1))=--MID($A11,5,2),A11+1,""),IF(AND($AJ11=B$7,COLUMN()<30),1,""))
A11¤£n¥Î¤å¦r¼Ò¦¡§ï¥Î¤é´Á¼Ò¦¡
A11=2011/1/1
Àx¦s®æ®æ¦¡=>¦Û©w=> E/M
B12=IF(AND(A12<>"",COLUMN()>2),IF(MONTH(A12+1)=MONTH(A12),A12+1,""),IF(AND($AJ12=B$7,COLUMN()<30),1,"")) |
|