{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["设置","1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月","假日"],"not_rendered":{"defined_names":20},"read":"whole","date_system":"1900"}

{"sheet":"设置","index":0,"n_rows":34,"n_cols":32,"rows_kept":34,"merged":[[1,17,2,23],[3,1,3,7],[3,8,3,10],[3,17,7,31],[4,1,4,7],[5,1,5,7],[8,1,8,7],[8,9,8,15],[8,17,8,23],[8,25,8,31],[9,1,9,7],[9,9,9,15],[9,17,9,23],[9,25,9,31],[17,1,17,7],[17,9,17,15],[17,17,17,23],[17,25,17,31],[18,1,18,7],[18,9,18,15],[18,17,18,23],[18,25,18,31],[26,1,26,7],[26,9,26,15],[26,17,26,23],[26,25,26,31],[27,1,27,7],[27,9,27,15],[27,17,27,23],[27,25,27,31]]}
[]
[null,"日历设置",{"$nulls":15},"年份"]
[]
[null,"周始日",{"$nulls":6},"星期日",{"$nulls":8},{"$f":"YEAR(TODAY())","v":2018}]
[null,"显示假日",{"$nulls":6},true]
[null,"显示已执行",{"$nulls":6},true]
[{"$nulls":8},{"$f":"IF(显示假日,已执行,显示假日)","v":true}]
[null,"年度视图"]
[null,{"$f":"DATE(日历年份,1,1)","v":"2018-01-01"},{"$nulls":7},{"$f":"DATE(日历年份,2,1)","v":"2018-02-01"},{"$nulls":7},{"$f":"DATE(日历年份,3,1)","v":"2018-03-01"},{"$nulls":7},{"$f":"DATE(日历年份,4,1)","v":"2018-04-01"}]
[null,{"$f":"UPPER(TEXT(B9,\"M月\"))","v":"1月"},{"$nulls":7},{"$f":"UPPER(TEXT(J9,\"M月\"))","v":"2月"},{"$nulls":7},{"$f":"UPPER(TEXT(R9,\"M月\"))","v":"3月"},{"$nulls":7},{"$f":"UPPER(TEXT(Z9,\"M月\"))","v":"4月"}]
[1,{"$f":"日期+DATE(日历年份,MONTH($B$9),1)-WEEKDAY(DATE(日历年份,MONTH($B$9),1),(周始日=\"星期一\")+1)+$A11*7-6","v":"2017-12-31"},"2018-01-01","2018-01-02","2018-01-03","2018-01-04","2018-01-05","2018-01-06",null,{"$f":"日期+DATE(日历年份,MONTH($J$9),1)-WEEKDAY(DATE(日历年份,MONTH($J$9),1),(周始日=\"星期一\")+1)+$A11*7-6","v":"2018-01-28"},"2018-01-29","2018-01-30","2018-01-31","2018-02-01","2018-02-02","2018-02-03",null,{"$f":"日期+DATE(日历年份,MONTH($R$9),1)-WEEKDAY(DATE(日历年份,MONTH($R$9),1),(周始日=\"星期一\")+1)+$A11*7-6","v":"2018-02-25"},"2018-02-26","2018-02-27","2018-02-28","2018-03-01","2018-03-02","2018-03-03",null,{"$f":"日期+DATE(日历年份,MONTH($Z$9),1)-WEEKDAY(DATE(日历年份,MONTH($Z$9),1),(周始日=\"星期一\")+1)+$A11*7-6","v":"2018-04-01"},"2018-04-02","2018-04-03","2018-04-04","2018-04-05","2018-04-06","2018-04-07"]
[2,{"$f":"日期+DATE(日历年份,MONTH($B$9),1)-WEEKDAY(DATE(日历年份,MONTH($B$9),1),(周始日=\"星期一\")+1)+$A12*7-6","v":"2018-01-07"},"2018-01-08","2018-01-09","2018-01-10","2018-01-11","2018-01-12","2018-01-13",null,{"$f":"日期+DATE(日历年份,MONTH($J$9),1)-WEEKDAY(DATE(日历年份,MONTH($J$9),1),(周始日=\"星期一\")+1)+$A12*7-6","v":"2018-02-04"},"2018-02-05","2018-02-06","2018-02-07","2018-02-08","2018-02-09","2018-02-10",null,{"$f":"日期+DATE(日历年份,MONTH($R$9),1)-WEEKDAY(DATE(日历年份,MONTH($R$9),1),(周始日=\"星期一\")+1)+$A12*7-6","v":"2018-03-04"},"2018-03-05","2018-03-06","2018-03-07","2018-03-08","2018-03-09","2018-03-10",null,{"$f":"日期+DATE(日历年份,MONTH($Z$9),1)-WEEKDAY(DATE(日历年份,MONTH($Z$9),1),(周始日=\"星期一\")+1)+$A12*7-6","v":"2018-04-08"},"2018-04-09","2018-04-10","2018-04-11","2018-04-12","2018-04-13","2018-04-14"]
[3,{"$f":"日期+DATE(日历年份,MONTH($B$9),1)-WEEKDAY(DATE(日历年份,MONTH($B$9),1),(周始日=\"星期一\")+1)+$A13*7-6","v":"2018-01-14"},"2018-01-15","2018-01-16","2018-01-17","2018-01-18","2018-01-19","2018-01-20",null,{"$f":"日期+DATE(日历年份,MONTH($J$9),1)-WEEKDAY(DATE(日历年份,MONTH($J$9),1),(周始日=\"星期一\")+1)+$A13*7-6","v":"2018-02-11"},"2018-02-12","2018-02-13","2018-02-14","2018-02-15","2018-02-16","2018-02-17",null,{"$f":"日期+DATE(日历年份,MONTH($R$9),1)-WEEKDAY(DATE(日历年份,MONTH($R$9),1),(周始日=\"星期一\")+1)+$A13*7-6","v":"2018-03-11"},"2018-03-12","2018-03-13","2018-03-14","2018-03-15","2018-03-16","2018-03-17",null,{"$f":"日期+DATE(日历年份,MONTH($Z$9),1)-WEEKDAY(DATE(日历年份,MONTH($Z$9),1),(周始日=\"星期一\")+1)+$A13*7-6","v":"2018-04-15"},"2018-04-16","2018-04-17","2018-04-18","2018-04-19","2018-04-20","2018-04-21"]
[4,{"$f":"日期+DATE(日历年份,MONTH($B$9),1)-WEEKDAY(DATE(日历年份,MONTH($B$9),1),(周始日=\"星期一\")+1)+$A14*7-6","v":"2018-01-21"},"2018-01-22","2018-01-23","2018-01-24","2018-01-25","2018-01-26","2018-01-27",null,{"$f":"日期+DATE(日历年份,MONTH($J$9),1)-WEEKDAY(DATE(日历年份,MONTH($J$9),1),(周始日=\"星期一\")+1)+$A14*7-6","v":"2018-02-18"},"2018-02-19","2018-02-20","2018-02-21","2018-02-22","2018-02-23","2018-02-24",null,{"$f":"日期+DATE(日历年份,MONTH($R$9),1)-WEEKDAY(DATE(日历年份,MONTH($R$9),1),(周始日=\"星期一\")+1)+$A14*7-6","v":"2018-03-18"},"2018-03-19","2018-03-20","2018-03-21","2018-03-22","2018-03-23","2018-03-24",null,{"$f":"日期+DATE(日历年份,MONTH($Z$9),1)-WEEKDAY(DATE(日历年份,MONTH($Z$9),1),(周始日=\"星期一\")+1)+$A14*7-6","v":"2018-04-22"},"2018-04-23","2018-04-24","2018-04-25","2018-04-26","2018-04-27","2018-04-28"]
[5,{"$f":"日期+DATE(日历年份,MONTH($B$9),1)-WEEKDAY(DATE(日历年份,MONTH($B$9),1),(周始日=\"星期一\")+1)+$A15*7-6","v":"2018-01-28"},"2018-01-29","2018-01-30","2018-01-31","2018-02-01","2018-02-02","2018-02-03",null,{"$f":"日期+DATE(日历年份,MONTH($J$9),1)-WEEKDAY(DATE(日历年份,MONTH($J$9),1),(周始日=\"星期一\")+1)+$A15*7-6","v":"2018-02-25"},"2018-02-26","2018-02-27","2018-02-28","2018-03-01","2018-03-02","2018-03-03",null,{"$f":"日期+DATE(日历年份,MONTH($R$9),1)-WEEKDAY(DATE(日历年份,MONTH($R$9),1),(周始日=\"星期一\")+1)+$A15*7-6","v":"2018-03-25"},"2018-03-26","2018-03-27","2018-03-28","2018-03-29","2018-03-30","2018-03-31",null,{"$f":"日期+DATE(日历年份,MONTH($Z$9),1)-WEEKDAY(DATE(日历年份,MONTH($Z$9),1),(周始日=\"星期一\")+1)+$A15*7-6","v":"2018-04-29"},"2018-04-30","2018-05-01","2018-05-02","2018-05-03","2018-05-04","2018-05-05"]
[6,{"$f":"日期+DATE(日历年份,MONTH($B$9),1)-WEEKDAY(DATE(日历年份,MONTH($B$9),1),(周始日=\"星期一\")+1)+$A16*7-6","v":"2018-02-04"},"2018-02-05","2018-02-06","2018-02-07","2018-02-08","2018-02-09","2018-02-10",null,{"$f":"日期+DATE(日历年份,MONTH($J$9),1)-WEEKDAY(DATE(日历年份,MONTH($J$9),1),(周始日=\"星期一\")+1)+$A16*7-6","v":"2018-03-04"},"2018-03-05","2018-03-06","2018-03-07","2018-03-08","2018-03-09","2018-03-10",null,{"$f":"日期+DATE(日历年份,MONTH($R$9),1)-WEEKDAY(DATE(日历年份,MONTH($R$9),1),(周始日=\"星期一\")+1)+$A16*7-6","v":"2018-04-01"},"2018-04-02","2018-04-03","2018-04-04","2018-04-05","2018-04-06","2018-04-07",null,{"$f":"日期+DATE(日历年份,MONTH($Z$9),1)-WEEKDAY(DATE(日历年份,MONTH($Z$9),1),(周始日=\"星期一\")+1)+$A16*7-6","v":"2018-05-06"},"2018-05-07","2018-05-08","2018-05-09","2018-05-10","2018-05-11","2018-05-12"]
[]
[null,{"$f":"DATE(日历年份,5,1)","v":"2018-05-01"},{"$nulls":7},{"$f":"DATE(日历年份,6,1)","v":"2018-06-01"},{"$nulls":7},{"$f":"DATE(日历年份,7,1)","v":"2018-07-01"},{"$nulls":7},{"$f":"DATE(日历年份,8,1)","v":"2018-08-01"}]
[null,{"$f":"UPPER(TEXT(B18,\"M月\"))","v":"5月"},{"$nulls":7},{"$f":"UPPER(TEXT(J18,\"M月\"))","v":"6月"},{"$nulls":7},{"$f":"UPPER(TEXT(R18,\"M月\"))","v":"7月"},{"$nulls":7},{"$f":"UPPER(TEXT(Z18,\"M月\"))","v":"8月"}]
[1,{"$f":"日期+DATE(日历年份,MONTH($B$18),1)-WEEKDAY(DATE(日历年份,MONTH($B$18),1),(周始日=\"星期一\")+1)+$A20*7-6","v":"2018-04-29"},"2018-04-30","2018-05-01","2018-05-02","2018-05-03","2018-05-04","2018-05-05",null,{"$f":"日期+DATE(日历年份,MONTH($J$18),1)-WEEKDAY(DATE(日历年份,MONTH($J$18),1),(周始日=\"星期一\")+1)+$A20*7-6","v":"2018-05-27"},"2018-05-28","2018-05-29","2018-05-30","2018-05-31","2018-06-01","2018-06-02",null,{"$f":"日期+DATE(日历年份,MONTH($R$18),1)-WEEKDAY(DATE(日历年份,MONTH($R$18),1),(周始日=\"星期一\")+1)+$A20*7-6","v":"2018-07-01"},"2018-07-02","2018-07-03","2018-07-04","2018-07-05","2018-07-06","2018-07-07",null,{"$f":"日期+DATE(日历年份,MONTH($Z$18),1)-WEEKDAY(DATE(日历年份,MONTH($Z$18),1),(周始日=\"星期一\")+1)+$A20*7-6","v":"2018-07-29"},"2018-07-30","2018-07-31","2018-08-01","2018-08-02","2018-08-03","2018-08-04"]
[2,{"$f":"日期+DATE(日历年份,MONTH($B$18),1)-WEEKDAY(DATE(日历年份,MONTH($B$18),1),(周始日=\"星期一\")+1)+$A21*7-6","v":"2018-05-06"},"2018-05-07","2018-05-08","2018-05-09","2018-05-10","2018-05-11","2018-05-12",null,{"$f":"日期+DATE(日历年份,MONTH($J$18),1)-WEEKDAY(DATE(日历年份,MONTH($J$18),1),(周始日=\"星期一\")+1)+$A21*7-6","v":"2018-06-03"},"2018-06-04","2018-06-05","2018-06-06","2018-06-07","2018-06-08","2018-06-09",null,{"$f":"日期+DATE(日历年份,MONTH($R$18),1)-WEEKDAY(DATE(日历年份,MONTH($R$18),1),(周始日=\"星期一\")+1)+$A21*7-6","v":"2018-07-08"},"2018-07-09","2018-07-10","2018-07-11","2018-07-12","2018-07-13","2018-07-14",null,{"$f":"日期+DATE(日历年份,MONTH($Z$18),1)-WEEKDAY(DATE(日历年份,MONTH($Z$18),1),(周始日=\"星期一\")+1)+$A21*7-6","v":"2018-08-05"},"2018-08-06","2018-08-07","2018-08-08","2018-08-09","2018-08-10","2018-08-11"]
[3,{"$f":"日期+DATE(日历年份,MONTH($B$18),1)-WEEKDAY(DATE(日历年份,MONTH($B$18),1),(周始日=\"星期一\")+1)+$A22*7-6","v":"2018-05-13"},"2018-05-14","2018-05-15","2018-05-16","2018-05-17","2018-05-18","2018-05-19",null,{"$f":"日期+DATE(日历年份,MONTH($J$18),1)-WEEKDAY(DATE(日历年份,MONTH($J$18),1),(周始日=\"星期一\")+1)+$A22*7-6","v":"2018-06-10"},"2018-06-11","2018-06-12","2018-06-13","2018-06-14","2018-06-15","2018-06-16",null,{"$f":"日期+DATE(日历年份,MONTH($R$18),1)-WEEKDAY(DATE(日历年份,MONTH($R$18),1),(周始日=\"星期一\")+1)+$A22*7-6","v":"2018-07-15"},"2018-07-16","2018-07-17","2018-07-18","2018-07-19","2018-07-20","2018-07-21",null,{"$f":"日期+DATE(日历年份,MONTH($Z$18),1)-WEEKDAY(DATE(日历年份,MONTH($Z$18),1),(周始日=\"星期一\")+1)+$A22*7-6","v":"2018-08-12"},"2018-08-13","2018-08-14","2018-08-15","2018-08-16","2018-08-17","2018-08-18"]
[4,{"$f":"日期+DATE(日历年份,MONTH($B$18),1)-WEEKDAY(DATE(日历年份,MONTH($B$18),1),(周始日=\"星期一\")+1)+$A23*7-6","v":"2018-05-20"},"2018-05-21","2018-05-22","2018-05-23","2018-05-24","2018-05-25","2018-05-26",null,{"$f":"日期+DATE(日历年份,MONTH($J$18),1)-WEEKDAY(DATE(日历年份,MONTH($J$18),1),(周始日=\"星期一\")+1)+$A23*7-6","v":"2018-06-17"},"2018-06-18","2018-06-19","2018-06-20","2018-06-21","2018-06-22","2018-06-23",null,{"$f":"日期+DATE(日历年份,MONTH($R$18),1)-WEEKDAY(DATE(日历年份,MONTH($R$18),1),(周始日=\"星期一\")+1)+$A23*7-6","v":"2018-07-22"},"2018-07-23","2018-07-24","2018-07-25","2018-07-26","2018-07-27","2018-07-28",null,{"$f":"日期+DATE(日历年份,MONTH($Z$18),1)-WEEKDAY(DATE(日历年份,MONTH($Z$18),1),(周始日=\"星期一\")+1)+$A23*7-6","v":"2018-08-19"},"2018-08-20","2018-08-21","2018-08-22","2018-08-23","2018-08-24","2018-08-25"]
[5,{"$f":"日期+DATE(日历年份,MONTH($B$18),1)-WEEKDAY(DATE(日历年份,MONTH($B$18),1),(周始日=\"星期一\")+1)+$A24*7-6","v":"2018-05-27"},"2018-05-28","2018-05-29","2018-05-30","2018-05-31","2018-06-01","2018-06-02",null,{"$f":"日期+DATE(日历年份,MONTH($J$18),1)-WEEKDAY(DATE(日历年份,MONTH($J$18),1),(周始日=\"星期一\")+1)+$A24*7-6","v":"2018-06-24"},"2018-06-25","2018-06-26","2018-06-27","2018-06-28","2018-06-29","2018-06-30",null,{"$f":"日期+DATE(日历年份,MONTH($R$18),1)-WEEKDAY(DATE(日历年份,MONTH($R$18),1),(周始日=\"星期一\")+1)+$A24*7-6","v":"2018-07-29"},"2018-07-30","2018-07-31","2018-08-01","2018-08-02","2018-08-03","2018-08-04",null,{"$f":"日期+DATE(日历年份,MONTH($Z$18),1)-WEEKDAY(DATE(日历年份,MONTH($Z$18),1),(周始日=\"星期一\")+1)+$A24*7-6","v":"2018-08-26"},"2018-08-27","2018-08-28","2018-08-29","2018-08-30","2018-08-31","2018-09-01"]
[6,{"$f":"日期+DATE(日历年份,MONTH($B$18),1)-WEEKDAY(DATE(日历年份,MONTH($B$18),1),(周始日=\"星期一\")+1)+$A25*7-6","v":"2018-06-03"},"2018-06-04","2018-06-05","2018-06-06","2018-06-07","2018-06-08","2018-06-09",null,{"$f":"日期+DATE(日历年份,MONTH($J$18),1)-WEEKDAY(DATE(日历年份,MONTH($J$18),1),(周始日=\"星期一\")+1)+$A25*7-6","v":"2018-07-01"},"2018-07-02","2018-07-03","2018-07-04","2018-07-05","2018-07-06","2018-07-07",null,{"$f":"日期+DATE(日历年份,MONTH($R$18),1)-WEEKDAY(DATE(日历年份,MONTH($R$18),1),(周始日=\"星期一\")+1)+$A25*7-6","v":"2018-08-05"},"2018-08-06","2018-08-07","2018-08-08","2018-08-09","2018-08-10","2018-08-11",null,{"$f":"日期+DATE(日历年份,MONTH($Z$18),1)-WEEKDAY(DATE(日历年份,MONTH($Z$18),1),(周始日=\"星期一\")+1)+$A25*7-6","v":"2018-09-02"},"2018-09-03","2018-09-04","2018-09-05","2018-09-06","2018-09-07","2018-09-08"]
[]
[null,{"$f":"DATE(日历年份,9,1)","v":"2018-09-01"},{"$nulls":7},{"$f":"DATE(日历年份,10,1)","v":"2018-10-01"},{"$nulls":7},{"$f":"DATE(日历年份,11,1)","v":"2018-11-01"},{"$nulls":7},{"$f":"DATE(日历年份,12,1)","v":"2018-12-01"}]
[null,{"$f":"UPPER(TEXT(B27,\"M月\"))","v":"9月"},{"$nulls":7},{"$f":"UPPER(TEXT(J27,\"M月\"))","v":"10月"},{"$nulls":7},{"$f":"UPPER(TEXT(R27,\"M月\"))","v":"11月"},{"$nulls":7},{"$f":"UPPER(TEXT(Z27,\"M月\"))","v":"12月"}]
[1,{"$f":"日期+DATE(日历年份,MONTH($B$27),1)-WEEKDAY(DATE(日历年份,MONTH($B$27),1),(周始日=\"星期一\")+1)+$A29*7-6","v":"2018-08-26"},"2018-08-27","2018-08-28","2018-08-29","2018-08-30","2018-08-31","2018-09-01",null,{"$f":"日期+DATE(日历年份,MONTH($J$27),1)-WEEKDAY(DATE(日历年份,MONTH($J$27),1),(周始日=\"星期一\")+1)+$A29*7-6","v":"2018-09-30"},"2018-10-01","2018-10-02","2018-10-03","2018-10-04","2018-10-05","2018-10-06",null,{"$f":"日期+DATE(日历年份,MONTH($R$27),1)-WEEKDAY(DATE(日历年份,MONTH($R$27),1),(周始日=\"星期一\")+1)+$A29*7-6","v":"2018-10-28"},"2018-10-29","2018-10-30","2018-10-31","2018-11-01","2018-11-02","2018-11-03",null,{"$f":"日期+DATE(日历年份,MONTH($Z$27),1)-WEEKDAY(DATE(日历年份,MONTH($Z$27),1),(周始日=\"星期一\")+1)+$A29*7-6","v":"2018-11-25"},"2018-11-26","2018-11-27","2018-11-28","2018-11-29","2018-11-30","2018-12-01"]
[2,{"$f":"日期+DATE(日历年份,MONTH($B$27),1)-WEEKDAY(DATE(日历年份,MONTH($B$27),1),(周始日=\"星期一\")+1)+$A30*7-6","v":"2018-09-02"},"2018-09-03","2018-09-04","2018-09-05","2018-09-06","2018-09-07","2018-09-08",null,{"$f":"日期+DATE(日历年份,MONTH($J$27),1)-WEEKDAY(DATE(日历年份,MONTH($J$27),1),(周始日=\"星期一\")+1)+$A30*7-6","v":"2018-10-07"},"2018-10-08","2018-10-09","2018-10-10","2018-10-11","2018-10-12","2018-10-13",null,{"$f":"日期+DATE(日历年份,MONTH($R$27),1)-WEEKDAY(DATE(日历年份,MONTH($R$27),1),(周始日=\"星期一\")+1)+$A30*7-6","v":"2018-11-04"},"2018-11-05","2018-11-06","2018-11-07","2018-11-08","2018-11-09","2018-11-10",null,{"$f":"日期+DATE(日历年份,MONTH($Z$27),1)-WEEKDAY(DATE(日历年份,MONTH($Z$27),1),(周始日=\"星期一\")+1)+$A30*7-6","v":"2018-12-02"},"2018-12-03","2018-12-04","2018-12-05","2018-12-06","2018-12-07","2018-12-08"]
[3,{"$f":"日期+DATE(日历年份,MONTH($B$27),1)-WEEKDAY(DATE(日历年份,MONTH($B$27),1),(周始日=\"星期一\")+1)+$A31*7-6","v":"2018-09-09"},"2018-09-10","2018-09-11","2018-09-12","2018-09-13","2018-09-14","2018-09-15",null,{"$f":"日期+DATE(日历年份,MONTH($J$27),1)-WEEKDAY(DATE(日历年份,MONTH($J$27),1),(周始日=\"星期一\")+1)+$A31*7-6","v":"2018-10-14"},"2018-10-15","2018-10-16","2018-10-17","2018-10-18","2018-10-19","2018-10-20",null,{"$f":"日期+DATE(日历年份,MONTH($R$27),1)-WEEKDAY(DATE(日历年份,MONTH($R$27),1),(周始日=\"星期一\")+1)+$A31*7-6","v":"2018-11-11"},"2018-11-12","2018-11-13","2018-11-14","2018-11-15","2018-11-16","2018-11-17",null,{"$f":"日期+DATE(日历年份,MONTH($Z$27),1)-WEEKDAY(DATE(日历年份,MONTH($Z$27),1),(周始日=\"星期一\")+1)+$A31*7-6","v":"2018-12-09"},"2018-12-10","2018-12-11","2018-12-12","2018-12-13","2018-12-14","2018-12-15"]
[4,{"$f":"日期+DATE(日历年份,MONTH($B$27),1)-WEEKDAY(DATE(日历年份,MONTH($B$27),1),(周始日=\"星期一\")+1)+$A32*7-6","v":"2018-09-16"},"2018-09-17","2018-09-18","2018-09-19","2018-09-20","2018-09-21","2018-09-22",null,{"$f":"日期+DATE(日历年份,MONTH($J$27),1)-WEEKDAY(DATE(日历年份,MONTH($J$27),1),(周始日=\"星期一\")+1)+$A32*7-6","v":"2018-10-21"},"2018-10-22","2018-10-23","2018-10-24","2018-10-25","2018-10-26","2018-10-27",null,{"$f":"日期+DATE(日历年份,MONTH($R$27),1)-WEEKDAY(DATE(日历年份,MONTH($R$27),1),(周始日=\"星期一\")+1)+$A32*7-6","v":"2018-11-18"},"2018-11-19","2018-11-20","2018-11-21","2018-11-22","2018-11-23","2018-11-24",null,{"$f":"日期+DATE(日历年份,MONTH($Z$27),1)-WEEKDAY(DATE(日历年份,MONTH($Z$27),1),(周始日=\"星期一\")+1)+$A32*7-6","v":"2018-12-16"},"2018-12-17","2018-12-18","2018-12-19","2018-12-20","2018-12-21","2018-12-22"]
[5,{"$f":"日期+DATE(日历年份,MONTH($B$27),1)-WEEKDAY(DATE(日历年份,MONTH($B$27),1),(周始日=\"星期一\")+1)+$A33*7-6","v":"2018-09-23"},"2018-09-24","2018-09-25","2018-09-26","2018-09-27","2018-09-28","2018-09-29",null,{"$f":"日期+DATE(日历年份,MONTH($J$27),1)-WEEKDAY(DATE(日历年份,MONTH($J$27),1),(周始日=\"星期一\")+1)+$A33*7-6","v":"2018-10-28"},"2018-10-29","2018-10-30","2018-10-31","2018-11-01","2018-11-02","2018-11-03",null,{"$f":"日期+DATE(日历年份,MONTH($R$27),1)-WEEKDAY(DATE(日历年份,MONTH($R$27),1),(周始日=\"星期一\")+1)+$A33*7-6","v":"2018-11-25"},"2018-11-26","2018-11-27","2018-11-28","2018-11-29","2018-11-30","2018-12-01",null,{"$f":"日期+DATE(日历年份,MONTH($Z$27),1)-WEEKDAY(DATE(日历年份,MONTH($Z$27),1),(周始日=\"星期一\")+1)+$A33*7-6","v":"2018-12-23"},"2018-12-24","2018-12-25","2018-12-26","2018-12-27","2018-12-28","2018-12-29"]
[6,{"$f":"日期+DATE(日历年份,MONTH($B$27),1)-WEEKDAY(DATE(日历年份,MONTH($B$27),1),(周始日=\"星期一\")+1)+$A34*7-6","v":"2018-09-30"},"2018-10-01","2018-10-02","2018-10-03","2018-10-04","2018-10-05","2018-10-06",null,{"$f":"日期+DATE(日历年份,MONTH($J$27),1)-WEEKDAY(DATE(日历年份,MONTH($J$27),1),(周始日=\"星期一\")+1)+$A34*7-6","v":"2018-11-04"},"2018-11-05","2018-11-06","2018-11-07","2018-11-08","2018-11-09","2018-11-10",null,{"$f":"日期+DATE(日历年份,MONTH($R$27),1)-WEEKDAY(DATE(日历年份,MONTH($R$27),1),(周始日=\"星期一\")+1)+$A34*7-6","v":"2018-12-02"},"2018-12-03","2018-12-04","2018-12-05","2018-12-06","2018-12-07","2018-12-08",null,{"$f":"日期+DATE(日历年份,MONTH($Z$27),1)-WEEKDAY(DATE(日历年份,MONTH($Z$27),1),(周始日=\"星期一\")+1)+$A34*7-6","v":"2018-12-30"},"2018-12-31","2019-01-01","2019-01-02","2019-01-03","2019-01-04","2019-01-05"]

{"sheet":"1月","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2018-01-14"}]
[]
[null,{"$f":"周始日","v":"星期日"},{"$f":"UPPER(TEXT(C5,\"aaaa\"))","v":"星期一"},"星期二","星期三","星期四","星期五","星期六"]
[null,{"$f":"日期+DATE(日历年份,1,1)-WEEKDAY(DATE(日历年份,1,1),(周始日=\"星期一\")+1)+1","v":"2017-12-31"},"2018-01-01","2018-01-02","2018-01-03","2018-01-04","2018-01-05","2018-01-06"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":"新年"},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,1,1)-WEEKDAY(DATE(日历年份,1,1),(周始日=\"星期一\")+1)+8","v":"2018-01-07"},"2018-01-08","2018-01-09","2018-01-10","2018-01-11","2018-01-12","2018-01-13"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,1,1)-WEEKDAY(DATE(日历年份,1,1),(周始日=\"星期一\")+1)+15","v":"2018-01-14"},"2018-01-15","2018-01-16","2018-01-17","2018-01-18","2018-01-19","2018-01-20"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,1,1)-WEEKDAY(DATE(日历年份,1,1),(周始日=\"星期一\")+1)+22","v":"2018-01-21"},"2018-01-22","2018-01-23","2018-01-24","2018-01-25","2018-01-26","2018-01-27"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,1,1)-WEEKDAY(DATE(日历年份,1,1),(周始日=\"星期一\")+1)+29","v":"2018-01-28"},"2018-01-29","2018-01-30","2018-01-31","2018-02-01","2018-02-02","2018-02-03"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,1,1)-WEEKDAY(DATE(日历年份,1,1),(周始日=\"星期一\")+1)+36","v":"2018-02-04"},"2018-02-05","备注"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"2月","index":2,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2018-02-11"}]
[]
[null,{"$f":"周始日","v":"星期日"},{"$f":"UPPER(TEXT(C5,\"aaaa\"))","v":"星期一"},"星期二","星期三","星期四","星期五","星期六"]
[null,{"$f":"日期+DATE(日历年份,2,1)-WEEKDAY(DATE(日历年份,2,1),(周始日=\"星期一\")+1)+1","v":"2018-01-28"},"2018-01-29","2018-01-30","2018-01-31","2018-02-01","2018-02-02","2018-02-03"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,2,1)-WEEKDAY(DATE(日历年份,2,1),(周始日=\"星期一\")+1)+8","v":"2018-02-04"},"2018-02-05","2018-02-06","2018-02-07","2018-02-08","2018-02-09","2018-02-10"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,2,1)-WEEKDAY(DATE(日历年份,2,1),(周始日=\"星期一\")+1)+15","v":"2018-02-11"},"2018-02-12","2018-02-13","2018-02-14","2018-02-15","2018-02-16","2018-02-17"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,2,1)-WEEKDAY(DATE(日历年份,2,1),(周始日=\"星期一\")+1)+22","v":"2018-02-18"},"2018-02-19","2018-02-20","2018-02-21","2018-02-22","2018-02-23","2018-02-24"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":"总统日"},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,2,1)-WEEKDAY(DATE(日历年份,2,1),(周始日=\"星期一\")+1)+29","v":"2018-02-25"},"2018-02-26","2018-02-27","2018-02-28","2018-03-01","2018-03-02","2018-03-03"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,2,1)-WEEKDAY(DATE(日历年份,2,1),(周始日=\"星期一\")+1)+36","v":"2018-03-04"},"2018-03-05","备注"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"3月","index":3,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2018-03-11"}]
[]
[null,{"$f":"周始日","v":"星期日"},{"$f":"UPPER(TEXT(C5,\"aaaa\"))","v":"星期一"},"星期二","星期三","星期四","星期五","星期六"]
[null,{"$f":"日期+DATE(日历年份,3,1)-WEEKDAY(DATE(日历年份,3,1),(周始日=\"星期一\")+1)+1","v":"2018-02-25"},"2018-02-26","2018-02-27","2018-02-28","2018-03-01","2018-03-02","2018-03-03"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,3,1)-WEEKDAY(DATE(日历年份,3,1),(周始日=\"星期一\")+1)+8","v":"2018-03-04"},"2018-03-05","2018-03-06","2018-03-07","2018-03-08","2018-03-09","2018-03-10"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,3,1)-WEEKDAY(DATE(日历年份,3,1),(周始日=\"星期一\")+1)+15","v":"2018-03-11"},"2018-03-12","2018-03-13","2018-03-14","2018-03-15","2018-03-16","2018-03-17"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,3,1)-WEEKDAY(DATE(日历年份,3,1),(周始日=\"星期一\")+1)+22","v":"2018-03-18"},"2018-03-19","2018-03-20","2018-03-21","2018-03-22","2018-03-23","2018-03-24"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,3,1)-WEEKDAY(DATE(日历年份,3,1),(周始日=\"星期一\")+1)+29","v":"2018-03-25"},"2018-03-26","2018-03-27","2018-03-28","2018-03-29","2018-03-30","2018-03-31"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,3,1)-WEEKDAY(DATE(日历年份,3,1),(周始日=\"星期一\")+1)+36","v":"2018-04-01"},"2018-04-02","备注"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"4月","index":4,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2018-04-15"}]
[]
[null,{"$f":"周始日","v":"星期日"},{"$f":"UPPER(TEXT(C5,\"aaaa\"))","v":"星期一"},"星期二","星期三","星期四","星期五","星期六"]
[null,{"$f":"日期+DATE(日历年份,4,1)-WEEKDAY(DATE(日历年份,4,1),(周始日=\"星期一\")+1)+1","v":"2018-04-01"},"2018-04-02","2018-04-03","2018-04-04","2018-04-05","2018-04-06","2018-04-07"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,4,1)-WEEKDAY(DATE(日历年份,4,1),(周始日=\"星期一\")+1)+8","v":"2018-04-08"},"2018-04-09","2018-04-10","2018-04-11","2018-04-12","2018-04-13","2018-04-14"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,4,1)-WEEKDAY(DATE(日历年份,4,1),(周始日=\"星期一\")+1)+15","v":"2018-04-15"},"2018-04-16","2018-04-17","2018-04-18","2018-04-19","2018-04-20","2018-04-21"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,4,1)-WEEKDAY(DATE(日历年份,4,1),(周始日=\"星期一\")+1)+22","v":"2018-04-22"},"2018-04-23","2018-04-24","2018-04-25","2018-04-26","2018-04-27","2018-04-28"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,4,1)-WEEKDAY(DATE(日历年份,4,1),(周始日=\"星期一\")+1)+29","v":"2018-04-29"},"2018-04-30","2018-05-01","2018-05-02","2018-05-03","2018-05-04","2018-05-05"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,4,1)-WEEKDAY(DATE(日历年份,4,1),(周始日=\"星期一\")+1)+36","v":"2018-05-06"},"2018-05-07","备注"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"5月","index":5,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2018-05-13"}]
[]
[null,{"$f":"周始日","v":"星期日"},{"$f":"UPPER(TEXT(C5,\"aaaa\"))","v":"星期一"},"星期二","星期三","星期四","星期五","星期六"]
[null,{"$f":"日期+DATE(日历年份,5,1)-WEEKDAY(DATE(日历年份,5,1),(周始日=\"星期一\")+1)+1","v":"2018-04-29"},"2018-04-30","2018-05-01","2018-05-02","2018-05-03","2018-05-04","2018-05-05"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,5,1)-WEEKDAY(DATE(日历年份,5,1),(周始日=\"星期一\")+1)+8","v":"2018-05-06"},"2018-05-07","2018-05-08","2018-05-09","2018-05-10","2018-05-11","2018-05-12"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,5,1)-WEEKDAY(DATE(日历年份,5,1),(周始日=\"星期一\")+1)+15","v":"2018-05-13"},"2018-05-14","2018-05-15","2018-05-16","2018-05-17","2018-05-18","2018-05-19"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,5,1)-WEEKDAY(DATE(日历年份,5,1),(周始日=\"星期一\")+1)+22","v":"2018-05-20"},"2018-05-21","2018-05-22","2018-05-23","2018-05-24","2018-05-25","2018-05-26"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,5,1)-WEEKDAY(DATE(日历年份,5,1),(周始日=\"星期一\")+1)+29","v":"2018-05-27"},"2018-05-28","2018-05-29","2018-05-30","2018-05-31","2018-06-01","2018-06-02"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":"国殇日"},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,5,1)-WEEKDAY(DATE(日历年份,5,1),(周始日=\"星期一\")+1)+36","v":"2018-06-03"},"2018-06-04","备注"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"6月","index":6,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2018-06-10"}]
[]
[null,{"$f":"周始日","v":"星期日"},{"$f":"UPPER(TEXT(C5,\"aaaa\"))","v":"星期一"},"星期二","星期三","星期四","星期五","星期六"]
[null,{"$f":"日期+DATE(日历年份,6,1)-WEEKDAY(DATE(日历年份,6,1),(周始日=\"星期一\")+1)+1","v":"2018-05-27"},"2018-05-28","2018-05-29","2018-05-30","2018-05-31","2018-06-01","2018-06-02"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,6,1)-WEEKDAY(DATE(日历年份,6,1),(周始日=\"星期一\")+1)+8","v":"2018-06-03"},"2018-06-04","2018-06-05","2018-06-06","2018-06-07","2018-06-08","2018-06-09"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,6,1)-WEEKDAY(DATE(日历年份,6,1),(周始日=\"星期一\")+1)+15","v":"2018-06-10"},"2018-06-11","2018-06-12","2018-06-13","2018-06-14","2018-06-15","2018-06-16"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,6,1)-WEEKDAY(DATE(日历年份,6,1),(周始日=\"星期一\")+1)+22","v":"2018-06-17"},"2018-06-18","2018-06-19","2018-06-20","2018-06-21","2018-06-22","2018-06-23"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,6,1)-WEEKDAY(DATE(日历年份,6,1),(周始日=\"星期一\")+1)+29","v":"2018-06-24"},"2018-06-25","2018-06-26","2018-06-27","2018-06-28","2018-06-29","2018-06-30"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,6,1)-WEEKDAY(DATE(日历年份,6,1),(周始日=\"星期一\")+1)+36","v":"2018-07-01"},"2018-07-02","备注"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"7月","index":7,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2018-07-15"}]
[]
[null,{"$f":"周始日","v":"星期日"},{"$f":"UPPER(TEXT(C5,\"aaaa\"))","v":"星期一"},"星期二","星期三","星期四","星期五","星期六"]
[null,{"$f":"日期+DATE(日历年份,7,1)-WEEKDAY(DATE(日历年份,7,1),(周始日=\"星期一\")+1)+1","v":"2018-07-01"},"2018-07-02","2018-07-03","2018-07-04","2018-07-05","2018-07-06","2018-07-07"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":"独立日"},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,7,1)-WEEKDAY(DATE(日历年份,7,1),(周始日=\"星期一\")+1)+8","v":"2018-07-08"},"2018-07-09","2018-07-10","2018-07-11","2018-07-12","2018-07-13","2018-07-14"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,7,1)-WEEKDAY(DATE(日历年份,7,1),(周始日=\"星期一\")+1)+15","v":"2018-07-15"},"2018-07-16","2018-07-17","2018-07-18","2018-07-19","2018-07-20","2018-07-21"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,7,1)-WEEKDAY(DATE(日历年份,7,1),(周始日=\"星期一\")+1)+22","v":"2018-07-22"},"2018-07-23","2018-07-24","2018-07-25","2018-07-26","2018-07-27","2018-07-28"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,7,1)-WEEKDAY(DATE(日历年份,7,1),(周始日=\"星期一\")+1)+29","v":"2018-07-29"},"2018-07-30","2018-07-31","2018-08-01","2018-08-02","2018-08-03","2018-08-04"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,7,1)-WEEKDAY(DATE(日历年份,7,1),(周始日=\"星期一\")+1)+36","v":"2018-08-05"},"2018-08-06","备注"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"8月","index":8,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2018-08-12"}]
[]
[null,{"$f":"周始日","v":"星期日"},{"$f":"UPPER(TEXT(C5,\"aaaa\"))","v":"星期一"},"星期二","星期三","星期四","星期五","星期六"]
[null,{"$f":"日期+DATE(日历年份,8,1)-WEEKDAY(DATE(日历年份,8,1),(周始日=\"星期一\")+1)+1","v":"2018-07-29"},"2018-07-30","2018-07-31","2018-08-01","2018-08-02","2018-08-03","2018-08-04"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,8,1)-WEEKDAY(DATE(日历年份,8,1),(周始日=\"星期一\")+1)+8","v":"2018-08-05"},"2018-08-06","2018-08-07","2018-08-08","2018-08-09","2018-08-10","2018-08-11"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,8,1)-WEEKDAY(DATE(日历年份,8,1),(周始日=\"星期一\")+1)+15","v":"2018-08-12"},"2018-08-13","2018-08-14","2018-08-15","2018-08-16","2018-08-17","2018-08-18"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,8,1)-WEEKDAY(DATE(日历年份,8,1),(周始日=\"星期一\")+1)+22","v":"2018-08-19"},"2018-08-20","2018-08-21","2018-08-22","2018-08-23","2018-08-24","2018-08-25"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,8,1)-WEEKDAY(DATE(日历年份,8,1),(周始日=\"星期一\")+1)+29","v":"2018-08-26"},"2018-08-27","2018-08-28","2018-08-29","2018-08-30","2018-08-31","2018-09-01"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,8,1)-WEEKDAY(DATE(日历年份,8,1),(周始日=\"星期一\")+1)+36","v":"2018-09-02"},"2018-09-03","备注"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":"劳动节"}]

{"sheet":"9月","index":9,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2018-09-09"}]
[]
[null,{"$f":"周始日","v":"星期日"},{"$f":"UPPER(TEXT(C5,\"aaaa\"))","v":"星期一"},"星期二","星期三","星期四","星期五","星期六"]
[null,{"$f":"日期+DATE(日历年份,9,1)-WEEKDAY(DATE(日历年份,9,1),(周始日=\"星期一\")+1)+1","v":"2018-08-26"},"2018-08-27","2018-08-28","2018-08-29","2018-08-30","2018-08-31","2018-09-01"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,9,1)-WEEKDAY(DATE(日历年份,9,1),(周始日=\"星期一\")+1)+8","v":"2018-09-02"},"2018-09-03","2018-09-04","2018-09-05","2018-09-06","2018-09-07","2018-09-08"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":"劳动节"},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,9,1)-WEEKDAY(DATE(日历年份,9,1),(周始日=\"星期一\")+1)+15","v":"2018-09-09"},"2018-09-10","2018-09-11","2018-09-12","2018-09-13","2018-09-14","2018-09-15"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,9,1)-WEEKDAY(DATE(日历年份,9,1),(周始日=\"星期一\")+1)+22","v":"2018-09-16"},"2018-09-17","2018-09-18","2018-09-19","2018-09-20","2018-09-21","2018-09-22"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,9,1)-WEEKDAY(DATE(日历年份,9,1),(周始日=\"星期一\")+1)+29","v":"2018-09-23"},"2018-09-24","2018-09-25","2018-09-26","2018-09-27","2018-09-28","2018-09-29"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,9,1)-WEEKDAY(DATE(日历年份,9,1),(周始日=\"星期一\")+1)+36","v":"2018-09-30"},"2018-10-01","备注"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"10月","index":10,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2018-10-14"}]
[]
[null,{"$f":"周始日","v":"星期日"},{"$f":"UPPER(TEXT(C5,\"aaaa\"))","v":"星期一"},"星期二","星期三","星期四","星期五","星期六"]
[null,{"$f":"日期+DATE(日历年份,10,1)-WEEKDAY(DATE(日历年份,10,1),(周始日=\"星期一\")+1)+1","v":"2018-09-30"},"2018-10-01","2018-10-02","2018-10-03","2018-10-04","2018-10-05","2018-10-06"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,10,1)-WEEKDAY(DATE(日历年份,10,1),(周始日=\"星期一\")+1)+8","v":"2018-10-07"},"2018-10-08","2018-10-09","2018-10-10","2018-10-11","2018-10-12","2018-10-13"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":"哥伦布节"},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,10,1)-WEEKDAY(DATE(日历年份,10,1),(周始日=\"星期一\")+1)+15","v":"2018-10-14"},"2018-10-15","2018-10-16","2018-10-17","2018-10-18","2018-10-19","2018-10-20"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,10,1)-WEEKDAY(DATE(日历年份,10,1),(周始日=\"星期一\")+1)+22","v":"2018-10-21"},"2018-10-22","2018-10-23","2018-10-24","2018-10-25","2018-10-26","2018-10-27"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,10,1)-WEEKDAY(DATE(日历年份,10,1),(周始日=\"星期一\")+1)+29","v":"2018-10-28"},"2018-10-29","2018-10-30","2018-10-31","2018-11-01","2018-11-02","2018-11-03"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,10,1)-WEEKDAY(DATE(日历年份,10,1),(周始日=\"星期一\")+1)+36","v":"2018-11-04"},"2018-11-05","备注"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"11月","index":11,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2018-11-11"}]
[]
[null,{"$f":"周始日","v":"星期日"},{"$f":"UPPER(TEXT(C5,\"aaaa\"))","v":"星期一"},"星期二","星期三","星期四","星期五","星期六"]
[null,{"$f":"日期+DATE(日历年份,11,1)-WEEKDAY(DATE(日历年份,11,1),(周始日=\"星期一\")+1)+1","v":"2018-10-28"},"2018-10-29","2018-10-30","2018-10-31","2018-11-01","2018-11-02","2018-11-03"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,11,1)-WEEKDAY(DATE(日历年份,11,1),(周始日=\"星期一\")+1)+8","v":"2018-11-04"},"2018-11-05","2018-11-06","2018-11-07","2018-11-08","2018-11-09","2018-11-10"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,11,1)-WEEKDAY(DATE(日历年份,11,1),(周始日=\"星期一\")+1)+15","v":"2018-11-11"},"2018-11-12","2018-11-13","2018-11-14","2018-11-15","2018-11-16","2018-11-17"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":"退伍军人节"},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,11,1)-WEEKDAY(DATE(日历年份,11,1),(周始日=\"星期一\")+1)+22","v":"2018-11-18"},"2018-11-19","2018-11-20","2018-11-21","2018-11-22","2018-11-23","2018-11-24"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":"感恩节"},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,11,1)-WEEKDAY(DATE(日历年份,11,1),(周始日=\"星期一\")+1)+29","v":"2018-11-25"},"2018-11-26","2018-11-27","2018-11-28","2018-11-29","2018-11-30","2018-12-01"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,11,1)-WEEKDAY(DATE(日历年份,11,1),(周始日=\"星期一\")+1)+36","v":"2018-12-02"},"2018-12-03","备注"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"12月","index":12,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
[]
[null,{"$f":"B9","v":"2018-12-09"}]
[]
[null,{"$f":"周始日","v":"星期日"},{"$f":"UPPER(TEXT(C5,\"aaaa\"))","v":"星期一"},"星期二","星期三","星期四","星期五","星期六"]
[null,{"$f":"日期+DATE(日历年份,12,1)-WEEKDAY(DATE(日历年份,12,1),(周始日=\"星期一\")+1)+1","v":"2018-11-25"},"2018-11-26","2018-11-27","2018-11-28","2018-11-29","2018-11-30","2018-12-01"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,12,1)-WEEKDAY(DATE(日历年份,12,1),(周始日=\"星期一\")+1)+8","v":"2018-12-02"},"2018-12-03","2018-12-04","2018-12-05","2018-12-06","2018-12-07","2018-12-08"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B7),DAY(B7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C7),DAY(C7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D7),DAY(D7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E7),DAY(E7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F7),DAY(F7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G7),DAY(G7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H7),DAY(H7)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,12,1)-WEEKDAY(DATE(日历年份,12,1),(周始日=\"星期一\")+1)+15","v":"2018-12-09"},"2018-12-10","2018-12-11","2018-12-12","2018-12-13","2018-12-14","2018-12-15"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B9),DAY(B9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C9),DAY(C9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D9),DAY(D9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E9),DAY(E9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F9),DAY(F9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G9),DAY(G9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H9),DAY(H9)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,12,1)-WEEKDAY(DATE(日历年份,12,1),(周始日=\"星期一\")+1)+22","v":"2018-12-16"},"2018-12-17","2018-12-18","2018-12-19","2018-12-20","2018-12-21","2018-12-22"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B11),DAY(B11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C11),DAY(C11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D11),DAY(D11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E11),DAY(E11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F11),DAY(F11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G11),DAY(G11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H11),DAY(H11)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,12,1)-WEEKDAY(DATE(日历年份,12,1),(周始日=\"星期一\")+1)+29","v":"2018-12-23"},"2018-12-24","2018-12-25","2018-12-26","2018-12-27","2018-12-28","2018-12-29"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B13),DAY(B13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C13),DAY(C13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(D13),DAY(D13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":"圣诞节"},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(E13),DAY(E13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(F13),DAY(F13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(G13),DAY(G13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(H13),DAY(H13)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"日期+DATE(日历年份,12,1)-WEEKDAY(DATE(日历年份,12,1),(周始日=\"星期一\")+1)+36","v":"2018-12-30"},"2018-12-31","备注"]
[null,{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(B15),DAY(B15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(显示假日,IF(INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),6),INDEX(tblHolidays[],MATCH(DATE(日历年份,MONTH(C15),DAY(C15)),IF(显示已执行,tblHolidays[更正],tblHolidays[日期]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"假日","index":13,"n_rows":14,"n_cols":8,"rows_kept":14}
[]
[null,"美国假日",{"$nulls":5}," "]
[]
[null,"日期","假日","日期为","工作日","更正","显示"]
[null,{"$f":"DATE(日历年份,1,1)","v":"2018-01-01"},"新年","1 月 1 日",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[日期]],IF(周始日=\"星期一\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[日期]]),\"未执行\",IF(tblHolidays[[#This Row],[工作日]]=1,tblHolidays[[#This Row],[日期]]+1,IF(tblHolidays[[#This Row],[工作日]]=7,tblHolidays[[#This Row],[日期]]-1,tblHolidays[[#This Row],[日期]])))","v":"2018-01-01"},true]
[null,{"$f":"IF(MOD(日历年份,4)=1,DATE(日历年份,1,20)+(WEEKDAY(DATE(日历年份,1,20))=1),\"未执行\")","v":"未执行"},"总统就职日","1 月 20 日，第四年一次，总统选举后",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[日期]],IF(周始日=\"星期一\",2,1)),0)","v":0},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[日期]]),\"未执行\",IF(tblHolidays[[#This Row],[工作日]]=1,tblHolidays[[#This Row],[日期]]+1,IF(tblHolidays[[#This Row],[工作日]]=7,tblHolidays[[#This Row],[日期]]-1,tblHolidays[[#This Row],[日期]])))","v":"未执行"},true]
[null,{"$f":"DATE(日历年份,2,1+((3-(2>=WEEKDAY(DATE(日历年份,2,1))))*7)+(2-WEEKDAY(DATE(日历年份,2,1))))","v":"2018-02-19"},"总统日","2 月第三个星期一",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[日期]],IF(周始日=\"星期一\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[日期]]),\"未执行\",IF(tblHolidays[[#This Row],[工作日]]=1,tblHolidays[[#This Row],[日期]]+1,IF(tblHolidays[[#This Row],[工作日]]=7,tblHolidays[[#This Row],[日期]]-1,tblHolidays[[#This Row],[日期]])))","v":"2018-02-19"},true]
[null,{"$f":"DATE(日历年份,5,1+((五月星期一-(2>=WEEKDAY(DATE(日历年份,5,1))))*7)+(2-WEEKDAY(DATE(日历年份,5,1))))","v":"2018-05-28"},"国殇日","5 月最后一个星期一",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[日期]],IF(周始日=\"星期一\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[日期]]),\"未执行\",IF(tblHolidays[[#This Row],[工作日]]=1,tblHolidays[[#This Row],[日期]]+1,IF(tblHolidays[[#This Row],[工作日]]=7,tblHolidays[[#This Row],[日期]]-1,tblHolidays[[#This Row],[日期]])))","v":"2018-05-28"},true]
[null,{"$f":"DATE(日历年份,7,4)","v":"2018-07-04"},"独立日","7 月 4 日",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[日期]],IF(周始日=\"星期一\",2,1)),0)","v":4},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[日期]]),\"未执行\",IF(tblHolidays[[#This Row],[工作日]]=1,tblHolidays[[#This Row],[日期]]+1,IF(tblHolidays[[#This Row],[工作日]]=7,tblHolidays[[#This Row],[日期]]-1,tblHolidays[[#This Row],[日期]])))","v":"2018-07-04"},true]
[null,{"$f":"DATE(日历年份,9,1+((1-(2>=WEEKDAY(DATE(日历年份,9,1))))*7)+(2-WEEKDAY(DATE(日历年份,9,1))))","v":"2018-09-03"},"劳动节","9 月第一个星期一",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[日期]],IF(周始日=\"星期一\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[日期]]),\"未执行\",IF(tblHolidays[[#This Row],[工作日]]=1,tblHolidays[[#This Row],[日期]]+1,IF(tblHolidays[[#This Row],[工作日]]=7,tblHolidays[[#This Row],[日期]]-1,tblHolidays[[#This Row],[日期]])))","v":"2018-09-03"},true]
[null,{"$f":"DATE(日历年份,10,1+((2-(2>=WEEKDAY(DATE(日历年份,10,1))))*7)+(2-WEEKDAY(DATE(日历年份,10,1))))","v":"2018-10-08"},"哥伦布节","10 月第二个星期一",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[日期]],IF(周始日=\"星期一\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[日期]]),\"未执行\",IF(tblHolidays[[#This Row],[工作日]]=1,tblHolidays[[#This Row],[日期]]+1,IF(tblHolidays[[#This Row],[工作日]]=7,tblHolidays[[#This Row],[日期]]-1,tblHolidays[[#This Row],[日期]])))","v":"2018-10-08"},true]
[null,{"$f":"DATE(日历年份,11,11)","v":"2018-11-11"},"退伍军人节","11 月 11 日",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[日期]],IF(周始日=\"星期一\",2,1)),0)","v":1},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[日期]]),\"未执行\",IF(tblHolidays[[#This Row],[工作日]]=1,tblHolidays[[#This Row],[日期]]+1,IF(tblHolidays[[#This Row],[工作日]]=7,tblHolidays[[#This Row],[日期]]-1,tblHolidays[[#This Row],[日期]])))","v":"2018-11-12"},true]
[null,{"$f":"DATE(日历年份,11,1+((4-(5>=WEEKDAY(DATE(日历年份,11,1))))*7)+(5-WEEKDAY(DATE(日历年份,11,1))))","v":"2018-11-22"},"感恩节","11 月第四个星期四",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[日期]],IF(周始日=\"星期一\",2,1)),0)","v":5},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[日期]]),\"未执行\",IF(tblHolidays[[#This Row],[工作日]]=1,tblHolidays[[#This Row],[日期]]+1,IF(tblHolidays[[#This Row],[工作日]]=7,tblHolidays[[#This Row],[日期]]-1,tblHolidays[[#This Row],[日期]])))","v":"2018-11-22"},true]
[null,{"$f":"DATE(日历年份,12,25)","v":"2018-12-25"},"圣诞节","12 月 25 日",{"$f":"IFERROR(WEEKDAY(tblHolidays[[#This Row],[日期]],IF(周始日=\"星期一\",2,1)),0)","v":3},{"$f":"IF(ISTEXT(tblHolidays[[#This Row],[日期]]),\"未执行\",IF(tblHolidays[[#This Row],[工作日]]=1,tblHolidays[[#This Row],[日期]]+1,IF(tblHolidays[[#This Row],[工作日]]=7,tblHolidays[[#This Row],[日期]]-1,tblHolidays[[#This Row],[日期]])))","v":"2018-12-25"},true]