{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["需推算延迟退休人员列表","男性延迟退休","女性延迟退休55","女性延迟退休50","社保年份最低缴费年限"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"需推算延迟退休人员列表","index":0,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,7,11,8]]}
["员工号","出生日期","性别","原法定\n退休年龄","新退休年月","当年领取养老金\n最低缴费年限",null,null,null,null,null,null,"性别选择","原法定退休年龄选择"]
[10001,"1976-10-03","男",60,"2039-10-01","20年",null,null,null,null,null,null,"男",60]
[10002,"1980-01-03","女",55,"2037-08-01","19年",null,null,null,null,null,null,"女",55]
[10003,"1980-08-30","女",50,"2033-06-01","17年",null,null,null,null,null,null,null,50]
[10004,"1975-05-08","女",55,"2031-10-01","16年"]
[10005,"1979-12-12","男",60,"2042-12-01","20年"]
[10006,"1972-05-03","男",60,"2034-04-01","17年+6个月"]
[10007,"1983-04-30","男",60,"2046-04-01","20年"]
[10008,"1970-05-02","女",55,"2025-07-01","15年"]
[10009,"1975-01-02","女",50,"2025-02-01","15年"]
[10010,"1984-12-31","女",50,"2039-12-01","20年"]
[10011,"1964-12-31","男",60,"2024-12-01","15年"]

{"sheet":"男性延迟退休","index":1,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["开始延迟退休人员\n出生年月日","1965-01-01",null,"当前\n退休年龄",60]
[]
["编号","退休周岁","退休月数","延长月份","实际退休年龄","出生日期开始","出生日期结束","出生年月开始","出生年月开始","新退休日期开始","新退休日期结束","新退休年月开始","新退休年月结束"]
[1,{"$f":"$E$1+INT(D4/12)","v":60},{"$f":"MOD(D4,12)","v":1},{"$f":"A4","v":1},{"$f":"IF(ROUND(C4,0)=0,B4 & \"岁\",B4 & \"岁\" & ROUND(C4,0)  &\"个月\")","v":"60岁1个月"},{"$f":"EDATE($B$1,(A4-1)*4)","v":"1965-01-01"},{"$f":"EDATE(F4,4)-1","v":"1965-04-30"},{"$f":"TEXT(F4,\"YYYY年M月\")","v":"1965年1月"},{"$f":"TEXT(G4,\"YYYY年M月\")","v":"1965年4月"},{"$f":"EDATE(DATE(YEAR(F4)+B4,MONTH(F4),DAY(F4)),C4)","v":"2025-02-01"},{"$f":"EDATE(DATE(YEAR(G4)+B4,MONTH(G4),DAY(G4)),C4)","v":"2025-05-30"},{"$f":"TEXT(J4,\"YYYY年M月\")","v":"2025年2月"},{"$f":"TEXT(K4,\"YYYY年M月\")","v":"2025年5月"}]
[2,60,{"$f":"MOD(D5,12)","v":2},{"$f":"A5","v":2},"60岁2个月","1965-05-01",{"$f":"EDATE(F5,4)-1","v":"1965-08-31"},{"$f":"TEXT(F5,\"YYYY年M月\")","v":"1965年5月"},{"$f":"TEXT(G5,\"YYYY年M月\")","v":"1965年8月"},{"$f":"EDATE(DATE(YEAR(F5)+B5,MONTH(F5),DAY(F5)),C5)","v":"2025-07-01"},{"$f":"EDATE(DATE(YEAR(G5)+B5,MONTH(G5),DAY(G5)),C5)","v":"2025-10-31"},{"$f":"TEXT(J5,\"YYYY年M月\")","v":"2025年7月"},{"$f":"TEXT(K5,\"YYYY年M月\")","v":"2025年10月"}]
[3,60,3,3,"60岁3个月","1965-09-01","1965-12-31",{"$f":"TEXT(F6,\"YYYY年M月\")","v":"1965年9月"},{"$f":"TEXT(G6,\"YYYY年M月\")","v":"1965年12月"},{"$f":"EDATE(DATE(YEAR(F6)+B6,MONTH(F6),DAY(F6)),C6)","v":"2025-12-01"},{"$f":"EDATE(DATE(YEAR(G6)+B6,MONTH(G6),DAY(G6)),C6)","v":"2026-03-31"},{"$f":"TEXT(J6,\"YYYY年M月\")","v":"2025年12月"},{"$f":"TEXT(K6,\"YYYY年M月\")","v":"2026年3月"}]
[4,60,4,4,"60岁4个月","1966-01-01","1966-04-30","1966年1月","1966年4月","2026-05-01","2026-08-30","2026年5月","2026年8月"]
[5,60,5,5,"60岁5个月","1966-05-01","1966-08-31","1966年5月","1966年8月","2026-10-01","2027-01-31","2026年10月","2027年1月"]
[6,60,6,6,"60岁6个月","1966-09-01","1966-12-31","1966年9月","1966年12月","2027-03-01","2027-06-30","2027年3月","2027年6月"]
[7,60,7,7,"60岁7个月","1967-01-01","1967-04-30","1967年1月","1967年4月","2027-08-01","2027-11-30","2027年8月","2027年11月"]
[8,60,8,8,"60岁8个月","1967-05-01","1967-08-31","1967年5月","1967年8月","2028-01-01","2028-04-30","2028年1月","2028年4月"]
[9,60,9,9,"60岁9个月","1967-09-01","1967-12-31","1967年9月","1967年12月","2028-06-01","2028-09-30","2028年6月","2028年9月"]
[10,60,10,10,"60岁10个月","1968-01-01","1968-04-30","1968年1月","1968年4月","2028-11-01","2029-02-28","2028年11月","2029年2月"]
[11,60,11,11,"60岁11个月","1968-05-01","1968-08-31","1968年5月","1968年8月","2029-04-01","2029-07-31","2029年4月","2029年7月"]
[12,61,0,12,"61岁","1968-09-01","1968-12-31","1968年9月","1968年12月","2029-09-01","2029-12-31","2029年9月","2029年12月"]
[13,61,1,13,"61岁1个月","1969-01-01","1969-04-30","1969年1月","1969年4月","2030-02-01","2030-05-30","2030年2月","2030年5月"]
[14,61,2,14,"61岁2个月","1969-05-01","1969-08-31","1969年5月","1969年8月","2030-07-01","2030-10-31","2030年7月","2030年10月"]
[15,61,3,15,"61岁3个月","1969-09-01","1969-12-31","1969年9月","1969年12月","2030-12-01","2031-03-31","2030年12月","2031年3月"]
[16,61,4,16,"61岁4个月","1970-01-01","1970-04-30","1970年1月","1970年4月","2031-05-01","2031-08-30","2031年5月","2031年8月"]
[17,61,5,17,"61岁5个月","1970-05-01","1970-08-31","1970年5月","1970年8月","2031-10-01","2032-01-31","2031年10月","2032年1月"]
[18,61,6,18,"61岁6个月","1970-09-01","1970-12-31","1970年9月","1970年12月","2032-03-01","2032-06-30","2032年3月","2032年6月"]
[19,61,7,19,"61岁7个月","1971-01-01","1971-04-30","1971年1月","1971年4月","2032-08-01","2032-11-30","2032年8月","2032年11月"]
[20,61,8,20,{"$f":"IF(ROUND(C23,0)=0,B23 & \"岁\",B23 & \"岁\" & ROUND(C23,0)  &\"个月\")","v":"61岁8个月"},"1971-05-01","1971-08-31","1971年5月","1971年8月","2033-01-01","2033-04-30","2033年1月","2033年4月"]
[21,61,9,21,"61岁9个月","1971-09-01","1971-12-31","1971年9月","1971年12月","2033-06-01","2033-09-30","2033年6月","2033年9月"]
[22,61,10,22,"61岁10个月","1972-01-01","1972-04-30","1972年1月","1972年4月","2033-11-01","2034-02-28","2033年11月","2034年2月"]
[23,61,11,23,"61岁11个月","1972-05-01","1972-08-31","1972年5月","1972年8月","2034-04-01","2034-07-31","2034年4月","2034年7月"]
[24,62,0,24,"62岁","1972-09-01","1972-12-31","1972年9月","1972年12月","2034-09-01","2034-12-31","2034年9月","2034年12月"]
[25,62,1,25,"62岁1个月","1973-01-01","1973-04-30","1973年1月","1973年4月","2035-02-01","2035-05-30","2035年2月","2035年5月"]
[26,62,2,26,"62岁2个月","1973-05-01","1973-08-31","1973年5月","1973年8月","2035-07-01","2035-10-31","2035年7月","2035年10月"]
[27,62,3,27,"62岁3个月","1973-09-01","1973-12-31","1973年9月","1973年12月","2035-12-01","2036-03-31","2035年12月","2036年3月"]
[28,62,4,28,"62岁4个月","1974-01-01","1974-04-30","1974年1月","1974年4月","2036-05-01","2036-08-30","2036年5月","2036年8月"]
[29,62,5,29,"62岁5个月","1974-05-01","1974-08-31","1974年5月","1974年8月","2036-10-01","2037-01-31","2036年10月","2037年1月"]
[30,62,6,30,{"$f":"IF(ROUND(C33,0)=0,B33 & \"岁\",B33 & \"岁\" & ROUND(C33,0)  &\"个月\")","v":"62岁6个月"},"1974-09-01","1974-12-31","1974年9月","1974年12月","2037-03-01","2037-06-30","2037年3月","2037年6月"]
[31,62,7,31,{"$f":"IF(ROUND(C34,0)=0,B34 & \"岁\",B34 & \"岁\" & ROUND(C34,0)  &\"个月\")","v":"62岁7个月"},"1975-01-01","1975-04-30","1975年1月","1975年4月","2037-08-01","2037-11-30","2037年8月","2037年11月"]
[32,62,8,32,{"$f":"IF(ROUND(C35,0)=0,B35 & \"岁\",B35 & \"岁\" & ROUND(C35,0)  &\"个月\")","v":"62岁8个月"},"1975-05-01","1975-08-31","1975年5月","1975年8月","2038-01-01","2038-04-30","2038年1月","2038年4月"]
[33,62,9,33,"62岁9个月","1975-09-01","1975-12-31","1975年9月","1975年12月","2038-06-01","2038-09-30","2038年6月","2038年9月"]
[34,62,10,34,"62岁10个月","1976-01-01","1976-04-30","1976年1月","1976年4月","2038-11-01","2039-02-28","2038年11月","2039年2月"]
[35,62,11,35,"62岁11个月","1976-05-01","1976-08-31","1976年5月","1976年8月","2039-04-01","2039-07-31","2039年4月","2039年7月"]
[36,63,0,36,"63岁","1976-09-01","1976-12-31","1976年9月","1976年12月","2039-09-01","2039-12-31","2039年9月","2039年12月"]

{"sheet":"女性延迟退休55","index":2,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["开始延迟退休人员\n出生年月日","1970-01-01",null,"当前\n退休年龄",55]
[]
["编号","退休周岁","退休月数","延长月份","实际退休年龄","出生日期开始","出生日期结束","出生年月开始","出生年月开始","新退休日期开始","新退休日期结束","新退休年月开始","新退休年月结束"]
[1,{"$f":"$E$1+INT(D4/12)","v":55},{"$f":"MOD(D4,12)","v":1},{"$f":"A4","v":1},{"$f":"IF(ROUND(C4,0)=0,B4 & \"岁\",B4 & \"岁\" & ROUND(C4,0)  &\"个月\")","v":"55岁1个月"},{"$f":"EDATE($B$1,(A4-1)*4)","v":"1970-01-01"},{"$f":"EDATE(F4,4)-1","v":"1970-04-30"},{"$f":"TEXT(F4,\"YYYY年M月\")","v":"1970年1月"},{"$f":"TEXT(G4,\"YYYY年M月\")","v":"1970年4月"},{"$f":"EDATE(DATE(YEAR(F4)+B4,MONTH(F4),DAY(F4)),C4)","v":"2025-02-01"},{"$f":"EDATE(DATE(YEAR(G4)+B4,MONTH(G4),DAY(G4)),C4)","v":"2025-05-30"},{"$f":"TEXT(J4,\"YYYY年M月\")","v":"2025年2月"},{"$f":"TEXT(K4,\"YYYY年M月\")","v":"2025年5月"}]
[2,55,{"$f":"MOD(D5,12)","v":2},{"$f":"A5","v":2},"55岁2个月","1970-05-01",{"$f":"EDATE(F5,4)-1","v":"1970-08-31"},{"$f":"TEXT(F5,\"YYYY年M月\")","v":"1970年5月"},{"$f":"TEXT(G5,\"YYYY年M月\")","v":"1970年8月"},{"$f":"EDATE(DATE(YEAR(F5)+B5,MONTH(F5),DAY(F5)),C5)","v":"2025-07-01"},{"$f":"EDATE(DATE(YEAR(G5)+B5,MONTH(G5),DAY(G5)),C5)","v":"2025-10-31"},{"$f":"TEXT(J5,\"YYYY年M月\")","v":"2025年7月"},{"$f":"TEXT(K5,\"YYYY年M月\")","v":"2025年10月"}]
[3,55,3,3,"55岁3个月","1970-09-01","1970-12-31",{"$f":"TEXT(F6,\"YYYY年M月\")","v":"1970年9月"},"1970年12月",{"$f":"EDATE(DATE(YEAR(F6)+B6,MONTH(F6),DAY(F6)),C6)","v":"2025-12-01"},{"$f":"EDATE(DATE(YEAR(G6)+B6,MONTH(G6),DAY(G6)),C6)","v":"2026-03-31"},{"$f":"TEXT(J6,\"YYYY年M月\")","v":"2025年12月"},"2026年3月"]
[4,55,4,4,"55岁4个月","1971-01-01","1971-04-30","1971年1月","1971年4月","2026-05-01","2026-08-30","2026年5月","2026年8月"]
[5,55,5,5,"55岁5个月","1971-05-01","1971-08-31","1971年5月","1971年8月","2026-10-01","2027-01-31","2026年10月","2027年1月"]
[6,55,6,6,"55岁6个月","1971-09-01","1971-12-31","1971年9月","1971年12月","2027-03-01","2027-06-30","2027年3月","2027年6月"]
[7,55,7,7,"55岁7个月","1972-01-01","1972-04-30","1972年1月","1972年4月","2027-08-01","2027-11-30","2027年8月","2027年11月"]
[8,55,8,8,"55岁8个月","1972-05-01","1972-08-31","1972年5月","1972年8月","2028-01-01","2028-04-30","2028年1月","2028年4月"]
[9,55,9,9,"55岁9个月","1972-09-01","1972-12-31","1972年9月","1972年12月","2028-06-01","2028-09-30","2028年6月","2028年9月"]
[10,55,10,10,"55岁10个月","1973-01-01","1973-04-30","1973年1月","1973年4月","2028-11-01","2029-02-28","2028年11月","2029年2月"]
[11,55,11,11,"55岁11个月","1973-05-01","1973-08-31","1973年5月","1973年8月","2029-04-01","2029-07-31","2029年4月","2029年7月"]
[12,56,0,12,"56岁","1973-09-01","1973-12-31","1973年9月","1973年12月","2029-09-01","2029-12-31","2029年9月","2029年12月"]
[13,56,1,13,"56岁1个月","1974-01-01","1974-04-30","1974年1月","1974年4月","2030-02-01","2030-05-30","2030年2月","2030年5月"]
[14,56,2,14,"56岁2个月","1974-05-01","1974-08-31","1974年5月","1974年8月","2030-07-01","2030-10-31","2030年7月","2030年10月"]
[15,56,3,15,"56岁3个月","1974-09-01","1974-12-31","1974年9月","1974年12月","2030-12-01","2031-03-31","2030年12月","2031年3月"]
[16,56,4,16,"56岁4个月","1975-01-01","1975-04-30","1975年1月","1975年4月","2031-05-01","2031-08-30","2031年5月","2031年8月"]
[17,56,5,17,"56岁5个月","1975-05-01","1975-08-31","1975年5月","1975年8月","2031-10-01","2032-01-31","2031年10月","2032年1月"]
[18,56,6,18,"56岁6个月","1975-09-01","1975-12-31","1975年9月","1975年12月","2032-03-01","2032-06-30","2032年3月","2032年6月"]
[19,56,7,19,"56岁7个月","1976-01-01","1976-04-30","1976年1月","1976年4月","2032-08-01","2032-11-30","2032年8月","2032年11月"]
[20,56,8,20,"56岁8个月","1976-05-01","1976-08-31","1976年5月","1976年8月","2033-01-01","2033-04-30","2033年1月","2033年4月"]
[21,56,9,21,"56岁9个月","1976-09-01","1976-12-31","1976年9月","1976年12月","2033-06-01","2033-09-30","2033年6月","2033年9月"]
[22,56,10,22,"56岁10个月","1977-01-01","1977-04-30","1977年1月","1977年4月","2033-11-01","2034-02-28","2033年11月","2034年2月"]
[23,56,11,23,"56岁11个月","1977-05-01","1977-08-31","1977年5月","1977年8月","2034-04-01","2034-07-31","2034年4月","2034年7月"]
[24,57,0,24,"57岁","1977-09-01","1977-12-31","1977年9月","1977年12月","2034-09-01","2034-12-31","2034年9月","2034年12月"]
[25,57,1,25,"57岁1个月","1978-01-01","1978-04-30","1978年1月","1978年4月","2035-02-01","2035-05-30","2035年2月","2035年5月"]
[26,57,2,26,"57岁2个月","1978-05-01","1978-08-31","1978年5月","1978年8月","2035-07-01","2035-10-31","2035年7月","2035年10月"]
[27,57,3,27,"57岁3个月","1978-09-01","1978-12-31","1978年9月","1978年12月","2035-12-01","2036-03-31","2035年12月","2036年3月"]
[28,57,4,28,"57岁4个月","1979-01-01","1979-04-30","1979年1月","1979年4月","2036-05-01","2036-08-30","2036年5月","2036年8月"]
[29,57,5,29,"57岁5个月","1979-05-01","1979-08-31","1979年5月","1979年8月","2036-10-01","2037-01-31","2036年10月","2037年1月"]
[30,57,6,30,{"$f":"IF(ROUND(C33,0)=0,B33 & \"岁\",B33 & \"岁\" & ROUND(C33,0)  &\"个月\")","v":"57岁6个月"},"1979-09-01","1979-12-31","1979年9月","1979年12月","2037-03-01","2037-06-30","2037年3月","2037年6月"]
[31,57,7,31,{"$f":"IF(ROUND(C34,0)=0,B34 & \"岁\",B34 & \"岁\" & ROUND(C34,0)  &\"个月\")","v":"57岁7个月"},"1980-01-01","1980-04-30","1980年1月","1980年4月","2037-08-01","2037-11-30","2037年8月","2037年11月"]
[32,57,8,32,{"$f":"IF(ROUND(C35,0)=0,B35 & \"岁\",B35 & \"岁\" & ROUND(C35,0)  &\"个月\")","v":"57岁8个月"},"1980-05-01","1980-08-31","1980年5月","1980年8月","2038-01-01","2038-04-30","2038年1月","2038年4月"]
[33,57,9,33,"57岁9个月","1980-09-01","1980-12-31","1980年9月","1980年12月","2038-06-01","2038-09-30","2038年6月","2038年9月"]
[34,57,10,34,"57岁10个月","1981-01-01","1981-04-30","1981年1月","1981年4月","2038-11-01","2039-02-28","2038年11月","2039年2月"]
[35,57,11,35,"57岁11个月","1981-05-01","1981-08-31","1981年5月","1981年8月","2039-04-01","2039-07-31","2039年4月","2039年7月"]
[36,58,0,36,"58岁","1981-09-01","1981-12-31","1981年9月","1981年12月","2039-09-01","2039-12-31","2039年9月","2039年12月"]

{"sheet":"女性延迟退休50","index":3,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["开始延迟退休人员\n出生年月日","1975-01-01",null,"当前\n退休年龄",50]
[]
["编号","退休周岁","退休月数","延长月份","实际退休年龄","出生日期开始","出生日期结束","出生年月开始","出生年月开始","新退休日期开始","新退休日期结束","新退休年月开始","新退休年月结束"]
[1,{"$f":"$E$1+INT(D4/12)","v":50},{"$f":"MOD(D4,12)","v":1},{"$f":"A4","v":1},{"$f":"IF(ROUND(C4,0)=0,B4 & \"岁\",B4 & \"岁\" & ROUND(C4,0)  &\"个月\")","v":"50岁1个月"},{"$f":"EDATE($B$1,(A4-1)*2)","v":"1975-01-01"},{"$f":"EDATE(F4,2)-1","v":"1975-02-28"},{"$f":"TEXT(F4,\"YYYY年M月\")","v":"1975年1月"},{"$f":"TEXT(G4,\"YYYY年M月\")","v":"1975年2月"},{"$f":"EDATE(DATE(YEAR(F4)+B4,MONTH(F4),DAY(F4)),C4)","v":"2025-02-01"},{"$f":"EDATE(DATE(YEAR(G4)+B4,MONTH(G4),DAY(G4)),C4)","v":"2025-03-28"},{"$f":"TEXT(J4,\"YYYY年M月\")","v":"2025年2月"},{"$f":"TEXT(K4,\"YYYY年M月\")","v":"2025年3月"}]
[2,50,{"$f":"MOD(D5,12)","v":2},{"$f":"A5","v":2},"50岁2个月",{"$f":"EDATE($B$1,(A5-1)*2)","v":"1975-03-01"},{"$f":"EDATE(F5,2)-1","v":"1975-04-30"},{"$f":"TEXT(F5,\"YYYY年M月\")","v":"1975年3月"},{"$f":"TEXT(G5,\"YYYY年M月\")","v":"1975年4月"},{"$f":"EDATE(DATE(YEAR(F5)+B5,MONTH(F5),DAY(F5)),C5)","v":"2025-05-01"},{"$f":"EDATE(DATE(YEAR(G5)+B5,MONTH(G5),DAY(G5)),C5)","v":"2025-06-30"},{"$f":"TEXT(J5,\"YYYY年M月\")","v":"2025年5月"},{"$f":"TEXT(K5,\"YYYY年M月\")","v":"2025年6月"}]
[3,50,3,3,"50岁3个月","1975-05-01","1975-06-30",{"$f":"TEXT(F6,\"YYYY年M月\")","v":"1975年5月"},"1975年6月",{"$f":"EDATE(DATE(YEAR(F6)+B6,MONTH(F6),DAY(F6)),C6)","v":"2025-08-01"},{"$f":"EDATE(DATE(YEAR(G6)+B6,MONTH(G6),DAY(G6)),C6)","v":"2025-09-30"},{"$f":"TEXT(J6,\"YYYY年M月\")","v":"2025年8月"},"2025年9月"]
[4,50,4,4,"50岁4个月","1975-07-01","1975-08-31","1975年7月","1975年8月","2025-11-01","2025-12-31","2025年11月","2025年12月"]
[5,50,5,5,"50岁5个月","1975-09-01","1975-10-31","1975年9月","1975年10月","2026-02-01","2026-03-31","2026年2月","2026年3月"]
[6,50,6,6,"50岁6个月","1975-11-01","1975-12-31","1975年11月","1975年12月","2026-05-01","2026-06-30","2026年5月","2026年6月"]
[7,50,7,7,"50岁7个月","1976-01-01","1976-02-29","1976年1月","1976年2月","2026-08-01","2026-10-01","2026年8月","2026年10月"]
[8,50,8,8,"50岁8个月","1976-03-01","1976-04-30","1976年3月","1976年4月","2026-11-01","2026-12-30","2026年11月","2026年12月"]
[9,50,9,9,"50岁9个月","1976-05-01","1976-06-30","1976年5月","1976年6月","2027-02-01","2027-03-30","2027年2月","2027年3月"]
[10,50,10,10,"50岁10个月","1976-07-01","1976-08-31","1976年7月","1976年8月","2027-05-01","2027-06-30","2027年5月","2027年6月"]
[11,50,11,11,"50岁11个月","1976-09-01","1976-10-31","1976年9月","1976年10月","2027-08-01","2027-09-30","2027年8月","2027年9月"]
[12,51,0,12,"51岁","1976-11-01","1976-12-31","1976年11月","1976年12月","2027-11-01","2027-12-31","2027年11月","2027年12月"]
[13,51,1,13,"51岁1个月","1977-01-01","1977-02-28","1977年1月","1977年2月","2028-02-01","2028-03-28","2028年2月","2028年3月"]
[14,51,2,14,"51岁2个月","1977-03-01","1977-04-30","1977年3月","1977年4月","2028-05-01","2028-06-30","2028年5月","2028年6月"]
[15,51,3,15,"51岁3个月","1977-05-01","1977-06-30","1977年5月","1977年6月","2028-08-01","2028-09-30","2028年8月","2028年9月"]
[16,51,4,16,"51岁4个月","1977-07-01","1977-08-31","1977年7月","1977年8月","2028-11-01","2028-12-31","2028年11月","2028年12月"]
[17,51,5,17,"51岁5个月","1977-09-01","1977-10-31","1977年9月","1977年10月","2029-02-01","2029-03-31","2029年2月","2029年3月"]
[18,51,6,18,"51岁6个月","1977-11-01","1977-12-31","1977年11月","1977年12月","2029-05-01","2029-06-30","2029年5月","2029年6月"]
[19,51,7,19,"51岁7个月","1978-01-01","1978-02-28","1978年1月","1978年2月","2029-08-01","2029-09-28","2029年8月","2029年9月"]
[20,51,8,20,"51岁8个月","1978-03-01","1978-04-30","1978年3月","1978年4月","2029-11-01","2029-12-30","2029年11月","2029年12月"]
[21,51,9,21,"51岁9个月","1978-05-01","1978-06-30","1978年5月","1978年6月","2030-02-01","2030-03-30","2030年2月","2030年3月"]
[22,51,10,22,"51岁10个月","1978-07-01","1978-08-31","1978年7月","1978年8月","2030-05-01","2030-06-30","2030年5月","2030年6月"]
[23,51,11,23,"51岁11个月","1978-09-01","1978-10-31","1978年9月","1978年10月","2030-08-01","2030-09-30","2030年8月","2030年9月"]
[24,52,0,24,"52岁","1978-11-01","1978-12-31","1978年11月","1978年12月","2030-11-01","2030-12-31","2030年11月","2030年12月"]
[25,52,1,25,"52岁1个月","1979-01-01","1979-02-28","1979年1月","1979年2月","2031-02-01","2031-03-28","2031年2月","2031年3月"]
[26,52,2,26,"52岁2个月","1979-03-01","1979-04-30","1979年3月","1979年4月","2031-05-01","2031-06-30","2031年5月","2031年6月"]
[27,52,3,27,"52岁3个月","1979-05-01","1979-06-30","1979年5月","1979年6月","2031-08-01","2031-09-30","2031年8月","2031年9月"]
[28,52,4,28,"52岁4个月","1979-07-01","1979-08-31","1979年7月","1979年8月","2031-11-01","2031-12-31","2031年11月","2031年12月"]
[29,52,5,29,"52岁5个月","1979-09-01","1979-10-31","1979年9月","1979年10月","2032-02-01","2032-03-31","2032年2月","2032年3月"]
[30,52,6,30,{"$f":"IF(ROUND(C33,0)=0,B33 & \"岁\",B33 & \"岁\" & ROUND(C33,0)  &\"个月\")","v":"52岁6个月"},"1979-11-01","1979-12-31","1979年11月","1979年12月","2032-05-01","2032-06-30","2032年5月","2032年6月"]
[31,52,7,31,{"$f":"IF(ROUND(C34,0)=0,B34 & \"岁\",B34 & \"岁\" & ROUND(C34,0)  &\"个月\")","v":"52岁7个月"},"1980-01-01","1980-02-29","1980年1月","1980年2月","2032-08-01","2032-09-29","2032年8月","2032年9月"]
[32,52,8,32,{"$f":"IF(ROUND(C35,0)=0,B35 & \"岁\",B35 & \"岁\" & ROUND(C35,0)  &\"个月\")","v":"52岁8个月"},"1980-03-01","1980-04-30","1980年3月","1980年4月","2032-11-01","2032-12-30","2032年11月","2032年12月"]
[33,52,9,33,"52岁9个月","1980-05-01","1980-06-30","1980年5月","1980年6月","2033-02-01","2033-03-30","2033年2月","2033年3月"]
[34,52,10,34,"52岁10个月","1980-07-01","1980-08-31","1980年7月","1980年8月","2033-05-01","2033-06-30","2033年5月","2033年6月"]
[35,52,11,35,"52岁11个月","1980-09-01","1980-10-31","1980年9月","1980年10月","2033-08-01","2033-09-30","2033年8月","2033年9月"]
[36,53,0,36,"53岁","1980-11-01","1980-12-31","1980年11月","1980年12月","2033-11-01","2033-12-31","2033年11月","2033年12月"]
[37,{"$f":"$E$1+INT(D40/12)","v":53},{"$f":"MOD(D40,12)","v":1},{"$f":"A40","v":37},{"$f":"IF(ROUND(C40,0)=0,B40 & \"岁\",B40 & \"岁\" & ROUND(C40,0)  &\"个月\")","v":"53岁1个月"},{"$f":"EDATE($B$1,(A40-1)*2)","v":"1981-01-01"},"1981-02-28",{"$f":"TEXT(F40,\"YYYY年M月\")","v":"1981年1月"},{"$f":"TEXT(G40,\"YYYY年M月\")","v":"1981年2月"},{"$f":"EDATE(DATE(YEAR(F40)+B40,MONTH(F40),DAY(F40)),C40)","v":"2034-02-01"},{"$f":"EDATE(DATE(YEAR(G40)+B40,MONTH(G40),DAY(G40)),C40)","v":"2034-03-28"},{"$f":"TEXT(J40,\"YYYY年M月\")","v":"2034年2月"},{"$f":"TEXT(K40,\"YYYY年M月\")","v":"2034年3月"}]
[38,53,2,38,"53岁2个月","1981-03-01","1981-04-30","1981年3月","1981年4月","2034-05-01","2034-06-30","2034年5月","2034年6月"]
[39,53,3,39,"53岁3个月","1981-05-01","1981-06-30","1981年5月","1981年6月","2034-08-01","2034-09-30","2034年8月","2034年9月"]
[40,53,4,40,"53岁4个月","1981-07-01","1981-08-31","1981年7月","1981年8月","2034-11-01","2034-12-31","2034年11月","2034年12月"]
[41,53,5,41,"53岁5个月","1981-09-01","1981-10-31","1981年9月","1981年10月","2035-02-01","2035-03-31","2035年2月","2035年3月"]
[42,53,6,42,"53岁6个月","1981-11-01","1981-12-31","1981年11月","1981年12月","2035-05-01","2035-06-30","2035年5月","2035年6月"]
[43,53,7,43,"53岁7个月","1982-01-01","1982-02-28","1982年1月","1982年2月","2035-08-01","2035-09-28","2035年8月","2035年9月"]
[44,53,8,44,"53岁8个月","1982-03-01","1982-04-30","1982年3月","1982年4月","2035-11-01","2035-12-30","2035年11月","2035年12月"]
[45,53,9,45,"53岁9个月","1982-05-01","1982-06-30","1982年5月","1982年6月","2036-02-01","2036-03-30","2036年2月","2036年3月"]
[46,53,10,46,"53岁10个月","1982-07-01","1982-08-31","1982年7月","1982年8月","2036-05-01","2036-06-30","2036年5月","2036年6月"]
[47,53,11,47,"53岁11个月","1982-09-01","1982-10-31","1982年9月","1982年10月","2036-08-01","2036-09-30","2036年8月","2036年9月"]
[48,54,0,48,"54岁","1982-11-01","1982-12-31","1982年11月","1982年12月","2036-11-01","2036-12-31","2036年11月","2036年12月"]
[49,54,1,49,"54岁1个月","1983-01-01","1983-02-28","1983年1月","1983年2月","2037-02-01","2037-03-28","2037年2月","2037年3月"]
[50,54,2,50,"54岁2个月","1983-03-01","1983-04-30","1983年3月","1983年4月","2037-05-01","2037-06-30","2037年5月","2037年6月"]
[51,54,3,51,"54岁3个月","1983-05-01","1983-06-30","1983年5月","1983年6月","2037-08-01","2037-09-30","2037年8月","2037年9月"]
[52,54,4,52,"54岁4个月","1983-07-01","1983-08-31","1983年7月","1983年8月","2037-11-01","2037-12-31","2037年11月","2037年12月"]
[53,54,5,53,"54岁5个月","1983-09-01","1983-10-31","1983年9月","1983年10月","2038-02-01","2038-03-31","2038年2月","2038年3月"]
[54,54,6,54,"54岁6个月","1983-11-01","1983-12-31","1983年11月","1983年12月","2038-05-01","2038-06-30","2038年5月","2038年6月"]
[55,54,7,55,"54岁7个月","1984-01-01","1984-02-29","1984年1月","1984年2月","2038-08-01","2038-10-01","2038年8月","2038年10月"]
[56,54,8,56,"54岁8个月","1984-03-01","1984-04-30","1984年3月","1984年4月","2038-11-01","2038-12-30","2038年11月","2038年12月"]
[57,54,9,57,"54岁9个月","1984-05-01","1984-06-30","1984年5月","1984年6月","2039-02-01","2039-03-30","2039年2月","2039年3月"]
[58,54,10,58,"54岁10个月","1984-07-01","1984-08-31","1984年7月","1984年8月","2039-05-01","2039-06-30","2039年5月","2039年6月"]
[59,54,11,59,"54岁11个月","1984-09-01","1984-10-31","1984年9月","1984年10月","2039-08-01","2039-09-30","2039年8月","2039年9月"]
[60,55,0,60,"55岁","1984-11-01","1984-12-31","1984年11月","1984年12月","2039-11-01","2039-12-31","2039年11月","2039年12月"]

{"sheet":"社保年份最低缴费年限","index":4,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["年份","当年最低缴费年限"]
[2025,"15年"]
[2026,"15年"]
[2027,"15年"]
[2028,"15年"]
[2029,"15年"]
[2030,"15年+6个月"]
[2031,"16年"]
[2032,"16年+6个月"]
[2033,"17年"]
[2034,"17年+6个月"]
[2035,"18年"]
[2036,"18年+6个月"]
[2037,"19年"]
[2038,"19年+6个月"]
[2039,"20年"]