ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ³]©w®æ¦¡¤Æ±ø¥ó·å²«¡A½Ð°Ý¸Ó¦p¦ó§ïµ½¡AÁÂÁÂ

[µo°Ý] ³]©w®æ¦¡¤Æ±ø¥ó·å²«¡A½Ð°Ý¸Ó¦p¦ó§ïµ½¡AÁÂÁÂ

·s¼W Microsoft Excel ¤u§@ªí - ½Æ»s.rar (10.89 KB)

³]©w®æ¦¡¤Æ±ø¥ó·å²«

¦b2¤ë¥÷ªº®É­Ô·|¡AA33©MB33·|¥X²{ºñ¦â¡A
®æ¦¡¤Æ±ø¥ó§PÂ_¦¨©P¤»¾É­P¡A½Ð°Ý¸Ó¦p¦ó§ïµ½¡AÁÂÁÂ

¦^´_ 1# av8d

2018-02-01_144443.png
2018-2-1 14:44

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2018-2-1 12:23 ½s¿è

(WEEKDAY(DATE($C$1,$A$1,$A3),2)=7)*(A3<>"")
(WEEKDAY(DATE($C$1,$A$1,$A3),2)=6)*(A3<>"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD