浠庤韩浠借瘉鍙风爜涓嚜鍔ㄧ敓鎴愭�у埆鍜岀敓鏃?/p>
鐢熸垚鎬у埆锛氾紙鍏朵腑
B2
鏄韩浠借瘉鍙风爜鎵�鍦ㄥ垪锛?/p>
涓�鎬у埆鍙屽嚮鎬у埆鎵�鍦ㄥ垪鐨勭浜岃锛?/p>
鐒跺悗杈撳叆涓嬮潰鍏紡锛?/p>
鐒跺悗鎸?/p>
ENTER
閿紱
鍐嶅埄鐢ㄤ笅鎷夋柟寮忓皢
鍏紡澶嶅埗鍒拌鍒楃殑鍏朵粬琛屼腑鍗冲彲
1=CHOOSE(MOD(IF(LEN(B2)=18,MID(B2,17,1),IF(LEN(B2)=15,RIGHT(B2,1),"")),2)+1,"
濂?/p>
","
鐢?/p>
")
2=IF(MOD(IF(LEN(B2)=15,MID(B2,15,1),MID(B2,17,1)),2)=1,"
鐢?/p>
","
濂?/p>
")
3=IF(LEN(B2)=15,IF(MOD(MID(B2,15,1),2)=1,"
鐢?/p>
","
濂?/p>
"),IF(MOD(MID(B2,17,1),2)=1,"
鐢?/p>
","
濂?/p>
"))
浜屽嚭鐢熸棩鏈熸彁鍙栧嚭鐢熸棩鏈燂細锛堝叾涓?/p>
B2
鏄韩浠借瘉鍙风爜鎵�鍦ㄥ垪锛?/p>
鍙屽嚮鍑虹敓鏃ユ湡鎵�鍦ㄥ垪鐨勭浜岃锛?/p>
鐒跺悗杈撳叆涓嬮潰鍏紡锛?/p>
鐒跺悗鎸?/p>
ENTER
閿紱
鍐嶅埄鐢ㄤ笅鎷夋柟寮忓皢鍏?/p>
寮忓鍒跺埌璇ュ垪鐨勫叾浠栬涓嵆鍙?/p>
=DATE(MID(B2,7,4),MID(B2,11,2),MID(B2,13,2))
涓夎绠楀勾榫勶細锛堝叾涓?/p>
C3
鏄嚭鐢熸棩鏈熸墍鍦ㄥ垪锛?/p>
鍙屽嚮骞撮緞鎵�鍦ㄥ垪鐨勭浜岃锛?/p>
鐒跺悗杈撳叆涓嬮潰鍏紡锛?/p>
鐒跺悗鎸?/p>
ENTER
閿紱
鍐嶅埄鐢ㄤ笅鎷夋柟寮忓皢鍏紡澶?/p>
鍒跺埌璇ュ垪鐨勫叾浠栬涓嵆鍙?/p>
=YEAR(NOW())-YEAR(C3)
Excel
鑷姩浠庤韩浠借瘉涓彁鍙栫敓鏃ユ�у埆
鍑哄锛氬ぉ绌鸿蒋浠朵綔鑰咃細浣氬悕鏃ユ湡锛?/p>
2009-09-16
姣忓勾鏂板叆瀛︾殑涓�骞寸骇瀛︾敓锛?/p>
閮介渶瑕佸悜涓婄骇鏁欒偛閮ㄩ棬涓婃姤涓�浠藉寘鍚韩浠借瘉鍙枫�?/p>
鍑虹敓骞存湀绛?/p>
鍐呭鐨勭數瀛愯〃鏍硷紝
浠ュ寤虹珛鍏ㄧ渷缁熶竴鐨勭數瀛愬绫嶆。妗堛�?/p>
鏁扮櫨涓柊鐢燂紝
灏卞緱杈撳叆鏁扮櫨琛岀浉搴旀暟
鎹紝
杩欏彲涓嶆槸涓交鏉炬椿鍎裤�?/p>
鏈夋病鏈変粈涔堝姙娉曡兘鍑忚交涓�涓嬭緭鍏ュ伐浣滈噺銆?/p>
鎻愰珮涓�涓嬫晥鐜囧憿锛熷叾瀹烇紝
鎴戜滑鍙渶鍦?/p>
Excel2003
涓皢瀛︾敓鐨勮韩浠借瘉鍙峰畬鏁村湴杈撳叆鍚庯紝
瀹冨氨鍙互甯垜浠嚜鍔ㄥ～濂藉嚭鐢熸棩
鏈熷拰鎬у埆銆?/p>
鐜板湪瀛︾敓鐨勮韩浠借瘉鍙峰凡缁忓叏閮ㄩ兘鏄?/p>
18
浣嶇殑鏂颁竴浠ｈ韩浠借瘉浜嗭紝
閲岄潰鐨勬暟瀛楅兘鏄湁瑙勫緥鐨勩�?/p>
鍓?/p>
6
浣嶆暟瀛楁槸鎴风睄鎵�鍦ㄥ湴鐨勪唬鐮侊紝
7
锛?/p>
14
浣嶅氨鏄嚭鐢熸棩鏈熴�傜
17
浣嶁�?/p>
2
鈥濅唬琛ㄧ殑鏄�у埆锛屽伓
鏁颁负濂虫�э紝濂囨暟涓虹敺鎬с�傛垜浠鍋氱殑灏辨槸鎶婂叾涓殑閮ㄥ垎鏁板瓧鎯虫硶鈥滄彁鍙栧嚭鏉モ�濄�?/p>
STEp1
锛岃浆鎹㈣韩浠借瘉鍙风爜鏍煎紡
鎴戜滑鍏堝皢瀛︾敓鐨勮韩浠借瘉鍙峰畬鏁村湴杈撳叆鍒?/p>
Excel2003
琛ㄦ牸涓紝
杩欐椂榛樿涓?/p>
鈥滄暟瀛椻�?/p>
鏍煎紡
锛堝崟
鍏冩牸鍐呮樉绀虹殑鏄瀛﹁鏁版硶鐨勬牸寮忥級
锛?/p>
闇�瑕佹洿鏀逛竴涓嬫暟瀛楁牸寮忋�?/p>
閫変腑璇ュ垪涓殑鎵�鏈夎韩浠借瘉鍙?/p>
鍚庯紝鍙冲嚮榧犳爣锛岄�夋嫨鈥滆缃崟鍏冩牸鏍煎紡鈥濄�傚湪寮瑰嚭瀵硅瘽妗嗕腑鈥滄暟瀛椻�濇爣绛惧唴鐨勨�滃垎绫烩�濊涓?/p>
鈥滄枃鏈�濓紝鐒跺悗鐐瑰嚮纭畾銆?/p>
STEP2
锛屸�滄彁鍙栧嚭鈥濆嚭鐢熸棩鏈?/p>
灏嗗厜鏍囨寚閽堟斁鍒扳�滃嚭鐢熸棩鏈熲�濆垪鐨勫崟鍏冩牸鍐咃紝杩欓噷浠?/p>
C2
鍗曞厓鏍间负渚嬨�傜劧鍚庤緭鍏?
鈥?/p>
=MID(B2,7,4)&"
骞?/p>
"&MID(B2,11,2)&"
鏈?/p>
"&MID(B2,13,2)&"
鏃?/p>
"
鈥濓紙娉ㄦ剰锛氬渚х殑鍙屽紩鍙蜂笉
鐢ㄨ緭鍏ワ紝鍑芥暟寮忎腑鐨勫紩鍙峰拰閫楀彿绛夌鍙峰簲鍦ㄨ嫳鏂囩姸鎬佷笅杈撳叆锛夈�傚洖杞﹀悗锛屼綘浼氬彂鐜板湪
C2
鍗?/p>
鍏冩牸鍐呭凡缁忓嚭鐜颁簡璇ュ鐢熺殑鍑虹敓鏃ユ湡銆?/p>
鐒跺悗锛?/p>
閫変腑璇ュ崟鍏冩牸鍚庢嫋鍔ㄥ～鍏呮焺锛?/p>
鍏跺畠鍗曞厓鏍煎唴灏?/p>
浼氬嚭鐜扮浉搴旂殑鍑虹敓鏃ユ湡銆傚鍥?/p>
1
銆?/p>
鍥?/p>
1
閫氳繃涓婅堪鏂规硶锛岀郴缁熻嚜鍔ㄨ幏鍙栦簡鍑虹敓骞存湀鏃ヤ俊鎭?/p>
灏忔彁绀猴細
MID
鍑芥暟鏄?/p>
EXCEL
鎻愪緵鐨勪竴涓�滀粠瀛楃涓蹭腑鎻愬彇閮ㄥ垎瀛楃鈥濈殑鍑芥暟鍛戒护锛屽叿浣?/p>
浣跨敤鏍煎紡鍦?/p>
EXCEL
涓緭鍏?/p>
MID
鍚庝細鍑虹幇鎻愮ず銆?/p>
STEP3
锛屽垽鏂�у埆鈥滅敺濂斥�?/p>