A. 琛ㄦ牸韜浠借瘉鍙風畻騫撮緞鐨勫叕寮
琛ㄦ牸韜浠借瘉鍙風畻騫撮緞鐨勫叕寮忎粙緇嶅備笅錛
韜浠借瘉鍙瘋＄畻騫撮緞鐨勫叕寮忔槸=YEAR(NOW())-MID(C3,7,4)銆
絎涓姝ワ細鍦ㄧ數鑴戜笂鎵撳紑excel琛ㄦ牸錛岃緭鍏ヨ韓浠借瘉鍙風爜銆
Excel琛ㄦ牸鏄鎸嘙icrosoft Office Excel鐢靛瓙琛ㄦ牸杞浠躲
Microsoft Office鏄涓濂楃敱寰杞鍏鍙稿紑鍙戠殑鍔炲叕杞浠跺楄咃紝瀹冨彲浠ュ湪Microsoft Windows銆乄indows Phone銆丮ac緋誨垪銆乮OS鍜孉ndroid絳夌郴緇熶笂榪愯屻
涓庡叾浠栧姙鍏瀹ゅ簲鐢ㄧ▼搴忎竴鏍鳳紝瀹冨寘鎷鑱斿悎鐨勬湇鍔″櫒鍜屽熀浜庝簰鑱旂綉鐨勬湇鍔°備粠2007鐗堢殑Office琚縐頒負鈥淥ffice System鈥濊屼笉鍙鈥淥ffice Suite鈥濓紝鍙嶆槧鍑哄畠浠鍖呮嫭鏈嶅姟鍣ㄧ殑浜嬪疄銆
闅忕潃鏃墮棿鐨勬敼鍙橈紝Office搴旂敤紼嬪簭閫愭笎闆嗘垚錛屽叡浜鐗規э紝渚嬪傦細鎷煎啓鍜岃娉曟鏌ャ丱LE鏁版嵁闆嗘垚鍜孷BA鑴氭湰璇璦銆傚井杞鐩鍓嶅皢Office寤朵幾浣滀負涓涓寮鍙戝鉤鍙幫紝鍙浠ュ熺敱涓撶敤鍟嗗簵涓嬭澆絎涓夋柟杞浠舵惌閰嶄嬌鐢ㄣ
鎵╁睍璧勬枡錛
Excel琛ㄦ牸鐨勫巻鍙詫細
1982騫達紝Microsoft鎺ㄥ嚭浜嗗畠鐨勭涓嬈劇數瀛愬埗琛ㄨ蔣浠垛攢鈹Multiplan錛屽苟鍦–P/M緋葷粺涓婂ぇ鑾鋒垚鍔燂紝浣嗗湪MS-DOS緋葷粺涓婏紝Multiplan璐ョ粰浜哃otus 1-2-3錛岃繖涓浜嬩歡鏈緇堜績浣誇簡Excel鐨勮癁鐢熴
1985騫達紝絎涓嬈綞xcel璇炵敓錛屽畠鍙鐢ㄤ簬Mac緋葷粺錛1987騫11鏈堬紝絎涓嬈鵑傜敤浜嶹indows緋葷粺鐨凟xcel涔熶駭鐢熶簡錛堜笌Windows鐜澧冪洿鎺ユ崋緇戱紝鍦∕ac涓鐨勭増鏈鍙蜂負2.0錛夈
鍥犱負Lotus1-2-3榪熻繜涓嶈兘閫傜敤浜嶹indows緋葷粺錛屽埌浜1988騫達紝Excel鐨勯攢閲忚秴榪囦簡Lotus 錛屼嬌寰桵icrosoft絝欏湪浜哖C杞浠跺晢鐨勯嗗厛浣嶇疆銆傝嚦姝や互鍚嶮icrosoft閫愭笎宸╁滻浜嗗畠寮烘湁鍔涚殑絝炰簤鑰呭湴浣嶏紝騫朵粠涓鎵懼埌浜嗗彂灞曞浘褰㈣蔣浠剁殑鏂瑰悜銆
姝ゅ悗澶х害姣忎袱騫達紝Microsoft灝變細鎺ㄥ嚭鏂扮殑鐗堟湰鏉ユ墿澶ц嚜韜鐨勪紭鍔匡紝鐩鍓岴xcel鐨勬渶鏂扮増鏈涓16錛屼篃琚縐頒綔Microsoft Office Excel 2016銆
B. excel鏍規嵁韜浠借瘉鍙瘋＄畻騫撮緞
1銆佹墦寮瑕佹搷浣滅殑excel鏂囨。銆傚湪瑕佽＄畻騫撮緞鐨勫崟鍏冩牸鍐呰緭鍏YEAR(TODAY())-MID(A2錛7錛4)錛屽叾涓瑼2涓鴻韓浠借瘉鍙風殑鍗曞厓鏍箋傝緭鍏ヨ＄畻鍏寮忓悗錛屾寜鍥炶濺閿鍗沖彲璁＄畻鍑哄勾榫勩
2銆佽韓浠借瘉鍙瘋＄畻騫撮緞鐨勫叕寮忔槸=YEAR(NOW())-MID(C3錛7錛4)銆傚崕紜曞ぉ閫2WINDOWS10office2021絎涓姝ワ細鍦ㄧ數鑴戜笂鎵撳紑excel琛ㄦ牸錛岃緭鍏ヨ韓浠借瘉鍙風爜銆傜浜屾ワ細杈撳叆瀹屾垚涔嬪悗錛岄変腑騫撮緞鍒楃殑鍗曞厓鏍礆紝鐐瑰嚮涓婇潰鐨勫嚱鏁版爮銆
3銆乪xcel涓浣跨敤韜浠借瘉鍙瘋＄畻騫撮緞錛屽彲閫氳繃YEAR錛孴ODAY鑾峰緱褰撳墠騫翠喚錛屼嬌鐢∕ID鍑芥暟鑾峰緱韜浠借瘉鐨勫嚭韜騫翠喚錛屼袱鑰呯浉鍑忓嵆鍙寰楀埌騫撮緞銆
4銆乪xcel韜浠借瘉鍙鋒彁鍙栧勾榫勭殑鏂規硶濡備笅錛氭搷浣滅幆澧冿細鑱旀兂灝忔柊Air15錛學indows10緋葷粺錛寃psoffice50101鐗堟湰絳夈傚湪琛ㄦ牸欏甸潰錛岀偣鍑誨崟鍏冩牸銆傚湪鍏寮忔爮杈撳叆鍏寮忥紳YEAR(TODAY())-MID(A1錛7錛4)錛屽洖杞︺
5銆佸紑濮嬬紪杈戣繘鍏ヨ〃鏍兼枃浠跺悗鐐瑰嚮闇瑕佹樉紺哄勾榫勭殑鍗曞厓鏍礆紝榪涘叆緙栬緫妯″紡銆傝緭鍏ュ叕寮忚緭鍏ュ叕寮忥紙MID(B2錛7錛4)璁＄畻鍑虹敓騫翠喚錛屽啀鐢ㄧ幇鍦ㄧ殑騫翠喚鍑忓幓璁＄畻緇撴灉銆