Óû§Ãû£º³Â¸Õ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)))&"Ìì"