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

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

¥Î ¸ê®ÆÅçÃÒ - ³]©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

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD