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

{"sheet":"Ejemplo 8","index":0,"n_rows":16,"n_cols":4,"rows_kept":16}
["Ejemplo 8: Configurar agenda con primer y última día del mes"]
[]
["Se trata de un problema bastante común para muchos usuarios"]
[null,null,"Primer día del mes","Último día"]
["Fecha base",null,"2015-02-14","2015-02-28"]
["Celda de anclaje",null,{"$f":"DATE(YEAR(C5),MONTH(C5)+1,1)","v":"2015-03-01"},{"$f":"DATE(YEAR(D5),MONTH(D5)+2,0)","v":"2015-03-31"}]
[null,null,{"$f":"DATE(YEAR(C6),MONTH(C6)+1,1)","v":"2015-04-01"},{"$f":"DATE(YEAR(D6),MONTH(D6)+2,0)","v":"2015-04-30"}]
[null,null,{"$f":"DATE(YEAR(C7),MONTH(C7)+1,1)","v":"2015-05-01"},{"$f":"DATE(YEAR(D7),MONTH(D7)+2,0)","v":"2015-05-31"}]
[null,null,{"$f":"DATE(YEAR(C8),MONTH(C8)+1,1)","v":"2015-06-01"},{"$f":"DATE(YEAR(D8),MONTH(D8)+2,0)","v":"2015-06-30"}]
[null,null,{"$f":"DATE(YEAR(C9),MONTH(C9)+1,1)","v":"2015-07-01"},{"$f":"DATE(YEAR(D9),MONTH(D9)+2,0)","v":"2015-07-31"}]
[]
["Fórmula para la primera fecha"]
[{"$f":"\"Fórmula en celda de anclaje \"&ADDRESS(ROW(C6),COLUMN(C6),4)&\" which is copied down: >>>   \"&GETFORMULA(C6)","v":"Fórmula en celda de anclaje C6 which is copied down: >>>   =FECHA(AÑO(C5);MES(C5)+1;1)"}]
[]
["Fórmula para la última fecha"]
[{"$f":"\"Fórmula en celda de anclaje \"&ADDRESS(ROW(D7),COLUMN(D7),4)&\" which is copied down: >>>   \"&GETFORMULA(D7)","v":"Fórmula en celda de anclaje D7 which is copied down: >>>   =FECHA(AÑO(D6),MES(D6)+2,0)"}]