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

{"sheet":"Ejemplo 13","index":0,"n_rows":40,"n_cols":5,"rows_kept":40}
["Ejemplo 13: Cómo buscar el último día especificado de una semana del mes (ej. Último jueves)."]
[]
["Ejemplo muy útil a la hora de efectuar pagos de nóminas o envíos de pagos a bancos"]
[]
["Año >>>",null,2013,2012,2012]
["Mes >>>",null,"Enero","Febrero","Marzo"]
["Número de mes >>>",null,{"$f":"VLOOKUP(C$6,MesesLargos2,2,FALSE)","v":1},{"$f":"VLOOKUP(D$6,MesesLargos2,2,FALSE)","v":2},{"$f":"VLOOKUP(E$6,MesesLargos2,2,FALSE)","v":3}]
["Fecha del último Lunes del mes",null,{"$f":"DATE(C$5,C$7+1,1)-CHOOSE(WEEKDAY(DATE(C$5,C$7+1,1),2),7,1,2,3,4,5,6)","v":"2013-01-28"},{"$f":"DATE(D$5,D$7+1,1)-CHOOSE(WEEKDAY(DATE(D$5,D$7+1,1),2),7,1,2,3,4,5,6)","v":"2012-02-27"},{"$f":"DATE(E$5,E$7+1,1)-CHOOSE(WEEKDAY(DATE(E$5,E$7+1,1),2),7,1,2,3,4,5,6)","v":"2012-03-26"}]
["Fecha del último Martes del mes",null,{"$f":"DATE(C$5,C$7+1,1)-CHOOSE(WEEKDAY(DATE(C$5,C$7+1,1),2),6,7,1,2,3,4,5)","v":"2013-01-29"},{"$f":"DATE(D$5,D$7+1,1)-CHOOSE(WEEKDAY(DATE(D$5,D$7+1,1),2),6,7,1,2,3,4,5)","v":"2012-02-28"},{"$f":"DATE(E$5,E$7+1,1)-CHOOSE(WEEKDAY(DATE(E$5,E$7+1,1),2),6,7,1,2,3,4,5)","v":"2012-03-27"}]
["Fecha del último Miércoles del mes",null,{"$f":"DATE(C$5,C$7+1,1)-CHOOSE(WEEKDAY(DATE(C$5,C$7+1,1),2),5,6,7,1,2,3,4)","v":"2013-01-30"},{"$f":"DATE(D$5,D$7+1,1)-CHOOSE(WEEKDAY(DATE(D$5,D$7+1,1),2),5,6,7,1,2,3,4)","v":"2012-02-29"},{"$f":"DATE(E$5,E$7+1,1)-CHOOSE(WEEKDAY(DATE(E$5,E$7+1,1),2),5,6,7,1,2,3,4)","v":"2012-03-28"}]
["Fecha del último Jueves del mes",null,{"$f":"DATE(C$5,C$7+1,1)-CHOOSE(WEEKDAY(DATE(C$5,C$7+1,1),2),4,5,6,7,1,2,3)","v":"2013-01-31"},{"$f":"DATE(D$5,D$7+1,1)-CHOOSE(WEEKDAY(DATE(D$5,D$7+1,1),2),4,5,6,7,1,2,3)","v":"2012-02-23"},{"$f":"DATE(E$5,E$7+1,1)-CHOOSE(WEEKDAY(DATE(E$5,E$7+1,1),2),4,5,6,7,1,2,3)","v":"2012-03-29"}]
["Fecha del último Viernes del mes",null,{"$f":"DATE(C$5,C$7+1,1)-CHOOSE(WEEKDAY(DATE(C$5,C$7+1,1),2),3,4,5,6,7,1,2)","v":"2013-01-25"},{"$f":"DATE(D$5,D$7+1,1)-CHOOSE(WEEKDAY(DATE(D$5,D$7+1,1),2),3,4,5,6,7,1,2)","v":"2012-02-24"},{"$f":"DATE(E$5,E$7+1,1)-CHOOSE(WEEKDAY(DATE(E$5,E$7+1,1),2),3,4,5,6,7,1,2)","v":"2012-03-30"}]
["Fecha del último Sábado del mes",null,{"$f":"DATE(C$5,C$7+1,1)-CHOOSE(WEEKDAY(DATE($C$5,C$7+1,1),2),2,3,4,5,6,7,1)","v":"2013-01-26"},{"$f":"DATE(D$5,D$7+1,1)-CHOOSE(WEEKDAY(DATE($C$5,D$7+1,1),2),2,3,4,5,6,7,1)","v":"2012-02-24"},{"$f":"DATE(E$5,E$7+1,1)-CHOOSE(WEEKDAY(DATE($C$5,E$7+1,1),2),2,3,4,5,6,7,1)","v":"2012-03-30"}]
["Fecha del último Domingo del mes",null,{"$f":"DATE(C$5,C$7+1,1)-CHOOSE(WEEKDAY(DATE(C$5,C$7+1,1),2),1,2,3,4,5,6,7)","v":"2013-01-27"},{"$f":"DATE(D$5,D$7+1,1)-CHOOSE(WEEKDAY(DATE(D$5,D$7+1,1),2),1,2,3,4,5,6,7)","v":"2012-02-26"},{"$f":"DATE(E$5,E$7+1,1)-CHOOSE(WEEKDAY(DATE(E$5,E$7+1,1),2),1,2,3,4,5,6,7)","v":"2012-03-25"}]
[]
["La fórmulas están diseñadas para arrastrarlas en cualquier dirección devolviendo siempre el resultado correcto."]
[]
[{"$f":"\"Formula for \"&A8&\" in \"&ADDRESS(ROW(C8),COLUMN(C8),4)&\" es >>>    \"&GETFORMULA(C8)","v":"Formula for Fecha del último Lunes del mes in C8 es >>>    =FECHA(C$5;C$7+1;1)-ELEGIR(DIASEM(FECHA(C$5;C$7+1;1);2);7;1;2;3;4;5;6)"}]
[{"$f":"\"Formula for \"&A9&\" in \"&ADDRESS(ROW(C9),COLUMN(C9),4)&\" es >>>    \"&GETFORMULA(C9)","v":"Formula for Fecha del último Martes del mes in C9 es >>>    =FECHA(C$5;C$7+1;1)-ELEGIR(DIASEM(FECHA(C$5;C$7+1;1);2);6;7;1;2;3;4;5)"}]
[{"$f":"\"Formula for \"&A10&\" in \"&ADDRESS(ROW(C10),COLUMN(C10),4)&\" es >>>    \"&GETFORMULA(C10)","v":"Formula for Fecha del último Miércoles del mes in C10 es >>>    =FECHA(C$5;C$7+1;1)-ELEGIR(DIASEM(FECHA(C$5;C$7+1;1);2);5;6;7;1;2;3;4)"}]
[{"$f":"\"Formula for \"&A11&\" in \"&ADDRESS(ROW(C11),COLUMN(C11),4)&\" es >>>    \"&GETFORMULA(C11)","v":"Formula for Fecha del último Jueves del mes in C11 es >>>    =FECHA(C$5;C$7+1;1)-ELEGIR(DIASEM(FECHA(C$5;C$7+1;1);2);4;5;6;7;1;2;3)"}]
[{"$f":"\"Formula for \"&A12&\" in \"&ADDRESS(ROW(C12),COLUMN(C12),4)&\" es >>>    \"&GETFORMULA(C12)","v":"Formula for Fecha del último Viernes del mes in C12 es >>>    =FECHA(C$5;C$7+1;1)-ELEGIR(DIASEM(FECHA(C$5;C$7+1;1);2);3;4;5;6;7;1;2)"}]
[{"$f":"\"Formula for \"&A13&\" in \"&ADDRESS(ROW(C13),COLUMN(C13),4)&\" es >>>    \"&GETFORMULA(C13)","v":"Formula for Fecha del último Sábado del mes in C13 es >>>    =FECHA(C$5;C$7+1;1)-ELEGIR(DIASEM(FECHA($C$5;C$7+1;1);2);2;3;4;5;6;7;1)"}]
[{"$f":"\"Formula for \"&A14&\" in \"&ADDRESS(ROW(C14),COLUMN(C14),4)&\" es >>>    \"&GETFORMULA(C14)","v":"Formula for Fecha del último Domingo del mes in C14 es >>>    =FECHA(C$5;C$7+1;1)-ELEGIR(DIASEM(FECHA(C$5;C$7+1;1);2);1;2;3;4;5;6;7)"}]
[]
["Estas fórmulas son combinaciones de la función FECHA con la función ELEGIR."]
[]
["Tabla Nombre Meses (usada en las siguientes fórmulas con BUSCARV)"]
["Ene","Enero",1]
["Feb","Febrero",2]
["Mar","Marzo",3]
["Abr","Abril",4]
["May","Mayo",5]
["Jun","Junio",6]
["Jul","Julio",7]
["Ago","Agosto",8]
["Sep","Septiembre",9]
["Oct","Octubre",10]
["Nov","Noviembre",11]
["Dic","Diciembre",12]