- ©«¤l
- 7
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 60
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2016-6-2
- ³Ì«áµn¿ý
- 2022-5-1
|
¦^´_ 2# hcm19522
hcm19522 ·PÁ§Aªº¦^ÂÐ...
¤£¦n·N«ä,§Ú»¡ªº¤£°÷²M·¡...
¦pªGªÑ¥«¤é´Á¦b1¸¹¨ì5¸¹¤§¶¡ªº¸Ü,³o5¤Ñ³£·|²Å¦X§Úªº±ø¥ó(2/1, 2/2, 2/3, 2/4, 2/5)
,¦ý§Ú¥un²Ä¤@Ó1¸¹Åã¥Ü´N¦n.
°ÝÃD¨Ó¤F,¦pªG3/1¨S¶}½L. ¥u¦³3/2, 3/3, 3/4, 3/5 ²Å¦X±ø¥óªÑ¥«¤é´Á¦b1¸¹¨ì5¸¹¤§¶¡.
¨º²Ä¤@ӲŦX±ø¥óªº«h·|¬O3/2.
=IF((DAY(A2)=1)*(DAY(A6)=5),"²Å¦X","") => ¥u¯àÅã¥Ü1¸¹
http://blog.xuite.net/hcm19522/twblog/563708697 => excel2003³£Åã¥ÜªÅ¥Õ >.<
ÁÙ½Ðhcm19522 À°¦£«üÂI
·PÁ¤j®a¶i¨Ó. |
|