ÈçºÎÔÚexcelµÄ±í¸ñÖÐÉí·ÝºÅÂë»»³É³öÉúÈÕÆÚ

ʱ¼ä£º2012.12.26 ·¢²¼ÈË£º**f462

ÈçºÎÔÚexcelµÄ±í¸ñÖÐÉí·ÝºÅÂë»»³É³öÉúÈÕÆÚ

Òѽâ¾öÎÊÌâ

¹È¸è**f462Óû§ÔÚ2012.12.26Ìá½»Á˹ØÓÚ¡°»Æ×ÓèºË**ªÈçºÎÔÚexcelµÄ±í¸ñÖÐÉí·ÝºÅÂë»»³É³öÉúÈÕÆÚ¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2025-01-19T14:35:08¡£Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºÆÚ´ýÄúµÄ´ð°¸£¬Ï£ÍûÄãÄܸÐÊܵ½,ÎÒ×îÕæ³ÏµÄлÒâ £¡

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

µÚ1¸ö»Ø´ð

Óû§Ãû£º³Â¸Õ2231359  

ÉèA1Îı¾¸ñʽµÄ18λÉí·ÝºÅ·â²Ù̸Îıí,B1ÊäÈëÈçϹ«Ê½,¼´¿ÉËã³öµ±ÌìµÄÄêÁä.
=YEAR(TODAY()-DATE(MID(A1,7,4),MID(A1,11,2),MID(A1,13,2)))-1900&"Ëê"&MONTh**(T´ò¶îÇéODAY()-DATE(MID(A1,7,4),MID(A1,11,2),MI·ÑÕßÁÒÎÀÑïÎÅD(A1,13,2)ÎÊ´ð))-1&"ÔÂ"&DAY(TODAY()-DATE(MID(A1,7,4´©),MID(A1,11,2),MID(A1,13,2)))&"¸ÉÆÚÌì"

ÈçÒªËãÖ¸¶¨ÈÕÆÚµÄÄêÁä,¿**¢»ØÃ´Éñ¼º»³½²²ÅºìÔòÉèA1Îı¾¸ñʽµÄ18λÉí·ÝºÅ,B1Ϊָ¶¨ÈÕÆÚ,ÔÚC1ÊäÈ빫ʽÈçÏÂ:
=YEAR(B1-DATE(MID(A1,7,4),M³ªÌ«Äê±¾ID(A1,11,2),MID(A1,13,2))µÚ¶¼×ʰïΰ´ó°×)-1900&"µÆ»ªÂÒËê"&MONTh**(B1-DATE(MID(A1,7,4),MID(A1,11,2),MID(A1,13,2)))-1&"ÔÂ"&DAY(B1-DATE(M¾íЧ·¨°ìID(A1,7,4),MID(A1,11,2),MID(A1,13,2)))&"Ìì"