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

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

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

¦U¦ì¥ý¶i~·s¦~§Ö¼Ö~!!

½Ð±Ð¤@¤U
A1Ä欰¤å¦r«¬ºA(§å¸¹)¡A¨Ò¦p201812001
A2Ä欰¤é´Á«¬ºA(¥Í²£¤é´Á)¡A¨Ò¦p2019/2/11
·íA2Äæ¿é¤J¤é´Á«á¡A¨t²Î¯à¸õ¥Xĵ¥Ü»y¡u§å¸¹¦~¤ë¤w¶W¥X¦X®æ½d³ò¡A½Ð½T»{¬O§_¿é¿ù¡v
§PÂ_¦¡¬°
¨Ò1¡B·í¥Í²£¤é´Á2019/1¤ë¡A«h¥u±µ¨ü(§å¸¹)201812¤Î201901¶}ÀYªº¸ê®Æ
¨Ò2¡B·í¥Í²£¤é´Á2019/2¤ë¡A«h¥u±µ¨ü(§å¸¹)201901¤Î201902¶}ÀYªº¸ê®Æ
¨Ò3¡B·í¥Í²£¤é´Á2019/3¤ë¡A«h¥u±µ¨ü(§å¸¹)201902¤Î201903¶}ÀYªº¸ê®Æ

¤£ª¾¬O§_´y­z²M·¡¡AÁٽХý¶i­Ìµ¹¤©«ü±Ð~ÁÂÁ±z~

¥Î ¸ê®ÆÅçÃÒ - ³]©w - ¦Û­q ¤½¦¡¦p¤U
=OR(LEFT(A1,6)=TEXT(EDATE(B1,-1),"yyyymm"),LEFT(A1,6)=TEXT(EDATE(B1,0),"yyyymm"))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ª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

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¯uªº¬O¤Ó·P®¦¦U¦ì¥ý¶i¤F~
³q³q¸Õ¹L¤F¡A³£¦³®ÄªG¡A¦n¼F®`
ÁÂÁ±z­Ì

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD