excelÈçºÎ´ÓÉí·ÝºÅÂëÖÐÌáÈ¡³öÉúÄêÔÂÈÕ

ʱ¼ä£º2021.08.28 ·¢²¼ÈË£ºpeng**197981

excelÈçºÎ´ÓÉí·ÝºÅÂëÖÐÌáÈ¡³öÉúÄêÔÂÈÕ

Òѽâ¾öÎÊÌâ

¹È¸èpeng**197981Óû§ÔÚ2021.08.28Ìá½»Á˹ØÓÚ¡°ÑÅÊ«À¼÷ìexcelÈçºÎ´ÓÉí·ÝºÅÂëÖÐÌáÈ¡³öÉúÄêÔÂÈÕ¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2024-10-25T10:54:30¡£Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºÆÚ´ýÄúµÄ´ð°¸£¬µÎˮ֮¶÷,À´ÈÕÎÒµ±Ó¿ÈªÏ౨ £¡

Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£

µÚ1¸ö»Ø´ð

Óû§Ãû£ºjsjhlld  

ʹÓú¯Êý¹«Ê½ÌáÈ¡£¬ÔÚ¶ÎδµÀ¹ÛÆß¸ÐÁ¬¿àµ¥Ôª¸ñÄÚÊäÈëÒÔϹ«Ê½£¬²¢À´×ÔÏòÏÂÌî³ä¼´¿É¡£

=TÉÙÕûÏØ²»EXT(MID(B2,7,8),"0-00-00")+0

½âÊÍ£º

Õâ¸ö¹«Ê½ÊÇÓС°MIDº¯Êý¡±¡°TEXTº¯Êý¡±×é³É£¬ÎÒÍò´¹ÃÇÏÖÔÚÉí·ÝºÅÂëB2µ¥Ôª¿ì½­½×Ó³ÁÁµÃζ¸ñÖдÓËüµÄµÚ7λ¿ªÊ¼½ØÈ¡£¬½ØÈ¡µÄ×Ö·û³¤¶ÈÊÇ8룬µÃµ½µÄ¼ÆËã½á¹û¾ÍÊÇ¡°1331215ÎÊ´ð9831008¡±¡£È»ºóÔÚͨ¹ýTEXTº¯Êý¡°TEXT(¸±»òɳŮԺÑÇMID(B2,7,8),"0-00-00")¡±ÈÃËü±ä³É¡°1983-10-08¡±ÕâÑùµÄ¸ñʽ¡£

¾­¹ýÕâÑùµÄ¹«Ê½ºó£¬¾ÍÓÐÁËÈÕÆÚµÄ¸ñʽ¡°1983-10-08¡±£¬µ«ÊÇÕâÑùµÄ½á¹ûÉ̾Öÿά˾ÀàÏìºÜ»**»ÊÇÕæÕýµÄÈÕÆÚ¸ñʽ¡£¾­¹ý¡°MIDº¯Êý¡±¡°TEXTº¯Êý³Éí½ðÅ£ÓÚ¡±µÈº¯Êý¼ÆËãºóµÃ³öµÄÊýÖ¼ÊÇ´º»ù¹Å¿Æ¸ÃÒԸᄚ·òÕÂÎı¾¸ñʽ£¬Ò»°ãÇé¿öÏ£¬²»ÄܲÎÓëºóÐøµÄ¼ÆËã´¦Àí¡£

ͨ³£°ÑÕâÖÖÐÎʽ½Ð×ö¼ÓÁãÔËË㣬ͨ¹ýÔËË㣬½«Îı¾¸ñʽµÄÊýÖµ±ä³ÉÕæÕýµÄÈÕÆÚ¸ñʽ£¬Èç¹û½«¼ÓÁã»»³É1*£¨1³ËÒÔÉÌÃæ¹¹Ãûµã×åÍûÓÃÖÖ£©£¬Ò²¿ÉÒÔʵÏÖ½«ÎÄ·¢±¾¸ñʽÏòÊýÖµ¸ñʽµÄת»»µÄ¡£