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

[µo°Ý] ¤S¬O¤u´Á°ÝÃD(¤w¸Ñ¨M)

[µo°Ý] ¤S¬O¤u´Á°ÝÃD(¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ jimmuLu ©ó 2011-5-5 18:44 ½s¿è

·Ð½Ð¦U¦ì¤j¤jÀ°¦£¡G

§Ú¤w±N¦~¤ë¤é§@¦¨¤u´Áªí¡A¦ý¬O¦b­pºâ·í¤ë¤é¼Æ®É¥X²{°ÝÃD

½ÐÀ°À°§Ú¡AÁÂÁÂ

¤u´ÁªíQ.zip (9.77 KB)

=DAY(DATE(A3,B3+1,0))

TOP

¦^´_ 1# jimmuLu


=COUNTIF(C3:AG3,"¤»")+COUNTIF(C3:AG3,"¤é")+COUNTIF(C3:AG3,"¡´")
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

TOP

´ê­Ó¼ö¾x
=31-COUNTBLANK(C3:AG3)

TOP

oobird ¥S ªº¨ç¼Æ---¦h¾Ç¤F¤@©Û
chiahuo ¥S ªº§@ªk-----²³æ©öÀ´
ANGELA ¥S ªºCOUNTBLANK¤ñ¸û±µªñ¤§«e§Ú©Ò·Qªº

¤£¹L¡A³£ÁÂÁ¦U¦ìªº¸Ñµª¡A¦A¦¸·PÁÂ

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD