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

[µo°Ý] ¤é´Á»P¤å¦r¬O§_¯à¬Û¤¬­pºâ?

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2019-2-12 10:58 ½s¿è

§Úªºª©¥»µLªk¥ÎEDATE¤Î{?,?}°}¦C, ¸Õ¸Õ³o­Ó:
ÅçÃÒ/¦Û­q
=OR(TEXT(LEFT(A1,6),"0-00-1")-DATE(YEAR(B1),MONTH(B1)-ROW($1:$2)+1,1)=0)

©Î:
=MODE(--TEXT(LEFT(A1,6),"0-00-1"),EOMONTH(B1,-2)+1,EOMONTH(B1,-1)+1)

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD