{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Ejemplo 3"],"not_rendered":{"images":1,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Ejemplo 3","index":0,"n_rows":29,"n_cols":5,"rows_kept":29}
["Ejemplo 3:Cómo calcular el promedio de edades con la función PROMEDIO"]
[]
["Hay muchas formas de calcular la edad de una persona pero muchos de ellos tienen errores y no son adecuados para el cálculo de un promedio."]
["He elegido este sistema ya que se puede hacer el promedio de cada elemento de forma individual"]
[]
["Descripción","Fórmula base"]
["Edad en años completos",{"$f":"GETFORMULA(B14)","v":"=SIFECHA($A14;$B$12;\"y\")"}]
["Edad en meses completos",{"$f":"GETFORMULA(C14)","v":"=SIFECHA($A14;$B$12;\"m\")"}]
["Edad en días completos",{"$f":"GETFORMULA(D14)","v":"=$B$12-A14"}]
["Edad en años y fracción de año"]
[]
["Fecha base >>>",{"$f":"TODAY()","v":"2015-02-23"}]
["Fecha de nacimiento","Años completos","Meses completos","Días completos","Fracción de años"]
["1982-03-14",{"$f":"DATEDIF($A14,$B$12,\"y\")","v":32},{"$f":"DATEDIF($A14,$B$12,\"m\")","v":395},{"$f":"$B$12-A14","v":12034},{"$f":"DATEDIF(A14,$B$12,\"y\")+($B$12-DATE(YEAR(A14)+DATEDIF(A14,$B$12,\"y\"),MONTH(A14),DAY(A14)))/(DATE(YEAR(A14)+DATEDIF(A14,$B$12,\"y\")+1,MONTH(A14),DAY(A14))-DATE(YEAR(A14)+DATEDIF(A14,$B$12,\"y\"),MONTH(A14),DAY(A14)))","v":{"v":32.94794520547945,"d":"32.94794520547940"}}]
["1922-07-26",92,1110,33815,{"$f":"DATEDIF(A15,$B$12,\"y\")+($B$12-DATE(YEAR(A15)+DATEDIF(A15,$B$12,\"y\"),MONTH(A15),DAY(A15)))/(DATE(YEAR(A15)+DATEDIF(A15,$B$12,\"y\")+1,MONTH(A15),DAY(A15))-DATE(YEAR(A15)+DATEDIF(A15,$B$12,\"y\"),MONTH(A15),DAY(A15)))","v":{"v":92.58082191780822,"d":"92.58082191780820"}}]
["1976-08-27",38,461,14059,{"v":38.49315068493151,"d":"38.49315068493150"}]
["1943-11-22",71,855,26026,{"v":71.25479452054795,"d":"71.25479452054790"}]
["1945-09-06",69,833,25372,{"v":69.46575342465754,"d":"69.46575342465750"}]
["1947-02-23",68,816,24837,{"v":68,"d":"68.00000000000000"}]
["1948-06-16",66,800,24358,{"v":66.69041095890411,"d":"66.69041095890410"}]
["1948-11-08",66,795,24213,{"v":66.2931506849315,"d":"66.29315068493150"}]
["1952-06-06",62,752,22907,{"v":62.71780821917808,"d":"62.71780821917810"}]
["1967-09-19",47,569,17324,{"v":47.43013698630137,"d":"47.43013698630140"}]
["1985-10-31",29,351,10707,{"v":29.315068493150687,"d":"29.31506849315070"}]
["1986-03-24",28,346,10563,{"v":28.92054794520548,"d":"28.92054794520550"}]
["1987-12-28",27,325,9919,{"v":27.156164383561645,"d":"27.15616438356160"}]
["1993-09-13",21,257,7833,{"v":21.446575342465753,"d":"21.44657534246580"}]
["2005-01-02",10,121,3704,{"v":10.142465753424657,"d":"10.14246575342470"}]
["Promedio",{"$f":"TEXT(AVERAGE(B14:B28),\"0.0\")&\" años completos\"","v":"48 años completos"},{"$f":"TEXT(AVERAGE(C14:C28),\"0.00\")&\" meses completos\"","v":"586 meses completos"},{"$f":"TEXT(AVERAGE(D14:D28),\"0.00\")&\" días\"","v":"17.845 días"},{"$f":"TEXT(AVERAGE(E14:E28),\"0\")&\" años y fracción de año\"","v":"49 años y fracción de año"}]