{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Retirement date calculator"],"not_rendered":{"charts":0,"images":1,"macros":0,"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":"Retirement date calculator","index":0,"n_rows":23,"n_cols":22,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,9,2,17],[8,1,8,2],[12,1,12,2],[6,1,6,11]]}
[]
[null,null,null,null,null,null,null,null,null,"Retirement date calculator"]
[]
[]
[]
[]
[null,"This calculator provides the new retirement date for a member who wants to change their retirement age. Two options are available for the month in which the member will retire: the member can either retire at the end of the month in which they reach their new retirement age, or at the end of a specified month in the year in which they reach their new retirement age."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January",1]
[null,"Please provide the following information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"February",2]
[null,"Date of birth",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"March",3]
[null,"Retirement age",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May",5]
[null,"Additional option",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June",6]
[null,"Retirement month (leave blank to default to the member's birthday month)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",8]
[null,{"$f":"IF(V23,\"New retirement date\",\"\")","v":""},{"$f":"IF(V23,TEXT(IF(C14<>\"\",V22,V21),\"MMMM YYYY\"),\"Please complete the fields above\")","v":"Please complete the fields above"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"December",12]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New date - birthday month",{"$f":"EOMONTH(C10,12*C11)","v":"1900-01-31"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New date - month specified",{"$f":"IF(MONTH(C10)>VLOOKUP(C14,$U$8:$V$19,2,FALSE),DATE(YEAR(C10)+C11+1,VLOOKUP(C14,$U$8:$V$19,2,FALSE),1),DATE(YEAR(C10)+C11,VLOOKUP(C14,$U$8:$V$19,2,FALSE),1))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Information complete",{"$f":"AND(C10<>\"\",C11<>\"\")","v":false}]