关于转正日期的计算,员工是6月20号入职,试用期3个月,请问转正日期是几号? 您好潘律师，想问应届毕业生在国企就业试用期过后没有转正的情况...
\u4e2d\u8f6f\u56fd\u9645\u8bd5\u7528\u671f\u7684\u5f85\u9047\u5982\u4f55\uff1f\u8f6c\u6b63\u4e86\u4ee5\u540e\u7684\u5f85\u9047\u5462\uff1f\u5230\u8fd9\u4e2a\u5730\u65b9\u4e86\uff0c\u4f60\u5b8c\u5168\u53ef\u4ee5\u51ed\u81ea\u5df1\u7684\u80fd\u529b\u6323\u5230\u4f60\u671f\u671b\u7684\u6570\u5b57\u3002
\u8bb0\u4f4f\uff0c\u5728\u5927\u516c\u53f8\uff0c\u5b9e\u529b\u662f\u7b2c\u4e00\u7684\u3002
\u8bd5\u7528\u671f\u6761\u6b3e\u662f\u7528\u4eba\u5355\u4f4d\u548c\u52b3\u52a8\u8005\u53cc\u5411\u9009\u62e9\u7684\u673a\u4f1a\u6761\u6b3e\u3002\u8bd5\u7528\u671f\u5185\uff0c\u53cc\u65b9\u90fd\u53ef\u4ee5\u89e3\u9664\u52b3\u52a8\u5408\u540c\u3002\u4f60\u7684\u8bd5\u7528\u671f\u5e94\u5f53\u662f\u5305\u542b\u5728\u52b3\u52a8\u5408\u540c\u671f\u9650\u8303\u56f4\u5185\u7684\uff0c\u8bd5\u7528\u671f\u5185\u6ca1\u6709\u88ab\u8f9e\u9000\u6216\u8005\u4e3b\u52a8\u8f9e\u804c\uff0c\u52b3\u52a8\u5408\u540c\u5c31\u5e94\u5f53\u7ee7\u7eed\u5c65\u884c\u3002\u6b64\u65f6\u4f60\u5e94\u8058\u4e0b\u4e00\u5bb6\u5355\u4f4d\uff0c\u90a3\u4f60\u4e0e\u56fd\u4f01\u662f\u5426\u7b7e\u8ba2\u52b3\u52a8\u5408\u540c\uff1f\u662f\u5426\u660e\u793a\u8f9e\u804c\uff1f\u5982\u679c\u6ca1\u6709\u5728\u8bd5\u7528\u671f\u5185\u8f9e\u804c\uff0c\u52b3\u52a8\u5173\u7cfb\u4ee5\u53ca\u6210\u7acb\uff0c\u672a\u4e0e\u4e0a\u4e00\u5bb6\u7528\u4eba\u5355\u4f4d\u89e3\u9664\u52b3\u52a8\u5408\u540c\uff0c\u5e94\u8058\u662f\u53ef\u4ee5\u7684\uff0c\u4f46\u662f\u4e0d\u80fd\u518d\u5efa\u7acb\u52b3\u52a8\u5408\u540c\u5173\u7cfb\uff0c\u9664\u975e\u89e3\u9664\u4e0a\u4e00\u4efd\u52b3\u52a8\u5408\u540c\uff0c\u624d\u80fd\u7b7e\u8ba2\u65b0\u7684\u52b3\u52a8\u5408\u540c\u3002\u65b0\u5355\u4f4d\u5982\u679c\u5f55\u7528\u4e86\u6ca1\u6709\u548c\u539f\u5355\u4f4d\u89e3\u9664\u52b3\u52a8\u5408\u540c\u7684\u4f60\uff0c\u53ef\u80fd\u4f1a\u9762\u4e34\u539f\u5355\u4f4d\u7684\u8bc9\u8bbc\u7d22\u8d54\u3002\u800c\u4f60\u672c\u4eba\u4e5f\u53ef\u80fd\u4f1a\u4e24\u5934\u843d\u7a7a\u3002
转正日期为：9月19日绛旓細鍋囪A1鍗曞厓鏍兼槸鍏ヨ亴鏃ユ湡锛屽湪B1鍗曞厓鏍煎啓鍏ョ殑璇曠敤鏈熸湀鏁帮紝鍒欒鍦–1鍗曞厓鏍煎緱鍑杞鐨鏃ユ湡锛岄偅涔 C1鍗曞厓鏍煎啓鍏ュ叕寮 =DATE(YEAR(A1),MONTH(A1)+C1,DAY(A1))鎴 =EDATE(A1,C1)娉細EDATE鍑芥暟鐨勫畾涔 杩斿洖浠ｈ〃鎸囧畾鏃ユ湡 (start_date) 涔嬪墠鎴栦箣鍚庣敤浜庢寚绀鏈堜唤鏁扮殑鏃ユ湡鐨搴忓垪鍙枫備娇鐢ㄥ嚱鏁 EDATE 鍙互璁＄畻涓...
绛旓細娉曞緥涓昏锛氳瘯鐢ㄦ湡涓杞鍦ㄥ悓涓涓湀鐨勫伐璧勮绠楁柟娉曪細鍒嗗埆璁＄畻璇曠敤鏈熷拰杞鍚庣殑鏃ュ伐璧勶紝鍐嶇浉鍔犮傚姵鍔ㄤ繚闅滈儴浜2008骞1鏈10鏃ュ叕甯冧簡銆鍏充簬鑱屽伐鍏ㄥ勾鏈堝钩鍧囧伐浣滄椂闂村拰宸ヨ祫鎶樼畻闂鐨勯氱煡銆嬶紝鍦ㄨ繖涓氱煡涓彁鍑轰簡鈥滃埗搴﹀伐浣滄棩鈥濆拰鈥滃埗搴﹁钖棩鈥濅袱涓蹇点傗滃埗搴﹀伐浣滄棩鈥濅富瑕佺敤浜庡姞鐝鏃堕棿鐨勮绠楋紝涓浜涙満鏋勬棤娉曞疄琛...
绛旓細7.15鍙鍏湀浠宸ヨ祫锛屽彧鑳芥嬁6.20-6.30璇曠敤鏈熷伐璧勶紝锛堝伐璧勬湁鎸夊嚭鍕ゆ棩绠楃殑锛屾湁鎸夊钩鍧囩畻鐨勶級搴旇鏄嬁400宸﹀彸銆8.15鍙戜竷鏈堜唤宸ヨ祫锛屽鏋杞鏃ユ槸7.20锛7.1-7.19鏄嬁璇曠敤鏈熷伐璧勶紝搴旇鏄800涓嶅埌锛7.20-7.31鎷胯浆姝ｅ伐璧勶紝搴旇鏄500澶氫竴鐐癸紝鎵浠ヨ锛8鏈堜唤鍙戝伐璧勫彧鑳芥嬁1300宸﹀彸 杞宸ヨ祫锛屾槸浠庢壒鍑嗚浆姝...
绛旓細鏄殑銆傚鏋滅害瀹氳瘯鐢ㄦ湡浜屼釜鏈堢殑璇锛岃绠宸ヨ祫鐨勬柟寮忥紝灏辨槸浣犺鐨勯偅鏍凤紝4鏈25鍙峰墠鐢ㄨ瘯鐢ㄦ湡宸ヨ祫鏍囧噯锛屽悗闈㈢殑鍑犲ぉ鐢ㄨ瘯鐢ㄦ湡鍚庣殑宸ヨ祫鏍囧噯鏉ヨ绠楀伐璧勶紝鍚堣捣鏉ュ氨鏄綘鍥鏈堜唤鐨勫伐璧勩
绛旓細杞鐢宠浜哄熀鏈俊鎭濇垨鑰呪滆浆姝ｇ敵璇峰唴瀹光濇爮鐩腑銆傚湪濉啓鏃ユ湡鏃讹紝鍙互浣跨敤鈥滃勾-鏈-鏃モ濈殑鏍煎紡锛屼緥濡傦細2021-08-01銆傞渶瑕佹敞鎰鐨勬槸锛鎷熷畾杞鏃ユ湡鍙槸浼佷笟瀵鍛樺伐杞鐨勫垵姝ヨ鍒掞紝鍏蜂綋杞鏃堕棿杩橀渶瑕佹牴鎹紒涓氱殑瀹為檯鎯呭喌杩涜纭銆傚鏋滄偍鏈夌枒闂紝鍙互鍜ㄨ浼佷笟浜哄姏璧勬簮閮ㄩ棬鎴栬呯洿鎺ュ悜涓婄骇涓荤杩涜纭銆
绛旓細鐢╠atedif鍑芥暟鍙互鎼炲畾锛屽叕寮忓師鐞嗭紝绗竴姝ワ細鐢╠atedif鍑芥暟纭畾鍏ヨ亴鏃ュ埌褰撲笅濡傛湡鐨勫ぉ鏁帮紝绗簩姝ワ細鐢90澶╁噺鍘诲緱鍒扮殑澶╂暟锛岀涓夋锛氱敤if鍑芥暟鍒ゆ柇宸硷紝涓鸿礋鏁板氨鏄剧ず宸茬粡杞銆傚叕寮 鍙互澶嶅埗绮樿创鍚庣洿鎺ヤ娇鐢紝鍏蜂綋鍏紡涓猴細=IF(90-DATEDIF(A2,TODAY(),"d")<0,"宸茬粡杞",90-DATEDIF(A2,TODAY(),"d"))...
绛旓細濡備笅鍥撅紝瑕佹牴鎹瓸鍒楃殑鍛樺伐鍏ヨ亴鏃ユ湡鍜孋鍒楃殑璇曠敤鏈熸湀鏁锛岃绠楀憳宸ヨ浆姝ｆ棩鏈銆侱2鍗曞厓鏍煎叕寮忎负锛=EDATE(B2,C2) EDATE鍑芥暟鐢ㄤ簬鎸囧畾鏌愪釜鏃ユ湡N鏈堜箣鍚庢垨鏄疦鏈堜箣鍓嶇殑鏃ユ湡銆傜敤娉曚负锛=EDATE(寮濮嬫棩鏈,鎸囧畾鏈堜唤)3銆佹寜鏉′欢姹傚拰 濡備笅鍥炬墍绀猴紝瑕佺粺璁′笉鍚岄棬搴楃殑閿鍞銆侳3鍗曞厓鏍煎叕寮忎负锛=SUMIF(B:B,E3,C:...
绛旓細鍏氶緞浠ュ勾涓哄崟浣嶏紝涓嶄互鏃ユ湡涓哄崟浣嶏紝浣犵殑鍏氶緞浠08骞撮澶囧厷鍛樺紑濮绠璧凤紝鍒扮幇鍦ㄦ槸2骞达紝鍏蜂綋鍏ュ厷鍙杞鏃ユ湡鍧囦笌鍏氶緞鏃犲叧銆備綘鐨勮浆姝ｆ棩鏈熷簲璇ユ槸鏀儴璁ㄨ琛ㄥ喅鐨勬棩鏈燂紝鍗6鏈27鏃ワ紝浣嗘槸瑕佹敞鎰忔槸鍚︿綘鎵鍦ㄦ敮閮ㄤ功璁颁负浣犲～鍐欏厷琛ㄤ笂鐨杞鏃堕棿涔熸槸6鏈27鏃ワ紝鍋囧涓鑷撮偅涔堝氨鏄6鏈27鏃ワ紝鍋囧涓嶄竴鑷达紝閭ｄ箞浠ュ厷琛ㄤ笂鐨勬敮閮...
绛旓細璇曠敤鏈熶粠鍏ヨ亴鎶ュ埌绗竴澶╁紑濮嬭捣绠楋紝鑷充笅鏈堝悓涓鏃ョ殑鍓嶄竴澶╂涓轰竴涓湀鐨勮瘯鐢ㄦ湡銆傛瘮濡傦細鑱屽伐鏈湀2鍙疯嚦鍏徃鎶ュ埌寮濮嬪伐浣滐紝鑷充笅鏈1鍙蜂负涓涓湀鐨勮瘯鐢ㄦ湡鏈熼棿銆傘婁腑鍗庝汉姘戝叡鍜屽浗鍔冲姩娉曘嬬浉鍏宠瀹氾細绗簩鍗佷竴鏉°鍔冲姩鍚堝悓鍙互绾﹀畾璇曠敤鏈熴傝瘯鐢ㄦ湡鏈闀夸笉寰楄秴杩囧叚涓湀銆傜浜屽崄浜屾潯銆鍔冲姩鍚堝悓褰撲簨浜哄彲浠ュ湪鍔冲姩鍚堝悓涓...
