Excel中A列与B列中均是日期，一个是参加工作时间，一个是入党时间，如何进行比较。 EXCEL 2007 ，A列，B列均为日期，我想实现B列日期...
EXCEL\u4e2dA\u5217\u4e3a\u65e5\u671f\u60f3\u5728B\u5217\u5b9e\u73b0\u52a0\u516510\u4e2a\u5de5\u4f5c\u65e5\u7684\u65e5\u671f\u600e\u4e48\u5b9e\u73b0\u201cEXCEL\u4e2dA\u5217\u4e3a\u65e5\u671f\uff0c\u5728B\u5217\u5b9e\u73b0\u52a0\u516510\u4e2a\u5de5\u4f5c\u65e5\u540e\u65e5\u671f\u201d\u7684\u64cd\u4f5c\u6b65\u9aa4\u662f\uff1a
1\u3001\u4ee5Excel 2016\u4e3a\u4f8b\uff0c\u6253\u5f00Excel\u5de5\u4f5c\u8868\uff1b
2\u3001\u5de5\u4f5c\u65e5\uff0c\u987e\u540d\u601d\u4e49\uff0c\u662f\u4e0d\u5305\u542b\u53cc\u4f11\u65e5\u53ca\u8282\u5047\u65e5\u7684\u6709\u6548\u5de5\u4f5c\u5929\u6570\uff0c\u800cA\u5217\u65e5\u671f\u768410\u4e2a\u5de5\u4f5c\u65e5\u540e\u7684\u65e5\u671f\uff0c\u5c31\u9700\u8981\u5c06\u53cc\u4f11\u65e5\u53ca\u8282\u5047\u65e5\u90fd\u53e6\u5916\u8ba1\u7b97\u5728\u5185\uff0c\u4ea7\u751f\u65b0\u7684\u65e5\u671f\uff0c\u8fd9\u9700\u8981\u901a\u8fc7WORKDAY\u51fd\u6570\u6765\u5b9e\u73b0\uff1b
3\u3001\u5728B2\u5355\u5143\u683c\u8f93\u5165\u4ee5\u4e0b\u516c\u5f0f\uff0c\u7136\u540e\u5411\u4e0b\u586b\u5145\u516c\u5f0f
=WORKDAY(A2,10,E$1:E$5)
\u516c\u5f0f\u8868\u793a\uff1a\u5c06A2\u5355\u5143\u683c\uff0c\u52a0\u4e0a\u4e0d\u5305\u62ec\u8282\u5047\u65e5\u768410\u4e2a\u5de5\u4f5c\u65e5\uff0c\u4ee5\u53ca\u5217\u4e3a\u5047\u65e5\u4ee5\u53caE1:E5\u7279\u5b9a\u8282\u65e5\u7684\u5929\u6570\uff0c\u5f97\u5230\u4e00\u4e2a\u65b0\u7684\u5929\u6570\u3002
4\u3001WORKDAY(start_date, days, [holidays])\u516c\u5f0f\u7ed3\u6784\u4e2d\uff0c\u7b2c2\u53c2\u6570days\u4e3a\u6b63\uff0c\u65e5\u671f\u5411\u540e\uff0c\u7b2c2\u53c2\u6570days\u4e3a\u8d1f\uff0c\u65e5\u671f\u5411\u524d\uff0c\u800c[holidays]\u53ef\u4ee5\u662f\u5176\u4e2d\u5305\u542b\u9700\u8981\u4ece\u5de5\u4f5c\u65e5\u5386\u4e2d\u6392\u9664\u7684\u4e00\u4e2a\u6216\u591a\u4e2a\u65e5\u671f\u3002
\u9009\u4e2dB\u5217\uff0c\u70b9\u5f00\u59cb\uff0c\u6761\u4ef6\u683c\u5f0f\uff0c\u7a81\u51fa\u663e\u793a\u5355\u5143\u683c\u89c4\u5219\uff0c\u5927\u4e8e\uff0c\u9009\u4e2dA1\uff0c\u6ce8\u610f\u6539\u6210\uff1dA1\uff0c\u4e0d\u662f$A$1
假设A列是参加工作时间，B列是入党时间则在C1输入
=if(A1-B1>=0,"工作后入党","学习期间入党")
参考公式：
=IF(A2>B2,"入党时间早于参加工作时间","")
下拉。
=IF(A1<=B1,"工作前入党","工作后入党")
然后往下拉
可以直接比大小，相减
绛旓細鍋囪A鍒楁槸鍙傚姞宸ヤ綔鏃堕棿锛B鍒楁槸鍏ュ厷鏃堕棿 鍒欏湪C1杈撳叆 =if(A1-B1>=0,"宸ヤ綔鍚庡叆鍏","瀛︿範鏈熼棿鍏ュ厷")
绛旓細鍦‥xcel涓紝濡傛灉B鍒楀潎涓烘棩鏈熸牸寮忥紝骞朵笖B1鏄剧ず鐨勬槸2022/11/25锛閭ｄ箞B2涓殑鍏紡"=b1+1"浼氬皢B1涓殑鏃ユ湡鍔犱笂1锛屽洜姝2鏄剧ず鐨勫簲璇ユ槸2022/11/26銆傛湁甯姪缁欎釜璧炲惂锛
绛旓細濡傛灉A鍒楁槸鏃ユ湡锛孊鍒楁槸搴忓彿锛孉1銆丅1鏄瓧娈靛悕锛屾棩鏈熶粠A2鍗曞厓鏍煎紑濮嬭緭鍏ワ紝B2杈撳叆鍏紡涓猴細=COUNTIF($A$1:A2,A2)鐒跺悗寰涓嬪～鍏呭叕寮忋褰揂鍒楁棩鏈熺浉鍚屾椂锛孊鍒楀氨浼氳嚜鍔ㄨ鏁颁簡锛岃瘯璇曞惂銆
绛旓細鈥EXCEL涓瑼鍒椾负鏃ユ湡锛屽湪B鍒瀹炵幇鍔犲叆10涓伐浣滄棩鍚庢棩鏈熲濈殑鎿嶄綔姝ラ鏄細1銆佷互Excel 2016涓轰緥锛屾墦寮Excel宸ヤ綔琛紱2銆佸伐浣滄棩锛岄【鍚嶆濅箟锛屾槸涓嶅寘鍚弻浼戞棩鍙婅妭鍋囨棩鐨勬湁鏁堝伐浣滃ぉ鏁帮紝鑰孉鍒楁棩鏈熺殑10涓伐浣滄棩鍚庣殑鏃ユ湡锛屽氨闇瑕佸皢鍙屼紤鏃ュ強鑺傚亣鏃ラ兘鍙﹀璁＄畻鍦ㄥ唴锛屼骇鐢熸柊鐨勬棩鏈燂紝杩欓渶瑕侀氳繃WORKDAY鍑芥暟鏉ュ疄鐜帮紱3...
绛旓細H2鐨勮繖涓叕寮廠UMPRODUCT(($A$2:$A$100=F2)*($B$2:$B$100=G2)*$C$2:$C$100)涓璅2鏄搴旂殑鏃ユ湡鏁版嵁,G2鏄搴旂殑鑲＄エ鍙风爜 姣斿姹2012骞7鏈16鏃ョ殑鑲＄エ浠ｇ爜涓002081鐨勮偂绁ㄥ綋澶╂垚浜ゆ暟閲 =SUMPRODUCT(($A$2:$A$100="2012/7/16")*($B$2:$B$100="002081")*$C$2:$C$100)鎵浠ュ叕寮忕殑...
绛旓細1銆佸鏋滀綘鐨凟XCEL鏀寔TEXTJOIN鍑芥暟锛屽氨鍙互鐩存帴鐢ㄦ暟缁勫叕寮忚绠楋紝濡傚浘B鍒 B2鍏紡锛=TEXTJOIN("+",TRUE,IF(琛ㄤ竴!$A$2:$A$8=A2,琛ㄤ竴!$B$2:$B$8,""))鎸塁trl+Shift+Enter缁勫悎閿緭鍏ャ2銆佸鏋滀笉鏀寔浠ヤ笂鍑芥暟锛屽彲浠ョ紪鍐欒嚜瀹氫箟鍑芥暟瀹屾垚锛屾寜ALT+F11缁勫悎閿紝鎵撳紑VB绐楀彛锛屾墽琛"鎻掑叆"-"妯″潡"锛屽鍒...
绛旓細浣犵幇鍦ㄧ殑瀹忔槸褰撳伐浣滆〃鐨勫崟鍏冩牸鏇存敼鍚庡氨鎵ц涓嬮潰鐨勮鍙ワ紝鎶婁綘鐨勭▼搴忓ご Private Sub Worksheet_Change(ByVal Target As Range) 鏇存敼鎴 Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)璇曚竴璇曪紝杩欎釜鏄繚瀛樺墠鎵ц涓嬮潰鐨勪唬鐮 ...
绛旓細1銆侀鍏堟墦寮excel琛ㄦ牸锛屽湪A鍒楀拰B鍒椾腑鍒嗗埆杈撳叆鏃ユ湡涓庢椂闂淬2銆佺劧鍚庨変腑C鍒楋紝鐐瑰嚮榧犳爣鍙抽敭锛屽湪寮瑰嚭鐨勯夐」涓偣鍑烩滆缃崟鍏冩牸鏍煎紡鈥濄3銆佺劧鍚庡湪寮瑰嚭鐨勬牸寮忚缃璇濇涓夋嫨鈥滆嚜瀹氫箟鈥濓紝骞跺皢绫诲瀷璁剧疆涓衡渕m-dd hh:mm:ss鈥濓紝鐐瑰嚮纭畾銆4銆佺劧鍚庡湪C1鍗曞厓鏍间腑杈撳叆鍏紡锛=VALUE(A1)+B1銆5銆佺偣鍑诲洖杞﹀悗鍗冲彲...
绛旓細1銆佺數鑴戞墦寮Excel锛岄変腑涓ゅ垪鍗曞厓鏍硷紝鎸塁trl+1杩涘叆鍗曞厓鏍艰缃2銆佽繘鍏ュ崟鍏冩牸璁剧疆鍚庯紝鎶婂崟鍏冩牸璁剧疆涓烘棩鏈燂紝鐒跺悗鐐瑰嚮纭畾銆3銆佸崟鍏冩牸璁剧疆涓烘棩鏈熷悗锛岃緭鍏ュ叕寮=DATE(YEAR(B2)+1,MONTH(B2),DAY(B2))銆4銆佽緭鍏ュ叕寮忓悗锛屾寜鍥炶溅閿氨鍙互寰楀埌澧炲姞涓骞寸殑鏃ユ湡浜嗐5銆佷笅鏉ュ鍒跺叕寮忓嵆鍙
绛旓細銆2.鎵浠ュ叕寮忓彲浠ヨ繖鏍峰啓锛氭潯浠-浠绘剰瀛楃鍙嶄箟璇嶅氨鏄┖鍊间篃灏辨槸鈥溾濓紝鎴愮珛鏃跺嵆绌哄兼椂涔熸槸鏄剧ず绌哄硷紝涓嶆垚绔-涔熷氨鏄潪绌哄兼椂鏄剧ず鍐呭涓哄綋鍓嶆棩鏈燂紝琛ㄧず灏辨槸today锛堬級锛屾墍浠ュ彲浠ヤ笅闈㈣繖鏍疯〃绀猴紝娉ㄦ剰鏄剧ず鍊煎崟鍏冩牸鏍煎紡瑕佽缃垚鏃ユ湡鏍煎紡銆4.涓婁緥鐢ㄤ簡姝ｈ礋鍊硷紝瀛楁瘝鍜岀鍙峰潎鑳芥樉绀哄綋鍓嶆棩鏈燂紝鍙鍏紡鏈夋晥銆
