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)璁＄畻鍑虹敓骞翠唤锛屽啀鐢ㄧ幇鍦ㄧ殑骞翠唤鍑忓幓璁＄畻缁撴灉銆