{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Copyright","Table","Formulas","Macros"],"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":"Copyright","index":0,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Copyright: Charley Kyd, ExcelUser.com, 2006"]
["This workbook is provided on an as-is basis. Use it at your own risk. You have permission to modify and use these"]
["macros and formulas for your own use, but they may not be sold without written permission of the author."]
[]
["If you send versions of this workbook to others, please tell them about ExcelUser.com."]
[]
["Thank you!"]
[]
["Charley Kyd"]

{"sheet":"Table","index":1,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Actual Date","As Entered In Excel","Number To Text","Conversion Problem","Text Value","Adj Serial Number","Year","Age","Source"]
["7 January 1858","2/24/1858",{"$f":"TEXT(B2,\"dd mmm yyyy\")","v":"2/24/1858"},{"$f":"ISERROR(DATEVALUE(LEFT(C2,LEN(C2)-4)&\"2000\"))","v":false},{"$f":"RIGHT(C2,4)&\"-\"&IF(D2,\"01-01\",TEXT(LEFT(C2,LEN(C2)-4)&\"2000\",\"mm-dd\"))","v":"1858-02-24"},{"$f":"DateTextValue(E2)","v":-15284},1919,60,"Death Records, 1864 - 1950"]
["16 July 1858","7/16/1858",{"$f":"TEXT(B3,\"dd mmm yyyy\")","v":"7/16/1858"},{"$f":"ISERROR(DATEVALUE(LEFT(C3,LEN(C3)-4)&\"2000\"))","v":false},{"$f":"RIGHT(C3,4)&\"-\"&IF(D3,\"01-01\",TEXT(LEFT(C3,LEN(C3)-4)&\"2000\",\"mm-dd\"))","v":"1858-07-16"},{"$f":"DateTextValue(E3)","v":-15142},1858,0,"Estimate based on Birth of Francis Ellen Hawley"]
["7 January 1859","1/7/1859",{"$f":"TEXT(B4,\"dd mmm yyyy\")","v":"1/7/1859"},{"$f":"ISERROR(DATEVALUE(LEFT(C4,LEN(C4)-4)&\"2000\"))","v":false},{"$f":"RIGHT(C4,4)&\"-\"&IF(D4,\"01-01\",TEXT(LEFT(C4,LEN(C4)-4)&\"2000\",\"mm-dd\"))","v":"1859-01-07"},{"$f":"DateTextValue(E4)","v":-14967},1919,60,"Death Records, 1897-1920"]
["04 June 1859","6/4/1859",{"$f":"TEXT(B5,\"dd mmm yyyy\")","v":"6/4/1859"},{"$f":"ISERROR(DATEVALUE(LEFT(C5,LEN(C5)-4)&\"2000\"))","v":false},{"$f":"RIGHT(C5,4)&\"-\"&IF(D5,\"01-01\",TEXT(LEFT(C5,LEN(C5)-4)&\"2000\",\"mm-dd\"))","v":"1859-06-04"},{"$f":"DateTextValue(E5)","v":-14819},1880,21,"1880 Census"]
["26 November 1859","11/26/1859",{"$f":"TEXT(B6,\"dd mmm yyyy\")","v":"11/26/1859"},{"$f":"ISERROR(DATEVALUE(LEFT(C6,LEN(C6)-4)&\"2000\"))","v":false},{"$f":"RIGHT(C6,4)&\"-\"&IF(D6,\"01-01\",TEXT(LEFT(C6,LEN(C6)-4)&\"2000\",\"mm-dd\"))","v":"1859-11-26"},{"$f":"DateTextValue(E6)","v":-14644},1875,16,"Marriage to Alexander Whitman"]
["29 April 1861","4/29/1861",{"$f":"TEXT(B7,\"dd mmm yyyy\")","v":"4/29/1861"},{"$f":"ISERROR(DATEVALUE(LEFT(C7,LEN(C7)-4)&\"2000\"))","v":false},{"$f":"RIGHT(C7,4)&\"-\"&IF(D7,\"01-01\",TEXT(LEFT(C7,LEN(C7)-4)&\"2000\",\"mm-dd\"))","v":"1861-04-29"},{"$f":"DateTextValue(E7)","v":-14124},1910,49,"1910 Census"]
["1 June 1861","6/1/1861",{"$f":"TEXT(B8,\"dd mmm yyyy\")","v":"6/1/1861"},{"$f":"ISERROR(DATEVALUE(LEFT(C8,LEN(C8)-4)&\"2000\"))","v":false},{"$f":"RIGHT(C8,4)&\"-\"&IF(D8,\"01-01\",TEXT(LEFT(C8,LEN(C8)-4)&\"2000\",\"mm-dd\"))","v":"1861-06-01"},{"$f":"DateTextValue(E8)","v":-14091},1900,39,"1900 Census"]
["09 August 1861","8/9/1861",{"$f":"TEXT(B9,\"dd mmm yyyy\")","v":"8/9/1861"},{"$f":"ISERROR(DATEVALUE(LEFT(C9,LEN(C9)-4)&\"2000\"))","v":false},{"$f":"RIGHT(C9,4)&\"-\"&IF(D9,\"01-01\",TEXT(LEFT(C9,LEN(C9)-4)&\"2000\",\"mm-dd\"))","v":"1861-08-09"},{"$f":"DateTextValue(E9)","v":-14022},1870,9,"1870 Census"]
["10 April 1863","4/10/1863",{"$f":"TEXT(B10,\"dd mmm yyyy\")","v":"4/10/1863"},{"$f":"ISERROR(DATEVALUE(LEFT(C10,LEN(C10)-4)&\"2000\"))","v":false},{"$f":"RIGHT(C10,4)&\"-\"&IF(D10,\"01-01\",TEXT(LEFT(C10,LEN(C10)-4)&\"2000\",\"mm-dd\"))","v":"1863-04-10"},{"$f":"DateTextValue(E10)","v":-13413},1913,50,"Marriage to Alva Busch"]

{"sheet":"Formulas","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Actual","As Entered","Number","Conversion","Text"]
["Date","In Excel","To Text","Problem","Value"]
["21 Nov 2001","2001-11-21",{"$f":"TEXT(B3,\"dd mmm yyyy\")","v":"21 Nov 2001"},{"$f":"ISERROR(DATEVALUE(LEFT(C3,LEN(C3)-4)&\"2000\"))","v":false},{"$f":"RIGHT(C3,4)&\"-\"&IF(D3,\"01-01\",TEXT(LEFT(C3,LEN(C3)-4)&\"2000\",\"mm-dd\"))","v":"2001-11-21"}]
["Mar 1, 1900","1900-03-01","01 Mar 1900",false,{"$f":"RIGHT(C4,4)&\"-\"&IF(D4,\"01-01\",TEXT(LEFT(C4,LEN(C4)-4)&\"2000\",\"mm-dd\"))","v":"1900-03-01"}]
["Feb 29, 1900",60,"29 Feb 1900",false,{"$f":"RIGHT(C5,4)&\"-\"&IF(D5,\"01-01\",TEXT(LEFT(C5,LEN(C5)-4)&\"2000\",\"mm-dd\"))","v":"1900-02-29"}]
["Feb 28, 1900","1900-02-28","28 Feb 1900",false,"1900-02-28"]
["Jan 1, 1900","1900-01-01","01 Jan 1900",false,{"$f":"RIGHT(C7,4)&\"-\"&IF(D7,\"01-01\",TEXT(LEFT(C7,LEN(C7)-4)&\"2000\",\"mm-dd\"))","v":"1900-01-01"}]
["1 Sep 1841","1 Sep 1841","1 Sep 1841",false,"1841-09-01"]
["Aug 22, 1763","Aug 22, 1763","Aug 22, 1763",false,"1763-08-22"]
["Sep 1601","Sep 1601","Sep 1601",false,"1601-09-01"]
["Abt 1533","Abt 1533","Abt 1533",true,"1533-01-01"]
["Circa 1492","Circa 1492","Circa 1492",true,"1492-01-01"]
["Feb 29, 1200","2/29/1200","2/29/1200",false,{"$f":"RIGHT(C13,4)&\"-\"&IF(D13,\"01-01\",TEXT(LEFT(C13,LEN(C13)-4)&\"2000\",\"mm-dd\"))","v":"1200-02-29"}]
["Jan 1, 0100","Jan 1, 0100","Jan 1, 0100",false,{"$f":"RIGHT(C14,4)&\"-\"&IF(D14,\"01-01\",TEXT(LEFT(C14,LEN(C14)-4)&\"2000\",\"mm-dd\"))","v":"0100-01-01"}]

{"sheet":"Macros","index":3,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[17,2,18,5],[19,2,20,5],[28,2,30,5],[24,2,27,5]]}
["Actual","As Entered","Text","Adj Serial"]
["Date","In Excel","Value","Number"]
["21 Nov 2001","2001-11-21",{"$f":"DateText(B3)","v":"2001-11-21"},{"$f":"DateTextValue(C3)","v":37216}]
["Mar 1, 1900","1900-03-01","1900-03-01",61]
["Feb 29, 1900",60,"1900-03-01",61]
["Feb 28, 1900","1900-02-28","1900-02-28",60]
["Jan 1, 1900","1900-01-01","1900-01-01",2]
["1 Sep 1841","1 Sep 1841","1841-09-01",-21304]
["Aug 22, 1763","Aug 22, 1763","1763-08-22",-49803]
["Sep 1601","Sep 1601","1601-09-01",-108962]
["Abt 1533","Abt 1533","1533-01-01",-134042]
["Circa 1492","Circa 1492","1492-01-01",-149017]
["Feb 29, 1200","2/29/1200","1200-02-29",{"$f":"DateTextValue(C13)","v":-255609}]
["Jan 1, 0100","Jan 1, 0100","0100-01-01",-657434]
[]
["DateText Examples"]
["Value","Formula","Comments"]
["Test",{"$f":"DateText(A18)","v":"Test"},"Returns the original value for \"dates\" it doesn't recognize."]
[null,{"$f":"DateText(A19)","v":""}]
["Feb 29, 1900",{"$f":"DateText(A20)","v":"1900-01-01"},"Returns Jan 1 for failed dates with recognizable years."]
["Abt 1533",{"$f":"DateText(A21)","v":"1533-01-01"}]
[]
["DateTextValue Examples"]
["Value","Formula","Comments"]
["1492-06-11",{"$f":"DateTextValue(A25)","v":-148855},"Recognizes a variety of date formats"]
["June 11, 1492",-148855]
["6/11/1492",-148855]
["11-Jun-1492",-148855]
["Test","Test","Returns the original value for \"dates\" it doesn't recognize."]
["Feb 29, 1900","Feb 29, 1900"]
[null,""]