1
銆佷粠韬唤璇佸彿鐮佷腑鎻愬彇鍑虹敓鏃ユ湡鎬у埆骞撮緞鍏紡锛?/p>
=DATE(MID(A1
锛?/p>
7,4), MID(A1
锛?/p>
11,2), MID(A1
锛?/p>
13,2))
2
銆佷粠韬唤璇佸彿鐮佷腑鎻愬彇鍑烘�у埆鍏紡锛?/p>
=IF(MOD(MID(A1,17,1),2)=1,"
鐢?/p>
","
濂?/p>
")
鈶″皢鍏夋爣瀹氫綅鍦?/p>
鈥?/p>
鍑虹敓鏃ユ湡
鈥?/p>
鍗曞厓鏍?/p>
(E2)
涓紝鐒跺悗鍦ㄥ崟鍏冩牸涓緭鍏ュ嚱鏁板叕寮?/p>
鈥?MI
D(D2,7,4)&"-"&MID(D2,11,2)&"-
"&MID(D2,13,2)鈥?/p>
鍗冲彲璁＄畻鍑?/p>
鈥?/p>
鍑虹敓鏃?/p>
鏈?/p>
鈥?/p>
銆?/p>
鍏充簬杩欎釜鍑芥暟鍏紡鐨勫叿浣撹鏄庯細
MID
鍑芥暟鐢ㄤ簬浠庢暟鎹腑闂存彁鍙栧瓧绗︼紝瀹冪殑鏍煎紡
鏄?/p>
:MID
3
銆佺‘瀹?/p>
鈥?/p>
骞撮緞
鈥?/p>
锛?/p>
鈥?/p>
鍑虹敓鏃ユ湡
鈥?/p>
纭畾鍚庯紝
骞撮緞鍒欏彲浠ュ埄鐢ㄤ竴涓畝鍗曠殑鍑芥暟鍏紡璁＄畻鍑烘潵浜嗭細
灏嗗厜鏍囧畾
浣嶅湪
鈥?/p>
骞撮緞
鈥?/p>
鍗曞厓鏍间腑锛岀劧鍚庡湪鍗曞厓鏍间腑杈撳叆鍑芥暟鍏紡
鈥?INT((TODAY()
-E2)/3
65)鈥?/p>
鍗冲彲璁＄畻鍑?/p>
鈥?/p>
骞撮緞
鈥?/p>
銆?/p>
鍏充簬杩欎釜鍑芥暟鍏紡鐨勫叿浣撹鏄?/p>
鈶ｈ绠椾互鍚庡彲鑳芥湁澶氫綅灏忔暟锛屽彲浠ョ敤銆愬噺灏戝皬鏁颁綅鏁般�戞寜閽紝灏嗗勾榫勭殑鏁板�煎彉鎴?/p>
鈥?/p>
鏁存暟
鈥?/p>
锛屼篃鍙湪鍏紡
=
(TODAY()-E2)/365
涓啀宓屽涓�涓?/p>
鈥淚NT鈥?/p>
鍑芥暟鍙栨暣鏁帮紝
鍗?/p>
鈥?nbsp;
=INT((TODAY()
-
E2)/365)鈥?/p>
锛岃繖鏍峰氨浼氳嚜鍔ㄥ皢鍚庨潰鐨勫皬鏁板幓鎺夛紝鍙繚鐣?/p>
鏁存暟閮ㄥ垎銆傛搷浣滄晥鏋滃涓嬪浘锛?/p>
