{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Fechas","Año<1900","Día Semana","Edad"],"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":"Fechas","index":0,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Fechas (dd-mm-aaaa)\nExcel >= 01-03-1900\nVBA >= 01-01-0100","Fecha: AAAA-MM-DD\nFormato Texto\nISO 8601","Número\nSerie\nExcel","Nombre\nDía Semana\nExcel","Número\nSerie\nVBA","Nombre\nDía Semana\nVBA"]
["9999-12-31",{"$f":"IF(ISNUMBER($A2),TEXT(YEAR($A2),\"0000\")&\"-\"&TEXT(MONTH($A2),\"00\")&\"-\"&TEXT(DAY($A2),\"00\"),\nRIGHT($A2,4)&\"-\"&MID($A2,4,2)&\"-\"&LEFT($A2,2))","v":"9999-12-31"},{"$f":"IF(ISNUMBER($A2),$A2,\"\")","v":2958465},{"$f":"IF(ISNUMBER($A2),TEXT($A2,\"dddd\"),\"\")","v":"viernes"},{"$f":"ObtenerSerieFechaISO($B2)","v":2958465},{"$f":"ObtenerDíaSemanaISO($B2)","v":"viernes"}]
["2020-10-20",{"$f":"IF(ISNUMBER($A3),TEXT(YEAR($A3),\"0000\")&\"-\"&TEXT(MONTH($A3),\"00\")&\"-\"&TEXT(DAY($A3),\"00\"),\nRIGHT($A3,4)&\"-\"&MID($A3,4,2)&\"-\"&LEFT($A3,2))","v":"2020-10-20"},{"$f":"IF(ISNUMBER($A3),$A3,\"\")","v":44124},{"$f":"IF(ISNUMBER($A3),TEXT($A3,\"dddd\"),\"\")","v":"martes"},{"$f":"ObtenerSerieFechaISO($B3)","v":44124},{"$f":"ObtenerDíaSemanaISO($B3)","v":"martes"}]
["2000-02-29",{"$f":"IF(ISNUMBER($A4),TEXT(YEAR($A4),\"0000\")&\"-\"&TEXT(MONTH($A4),\"00\")&\"-\"&TEXT(DAY($A4),\"00\"),\nRIGHT($A4,4)&\"-\"&MID($A4,4,2)&\"-\"&LEFT($A4,2))","v":"2000-02-29"},{"$f":"IF(ISNUMBER($A4),$A4,\"\")","v":36585},{"$f":"IF(ISNUMBER($A4),TEXT($A4,\"dddd\"),\"\")","v":"martes"},{"$f":"ObtenerSerieFechaISO($B4)","v":36585},{"$f":"ObtenerDíaSemanaISO($B4)","v":"martes"}]
["1900-03-01",{"$f":"IF(ISNUMBER($A5),TEXT(YEAR($A5),\"0000\")&\"-\"&TEXT(MONTH($A5),\"00\")&\"-\"&TEXT(DAY($A5),\"00\"),\nRIGHT($A5,4)&\"-\"&MID($A5,4,2)&\"-\"&LEFT($A5,2))","v":"1900-03-01"},{"$f":"IF(ISNUMBER($A5),$A5,\"\")","v":61},{"$f":"IF(ISNUMBER($A5),TEXT($A5,\"dddd\"),\"\")","v":"jueves"},{"$f":"ObtenerSerieFechaISO($B5)","v":61},{"$f":"ObtenerDíaSemanaISO($B5)","v":"jueves"}]
["1900-02-28",{"$f":"IF(ISNUMBER($A6),TEXT(YEAR($A6),\"0000\")&\"-\"&TEXT(MONTH($A6),\"00\")&\"-\"&TEXT(DAY($A6),\"00\"),\nRIGHT($A6,4)&\"-\"&MID($A6,4,2)&\"-\"&LEFT($A6,2))","v":"1900-02-28"},{"$f":"IF(ISNUMBER($A6),$A6,\"\")","v":59},{"$f":"IF(ISNUMBER($A6),TEXT($A6,\"dddd\"),\"\")","v":"martes"},{"$f":"ObtenerSerieFechaISO($B6)","v":60},{"$f":"ObtenerDíaSemanaISO($B6)","v":"miércoles"}]
["1900-01-01",{"$f":"IF(ISNUMBER($A7),TEXT(YEAR($A7),\"0000\")&\"-\"&TEXT(MONTH($A7),\"00\")&\"-\"&TEXT(DAY($A7),\"00\"),\nRIGHT($A7,4)&\"-\"&MID($A7,4,2)&\"-\"&LEFT($A7,2))","v":"1900-01-01"},{"$f":"IF(ISNUMBER($A7),$A7,\"\")","v":1},{"$f":"IF(ISNUMBER($A7),TEXT($A7,\"dddd\"),\"\")","v":"domingo"},{"$f":"ObtenerSerieFechaISO($B7)","v":2},{"$f":"ObtenerDíaSemanaISO($B7)","v":"lunes"}]
["31-12-1899",{"$f":"IF(ISNUMBER($A8),TEXT(YEAR($A8),\"0000\")&\"-\"&TEXT(MONTH($A8),\"00\")&\"-\"&TEXT(DAY($A8),\"00\"),\nRIGHT($A8,4)&\"-\"&MID($A8,4,2)&\"-\"&LEFT($A8,2))","v":"1899-12-31"},{"$f":"IF(ISNUMBER($A8),$A8,\"\")","v":""},{"$f":"IF(ISNUMBER($A8),TEXT($A8,\"dddd\"),\"\")","v":""},{"$f":"ObtenerSerieFechaISO($B8)","v":1},{"$f":"ObtenerDíaSemanaISO($B8)","v":"domingo"}]
["15-10-1582",{"$f":"IF(ISNUMBER($A9),TEXT(YEAR($A9),\"0000\")&\"-\"&TEXT(MONTH($A9),\"00\")&\"-\"&TEXT(DAY($A9),\"00\"),\nRIGHT($A9,4)&\"-\"&MID($A9,4,2)&\"-\"&LEFT($A9,2))","v":"1582-10-15"},{"$f":"IF(ISNUMBER($A9),$A9,\"\")","v":""},{"$f":"IF(ISNUMBER($A9),TEXT($A9,\"dddd\"),\"\")","v":""},{"$f":"ObtenerSerieFechaISO($B9)","v":-115858},{"$f":"ObtenerDíaSemanaISO($B9)","v":"viernes"}]
["01-01-0100",{"$f":"IF(ISNUMBER($A10),TEXT(YEAR($A10),\"0000\")&\"-\"&TEXT(MONTH($A10),\"00\")&\"-\"&TEXT(DAY($A10),\"00\"),\nRIGHT($A10,4)&\"-\"&MID($A10,4,2)&\"-\"&LEFT($A10,2))","v":"0100-01-01"},{"$f":"IF(ISNUMBER($A10),$A10,\"\")","v":""},{"$f":"IF(ISNUMBER($A10),TEXT($A10,\"dddd\"),\"\")","v":""},{"$f":"ObtenerSerieFechaISO($B10)","v":-657434},{"$f":"ObtenerDíaSemanaISO($B10)","v":"viernes"}]

{"sheet":"Año<1900","index":1,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[23,0,23,4],[20,0,20,4],[29,0,29,8]]}
["Fecha ISO 8601\nCalendario\nGregoriano","Fecha\nExcel","Número\nSerie\nExcel","Número\nSerie\nVBA","Nombre\nDía Semana\nExcel","Nombre\nDía Semana\nVBA","NOTAS: Calendario Gregoriano vs Juliano\ny errores en las fechas en Excel y en VBA "]
["9999-12-31",{"$f":"IFERROR(DATEVALUE($A2),$A2)","v":"9999-12-31"},{"$f":"DATEVALUE($A2)","v":2958465},{"$f":"ObtenerSerieFechaISO($A2)","v":2958465},{"$f":"TEXT(DATE(--LEFT($A2,4),--MID($A2,6,2),--RIGHT($A2,2)),\"dddd\")","v":"viernes"},{"$f":"ObtenerDíaSemanaISO($A2)","v":"viernes"},"Último día correcto en Excel y en VBA."]
["2000-01-01","2000-01-01",36526,{"$f":"ObtenerSerieFechaISO($A3)","v":36526},{"$f":"TEXT(DATE(--LEFT($A3,4),--MID($A3,6,2),--RIGHT($A3,2)),\"dddd\")","v":"sábado"},{"$f":"ObtenerDíaSemanaISO($A3)","v":"sábado"},"A las 12:00 TT se fija como referencia en astronomía la época J2000.0.\nLa fecha juliana, día juliano o DJ es el número de días y fracción transcurridos desde el mediodía del 1º de enero del año 4713 a. C."]
["2001-01-01","2001-01-01",36892,36892,"lunes","lunes","Primer día del siglo XXI y del milenio III."]
["1900-03-01","1900-03-01",61,61,"jueves","jueves","Primer día correcto en Excel, para el que coincide su número de serie con VBA."]
["1900-02-29",60,60,61,"miércoles","jueves","Error por no ser bisiesto el año 1900."]
["1900-02-28","1900-02-28",59,60,"martes","miércoles","Error de Excel con días anteriores a 1900-03-01"]
["1900-01-01","1900-01-01",1,2,"domingo","lunes","Primer día de error de Excel por no ser bisiesto el año 1900."]
["1899-12-31","1899-12-31",{"$error":"#VALUE!"},1,"martes","domingo","Primer día positivo en VBA"]
["1899-12-30",{"$f":"IFERROR(DATEVALUE($A10),$A10)","v":"1899-12-30"},{"$f":"DATEVALUE($A10)","v":{"$error":"#VALUE!"}},0,"lunes","sábado","Día 0 en VBA"]
["1899-12-29","1899-12-29",{"$error":"#VALUE!"},-1,"domingo","viernes","Primer día negativo en VBA"]
["1752-09-14",{"$f":"IFERROR(DATEVALUE($A12),$A12)","v":"1752-09-14"},{"$f":"DATEVALUE($A12)","v":{"$error":"#VALUE!"}},-53797,{"$f":"TEXT(DATE(--LEFT($A12,4),--MID($A12,6,2),--RIGHT($A12,2)),\"dddd\")","v":"sábado"},"jueves","Washington, Oregon, and the Eastern Seaboard converted with England. Last Julian date: Sep 2, 1752. First Gregorian date: Sep 14, 1752."]
["1582-12-20","1582-12-20",{"$error":"#VALUE!"},-115792,{"$f":"TEXT(DATE(--LEFT($A13,4),--MID($A13,6,2),--RIGHT($A13,2)),\"dddd\")","v":"miércoles"},"lunes","The Mississippi Valley converted with France. Last Julian date: Dec 9, 1582. First Gregorian date: Dec 20, 1582."]
["1582-10-15","1582-10-15",{"$error":"#VALUE!"},-115858,"domingo","viernes","En Roma, el papa Gregorio XIII decreta el calendario gregoriano en sustitución del calendario juliano; este día (viernes 15 de octubre de 1582) vino después del jueves 4 de octubre (no existieron las 10 fechas intermedias).\n\nTexas, Florida, California, Nevada, Arizona y Nuevo México se convirtieron con España. Última fecha juliana: 4 de octubre de 1582. Primera fecha gregoriana: 15 de octubre de 1582. Para ser claros, el miércoles 4 de octubre de 1582 (juliano) fue seguido por el jueves 15 de octubre de 1582 (gregoriano)."]
["0100-01-01","0100-01-01",{"$error":"#VALUE!"},-657434,"sábado","viernes","Primer día admitido por VBA."]
["0099-12-31","0099-12-31",{"$f":"DATEVALUE($A16)","v":{"$error":"#VALUE!"}},36525,"viernes","viernes","30 a 99     se interpreta como los años 1930 a 1999."]
["0000-01-01","0000-01-01",{"$f":"DATEVALUE($A17)","v":{"$error":"#VALUE!"}},36526,"domingo","sábado","00 a 29     se interpreta como los años 2000 a 2029."]
[]
[]
["How to Work with Dates Before 1900 in Excel"]
["http://www.exceluser.com/formulas/earlydates.htm"]
[]
["The Perpetual Calendar by Toke Nørby"]
["https://norbyhus.dk/calendar.php"]
[]
["ISO 8601 DATE AND TIME FORMAT"]
["https://www.iso.org/iso-8601-date-and-time-format.html"]
[]
["Cambiar el sistema, formato o la interpretación de los años de dos dígitos de las fechas"]
["https://support.microsoft.com/es-es/office/cambiar-el-sistema-formato-o-la-interpretaci%C3%B3n-de-los-a%C3%B1os-de-dos-d%C3%ADgitos-de-las-fechas-aaa2159b-4ae8-4651-8bce-d4707bc9fb9f#:~:text=Si%20escribe%20una%20fecha%20con,los%20a%C3%B1os%202000%20a%202029."]
[" "]

{"sheet":"Día Semana","index":2,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Fecha texto < 1900\no valor >= 1900","Número Serie\nVBA","Día de la semana\nVBA"]
["0100-01-01",{"$f":"ObtenerSerieFechaVBA($A2,ISNUMBER($A2))","v":-657434},{"$f":"ObtenerDíaSemanaVBA($A2,ISNUMBER($A2))","v":"viernes"}]
["1810-04-12",{"$f":"ObtenerSerieFechaVBA($A3,ISNUMBER($A3))","v":-32769},{"$f":"ObtenerDíaSemanaVBA($A3,ISNUMBER($A3))","v":"jueves"}]
["13-04-1810",-32768,"viernes"]
["1 ago 1810",-32658,"miércoles"]
["01 ago 1810",-32658,"miércoles"]
["1-8-1810",-32658,"miércoles"]
["1-08-1810",-32658,"miércoles"]
["01-08-1810",-32658,"miércoles"]
["1/8/1810",-32658,"miércoles"]
["1/08/1810",-32658,"miércoles"]
["01/08/1810",-32658,"miércoles"]
["1810-8-1",-32658,"miércoles"]
["1810-08-1",-32658,"miércoles"]
["1810-08-01",-32658,"miércoles"]
["29-12-1899",-1,"viernes"]
["30-12-1899",0,"sábado"]
["31-12-1899",1,"domingo"]
["1900-01-01",2,"lunes"]
["1900-01-02",3,"martes"]
["1900-02-28",60,"miércoles"]
[60,-0.1,"#N/A"]
["1900-03-01",61,"jueves"]
["9999-12-31",2958465,"viernes"]

{"sheet":"Edad","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Fecha\nInicial","Fecha\nFinal","Diferencia\nen días","Edad"]
["0100-01-01","9999-12-31",{"$f":"RestarFechas($A2,$B2)","v":3615899},{"$f":"ObtenerEdad($A2,$B2)","v":9899}]
["1857-07-01","1930-10-16",{"$f":"RestarFechas($A3,$B3)","v":26769},{"$f":"ObtenerEdad($A3,$B3)","v":73}]
["01-07-1857","1930-10-16",{"$f":"RestarFechas($A4,$B4)","v":26769},{"$f":"ObtenerEdad($A4,$B4)","v":73}]
["1-07-1857","16-10-1930",26769,{"$f":"ObtenerEdad($A5,$B5)","v":73}]
["1-7-1857","16/10/1930",26769,{"$f":"ObtenerEdad($A6,$B6)","v":73}]
["1 julio 1857","16-10-1930",26769,{"$f":"ObtenerEdad($A7,$B7)","v":73}]
["1-7-1857","16-10-30",26769,73]
["18-nov-1899","6-sep-1980",{"$f":"RestarFechas($A9,$B9)","v":29512},{"$f":"ObtenerEdad($A9,$B9)","v":80}]
["18-nov-1899","17-nov-1980",{"$f":"RestarFechas($A10,$B10)","v":29584},{"$f":"ObtenerEdad($A10,$B10)","v":80}]
["18-nov-1899","18-nov-80",29585,{"$f":"ObtenerEdad($A11,$B11)","v":81}]
["18-nov-1899",null,44172,{"$f":"ObtenerEdad($A12,$B12)","v":120}]
["18-nov-1899",{"$f":"TODAY()","v":"2020-10-26"},44172,120]
[null,null,-1,{"$f":"ObtenerEdad($A14,$B14)","v":-1}]