{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["Start","Settings","January","February","March","April","May","June","July","August","September","October","November","December","Holidays"],"not_rendered":{"defined_names":20},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"About The Template"]
[null,"Use this template to create a calendar of any year with holidays."]
[null,"Select Week Start day and Year in Settings worksheet and the annual calendar will be auto updated."]
[null,"Each monthly calendar will be auto updated in separate worksheet."]
[null,"Enter holidays in the last worksheet and these will automatically appear on each monthly calendar."]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in all worksheets. This text has been intentionally hidden. To remove text, select column A, then select DELETE. "]
[null,"To learn more about tables, press SHIFT and then F10 within a table, select the TABLE option, and then select ALTERNATIVE TEXT."]

{"sheet":"Settings","index":1,"n_rows":34,"n_cols":33,"rows_kept":34,"merged":[[1,17,2,23],[1,27,1,28],[1,29,1,30],[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]]}
["Create Annual Calendar by selecting year in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Title of this worksheet is in cell at right and Year label in cell R2. Select cell AB2 to navigate to Holidays worksheet and cell AD2 to navigate to January worksheet. Next instruction is in cell A4.","CALENDAR SETTINGS",{"$nulls":15},"YEAR",{"$nulls":9},"Holidays",null,"January"]
[]
["Week Start label is in cell at right. Select Week Start day in cell I4. Press ALT+DOWN ARROW for options, then DOWN ARROW and ENTER to make selection. Use slider in cell R4 to change year.","WEEK START",{"$nulls":6},"SUNDAY",{"$nulls":8},{"$f":"YEAR(TODAY())","v":2019}]
["Show Holiday label is in cell at right. Type “true” or “false” in cell I5 to check or uncheck the box to show or not show holidays in calendars.","SHOW HOLIDAYS",{"$nulls":6},true]
["Show Observed label is in cell at right. Type “true” or “false” in cell I6 to check or uncheck the box. Checked box will show the observed holidays in the calendar while unchecked will show the holidays that are not observed or fall on weekend. Next instruction is in cell A8.","SHOW OBSERVED",{"$nulls":6},true]
[{"$nulls":8},{"$f":"IF(ShowHolidays,Observed,ShowHolidays)","v":true}]
["Annual View label is in cell at right and annual calendar is in cells B10 through AF32. Next instruction is in cell A10.","ANNUAL VIEW"]
[null,{"$f":"DATE(CalYear,1,1)","v":43466},{"$nulls":7},{"$f":"DATE(CalYear,2,1)","v":43497},{"$nulls":7},{"$f":"DATE(CalYear,3,1)","v":43525},{"$nulls":7},{"$f":"DATE(CalYear,4,1)","v":43556}]
["January label is in cell B10, February label in cell J10, March in cell R10, and April in Z10.",{"$f":"UPPER(TEXT(B9,\"MMMM\"))","v":"JANUARY"},{"$nulls":7},{"$f":"UPPER(TEXT(J9,\"MMMM\"))","v":"FEBRUARY"},{"$nulls":7},{"$f":"UPPER(TEXT(R9,\"MMMM\"))","v":"MARCH"},{"$nulls":7},{"$f":"UPPER(TEXT(Z9,\"MMMM\"))","v":"APRIL"}]
["January calendar starts in cells at right, cells B11 to H16, February calendar in cells J11 to P16, March calendar in cells R11 to X16, and April calendar in cells Z11 to AF16. Next instruction is in cell A18.",{"$f":"Days+DATE(CalYear,MONTH($B$9),1)-WEEKDAY(DATE(CalYear,MONTH($B$9),1),(WeekStart=\"Monday\")+1)+$AG11*7-6","v":"2018-12-30"},"2018-12-31","2019-01-01","2019-01-02","2019-01-03","2019-01-04","2019-01-05",null,{"$f":"Days+DATE(CalYear,MONTH($J$9),1)-WEEKDAY(DATE(CalYear,MONTH($J$9),1),(WeekStart=\"Monday\")+1)+$AG11*7-6","v":"2019-01-27"},"2019-01-28","2019-01-29","2019-01-30","2019-01-31","2019-02-01","2019-02-02",null,{"$f":"Days+DATE(CalYear,MONTH($R$9),1)-WEEKDAY(DATE(CalYear,MONTH($R$9),1),(WeekStart=\"Monday\")+1)+$AG11*7-6","v":"2019-02-24"},"2019-02-25","2019-02-26","2019-02-27","2019-02-28","2019-03-01","2019-03-02",null,{"$f":"Days+DATE(CalYear,MONTH($Z$9),1)-WEEKDAY(DATE(CalYear,MONTH($Z$9),1),(WeekStart=\"Monday\")+1)+$AG11*7-6","v":"2019-03-31"},"2019-04-01","2019-04-02","2019-04-03","2019-04-04","2019-04-05","2019-04-06",1]
[null,{"$f":"Days+DATE(CalYear,MONTH($B$9),1)-WEEKDAY(DATE(CalYear,MONTH($B$9),1),(WeekStart=\"Monday\")+1)+$AG12*7-6","v":"2019-01-06"},"2019-01-07","2019-01-08","2019-01-09","2019-01-10","2019-01-11","2019-01-12",null,{"$f":"Days+DATE(CalYear,MONTH($J$9),1)-WEEKDAY(DATE(CalYear,MONTH($J$9),1),(WeekStart=\"Monday\")+1)+$AG12*7-6","v":"2019-02-03"},"2019-02-04","2019-02-05","2019-02-06","2019-02-07","2019-02-08","2019-02-09",null,{"$f":"Days+DATE(CalYear,MONTH($R$9),1)-WEEKDAY(DATE(CalYear,MONTH($R$9),1),(WeekStart=\"Monday\")+1)+$AG12*7-6","v":"2019-03-03"},"2019-03-04","2019-03-05","2019-03-06","2019-03-07","2019-03-08","2019-03-09",null,{"$f":"Days+DATE(CalYear,MONTH($Z$9),1)-WEEKDAY(DATE(CalYear,MONTH($Z$9),1),(WeekStart=\"Monday\")+1)+$AG12*7-6","v":"2019-04-07"},"2019-04-08","2019-04-09","2019-04-10","2019-04-11","2019-04-12","2019-04-13",2]
[null,{"$f":"Days+DATE(CalYear,MONTH($B$9),1)-WEEKDAY(DATE(CalYear,MONTH($B$9),1),(WeekStart=\"Monday\")+1)+$AG13*7-6","v":"2019-01-13"},"2019-01-14","2019-01-15","2019-01-16","2019-01-17","2019-01-18","2019-01-19",null,{"$f":"Days+DATE(CalYear,MONTH($J$9),1)-WEEKDAY(DATE(CalYear,MONTH($J$9),1),(WeekStart=\"Monday\")+1)+$AG13*7-6","v":"2019-02-10"},"2019-02-11","2019-02-12","2019-02-13","2019-02-14","2019-02-15","2019-02-16",null,{"$f":"Days+DATE(CalYear,MONTH($R$9),1)-WEEKDAY(DATE(CalYear,MONTH($R$9),1),(WeekStart=\"Monday\")+1)+$AG13*7-6","v":"2019-03-10"},"2019-03-11","2019-03-12","2019-03-13","2019-03-14","2019-03-15","2019-03-16",null,{"$f":"Days+DATE(CalYear,MONTH($Z$9),1)-WEEKDAY(DATE(CalYear,MONTH($Z$9),1),(WeekStart=\"Monday\")+1)+$AG13*7-6","v":"2019-04-14"},"2019-04-15","2019-04-16","2019-04-17","2019-04-18","2019-04-19","2019-04-20",3]
[null,{"$f":"Days+DATE(CalYear,MONTH($B$9),1)-WEEKDAY(DATE(CalYear,MONTH($B$9),1),(WeekStart=\"Monday\")+1)+$AG14*7-6","v":"2019-01-20"},"2019-01-21","2019-01-22","2019-01-23","2019-01-24","2019-01-25","2019-01-26",null,{"$f":"Days+DATE(CalYear,MONTH($J$9),1)-WEEKDAY(DATE(CalYear,MONTH($J$9),1),(WeekStart=\"Monday\")+1)+$AG14*7-6","v":"2019-02-17"},"2019-02-18","2019-02-19","2019-02-20","2019-02-21","2019-02-22","2019-02-23",null,{"$f":"Days+DATE(CalYear,MONTH($R$9),1)-WEEKDAY(DATE(CalYear,MONTH($R$9),1),(WeekStart=\"Monday\")+1)+$AG14*7-6","v":"2019-03-17"},"2019-03-18","2019-03-19","2019-03-20","2019-03-21","2019-03-22","2019-03-23",null,{"$f":"Days+DATE(CalYear,MONTH($Z$9),1)-WEEKDAY(DATE(CalYear,MONTH($Z$9),1),(WeekStart=\"Monday\")+1)+$AG14*7-6","v":"2019-04-21"},"2019-04-22","2019-04-23","2019-04-24","2019-04-25","2019-04-26","2019-04-27",4]
[null,{"$f":"Days+DATE(CalYear,MONTH($B$9),1)-WEEKDAY(DATE(CalYear,MONTH($B$9),1),(WeekStart=\"Monday\")+1)+$AG15*7-6","v":"2019-01-27"},"2019-01-28","2019-01-29","2019-01-30","2019-01-31","2019-02-01","2019-02-02",null,{"$f":"Days+DATE(CalYear,MONTH($J$9),1)-WEEKDAY(DATE(CalYear,MONTH($J$9),1),(WeekStart=\"Monday\")+1)+$AG15*7-6","v":"2019-02-24"},"2019-02-25","2019-02-26","2019-02-27","2019-02-28","2019-03-01","2019-03-02",null,{"$f":"Days+DATE(CalYear,MONTH($R$9),1)-WEEKDAY(DATE(CalYear,MONTH($R$9),1),(WeekStart=\"Monday\")+1)+$AG15*7-6","v":"2019-03-24"},"2019-03-25","2019-03-26","2019-03-27","2019-03-28","2019-03-29","2019-03-30",null,{"$f":"Days+DATE(CalYear,MONTH($Z$9),1)-WEEKDAY(DATE(CalYear,MONTH($Z$9),1),(WeekStart=\"Monday\")+1)+$AG15*7-6","v":"2019-04-28"},"2019-04-29","2019-04-30","2019-05-01","2019-05-02","2019-05-03","2019-05-04",5]
[null,{"$f":"Days+DATE(CalYear,MONTH($B$9),1)-WEEKDAY(DATE(CalYear,MONTH($B$9),1),(WeekStart=\"Monday\")+1)+$AG16*7-6","v":"2019-02-03"},"2019-02-04","2019-02-05","2019-02-06","2019-02-07","2019-02-08","2019-02-09",null,{"$f":"Days+DATE(CalYear,MONTH($J$9),1)-WEEKDAY(DATE(CalYear,MONTH($J$9),1),(WeekStart=\"Monday\")+1)+$AG16*7-6","v":"2019-03-03"},"2019-03-04","2019-03-05","2019-03-06","2019-03-07","2019-03-08","2019-03-09",null,{"$f":"Days+DATE(CalYear,MONTH($R$9),1)-WEEKDAY(DATE(CalYear,MONTH($R$9),1),(WeekStart=\"Monday\")+1)+$AG16*7-6","v":"2019-03-31"},"2019-04-01","2019-04-02","2019-04-03","2019-04-04","2019-04-05","2019-04-06",null,{"$f":"Days+DATE(CalYear,MONTH($Z$9),1)-WEEKDAY(DATE(CalYear,MONTH($Z$9),1),(WeekStart=\"Monday\")+1)+$AG16*7-6","v":"2019-05-05"},"2019-05-06","2019-05-07","2019-05-08","2019-05-09","2019-05-10","2019-05-11",6]
[]
["May label is in cell B18, June label in cell J18, July in cell R18, and August in Z18.",{"$f":"DATE(CalYear,5,1)","v":43586},{"$nulls":7},{"$f":"DATE(CalYear,6,1)","v":43617},{"$nulls":7},{"$f":"DATE(CalYear,7,1)","v":43647},{"$nulls":7},{"$f":"DATE(CalYear,8,1)","v":43678}]
["May label is in cell B18, June label in cell J18, July in cell R18, and August in Z18.",{"$f":"UPPER(TEXT(B18,\"MMMM\"))","v":"MAY"},{"$nulls":7},{"$f":"UPPER(TEXT(J18,\"MMMM\"))","v":"JUNE"},{"$nulls":7},{"$f":"UPPER(TEXT(R18,\"MMMM\"))","v":"JULY"},{"$nulls":7},{"$f":"UPPER(TEXT(Z18,\"MMMM\"))","v":"AUGUST"}]
["May calendar starts in cells at right, cells B19 to H24, June calendar in cells J19 to P24, July calendar in cells R19 to X24, and August calendar in cells Z19 to AF24. Next instruction is in cell A26.",{"$f":"Days+DATE(CalYear,MONTH($B$18),1)-WEEKDAY(DATE(CalYear,MONTH($B$18),1),(WeekStart=\"Monday\")+1)+$AG20*7-6","v":"2019-04-28"},"2019-04-29","2019-04-30","2019-05-01","2019-05-02","2019-05-03","2019-05-04",null,{"$f":"Days+DATE(CalYear,MONTH($J$18),1)-WEEKDAY(DATE(CalYear,MONTH($J$18),1),(WeekStart=\"Monday\")+1)+$AG20*7-6","v":"2019-05-26"},"2019-05-27","2019-05-28","2019-05-29","2019-05-30","2019-05-31","2019-06-01",null,{"$f":"Days+DATE(CalYear,MONTH($R$18),1)-WEEKDAY(DATE(CalYear,MONTH($R$18),1),(WeekStart=\"Monday\")+1)+$AG20*7-6","v":"2019-06-30"},"2019-07-01","2019-07-02","2019-07-03","2019-07-04","2019-07-05","2019-07-06",null,{"$f":"Days+DATE(CalYear,MONTH($Z$18),1)-WEEKDAY(DATE(CalYear,MONTH($Z$18),1),(WeekStart=\"Monday\")+1)+$AG20*7-6","v":"2019-07-28"},"2019-07-29","2019-07-30","2019-07-31","2019-08-01","2019-08-02","2019-08-03",1]
[null,{"$f":"Days+DATE(CalYear,MONTH($B$18),1)-WEEKDAY(DATE(CalYear,MONTH($B$18),1),(WeekStart=\"Monday\")+1)+$AG21*7-6","v":"2019-05-05"},"2019-05-06","2019-05-07","2019-05-08","2019-05-09","2019-05-10","2019-05-11",null,{"$f":"Days+DATE(CalYear,MONTH($J$18),1)-WEEKDAY(DATE(CalYear,MONTH($J$18),1),(WeekStart=\"Monday\")+1)+$AG21*7-6","v":"2019-06-02"},"2019-06-03","2019-06-04","2019-06-05","2019-06-06","2019-06-07","2019-06-08",null,{"$f":"Days+DATE(CalYear,MONTH($R$18),1)-WEEKDAY(DATE(CalYear,MONTH($R$18),1),(WeekStart=\"Monday\")+1)+$AG21*7-6","v":"2019-07-07"},"2019-07-08","2019-07-09","2019-07-10","2019-07-11","2019-07-12","2019-07-13",null,{"$f":"Days+DATE(CalYear,MONTH($Z$18),1)-WEEKDAY(DATE(CalYear,MONTH($Z$18),1),(WeekStart=\"Monday\")+1)+$AG21*7-6","v":"2019-08-04"},"2019-08-05","2019-08-06","2019-08-07","2019-08-08","2019-08-09","2019-08-10",2]
[null,{"$f":"Days+DATE(CalYear,MONTH($B$18),1)-WEEKDAY(DATE(CalYear,MONTH($B$18),1),(WeekStart=\"Monday\")+1)+$AG22*7-6","v":"2019-05-12"},"2019-05-13","2019-05-14","2019-05-15","2019-05-16","2019-05-17","2019-05-18",null,{"$f":"Days+DATE(CalYear,MONTH($J$18),1)-WEEKDAY(DATE(CalYear,MONTH($J$18),1),(WeekStart=\"Monday\")+1)+$AG22*7-6","v":"2019-06-09"},"2019-06-10","2019-06-11","2019-06-12","2019-06-13","2019-06-14","2019-06-15",null,{"$f":"Days+DATE(CalYear,MONTH($R$18),1)-WEEKDAY(DATE(CalYear,MONTH($R$18),1),(WeekStart=\"Monday\")+1)+$AG22*7-6","v":"2019-07-14"},"2019-07-15","2019-07-16","2019-07-17","2019-07-18","2019-07-19","2019-07-20",null,{"$f":"Days+DATE(CalYear,MONTH($Z$18),1)-WEEKDAY(DATE(CalYear,MONTH($Z$18),1),(WeekStart=\"Monday\")+1)+$AG22*7-6","v":"2019-08-11"},"2019-08-12","2019-08-13","2019-08-14","2019-08-15","2019-08-16","2019-08-17",3]
[null,{"$f":"Days+DATE(CalYear,MONTH($B$18),1)-WEEKDAY(DATE(CalYear,MONTH($B$18),1),(WeekStart=\"Monday\")+1)+$AG23*7-6","v":"2019-05-19"},"2019-05-20","2019-05-21","2019-05-22","2019-05-23","2019-05-24","2019-05-25",null,{"$f":"Days+DATE(CalYear,MONTH($J$18),1)-WEEKDAY(DATE(CalYear,MONTH($J$18),1),(WeekStart=\"Monday\")+1)+$AG23*7-6","v":"2019-06-16"},"2019-06-17","2019-06-18","2019-06-19","2019-06-20","2019-06-21","2019-06-22",null,{"$f":"Days+DATE(CalYear,MONTH($R$18),1)-WEEKDAY(DATE(CalYear,MONTH($R$18),1),(WeekStart=\"Monday\")+1)+$AG23*7-6","v":"2019-07-21"},"2019-07-22","2019-07-23","2019-07-24","2019-07-25","2019-07-26","2019-07-27",null,{"$f":"Days+DATE(CalYear,MONTH($Z$18),1)-WEEKDAY(DATE(CalYear,MONTH($Z$18),1),(WeekStart=\"Monday\")+1)+$AG23*7-6","v":"2019-08-18"},"2019-08-19","2019-08-20","2019-08-21","2019-08-22","2019-08-23","2019-08-24",4]
[null,{"$f":"Days+DATE(CalYear,MONTH($B$18),1)-WEEKDAY(DATE(CalYear,MONTH($B$18),1),(WeekStart=\"Monday\")+1)+$AG24*7-6","v":"2019-05-26"},"2019-05-27","2019-05-28","2019-05-29","2019-05-30","2019-05-31","2019-06-01",null,{"$f":"Days+DATE(CalYear,MONTH($J$18),1)-WEEKDAY(DATE(CalYear,MONTH($J$18),1),(WeekStart=\"Monday\")+1)+$AG24*7-6","v":"2019-06-23"},"2019-06-24","2019-06-25","2019-06-26","2019-06-27","2019-06-28","2019-06-29",null,{"$f":"Days+DATE(CalYear,MONTH($R$18),1)-WEEKDAY(DATE(CalYear,MONTH($R$18),1),(WeekStart=\"Monday\")+1)+$AG24*7-6","v":"2019-07-28"},"2019-07-29","2019-07-30","2019-07-31","2019-08-01","2019-08-02","2019-08-03",null,{"$f":"Days+DATE(CalYear,MONTH($Z$18),1)-WEEKDAY(DATE(CalYear,MONTH($Z$18),1),(WeekStart=\"Monday\")+1)+$AG24*7-6","v":"2019-08-25"},"2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31",5]
[null,{"$f":"Days+DATE(CalYear,MONTH($B$18),1)-WEEKDAY(DATE(CalYear,MONTH($B$18),1),(WeekStart=\"Monday\")+1)+$AG25*7-6","v":"2019-06-02"},"2019-06-03","2019-06-04","2019-06-05","2019-06-06","2019-06-07","2019-06-08",null,{"$f":"Days+DATE(CalYear,MONTH($J$18),1)-WEEKDAY(DATE(CalYear,MONTH($J$18),1),(WeekStart=\"Monday\")+1)+$AG25*7-6","v":"2019-06-30"},"2019-07-01","2019-07-02","2019-07-03","2019-07-04","2019-07-05","2019-07-06",null,{"$f":"Days+DATE(CalYear,MONTH($R$18),1)-WEEKDAY(DATE(CalYear,MONTH($R$18),1),(WeekStart=\"Monday\")+1)+$AG25*7-6","v":"2019-08-04"},"2019-08-05","2019-08-06","2019-08-07","2019-08-08","2019-08-09","2019-08-10",null,{"$f":"Days+DATE(CalYear,MONTH($Z$18),1)-WEEKDAY(DATE(CalYear,MONTH($Z$18),1),(WeekStart=\"Monday\")+1)+$AG25*7-6","v":"2019-09-01"},"2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07",6]
["September label is in cell B26, October label in cell J26, November in cell R26, and December in Z26."]
[null,{"$f":"DATE(CalYear,9,1)","v":43709},{"$nulls":7},{"$f":"DATE(CalYear,10,1)","v":43739},{"$nulls":7},{"$f":"DATE(CalYear,11,1)","v":43770},{"$nulls":7},{"$f":"DATE(CalYear,12,1)","v":43800}]
["September label is in cell B26, October label in cell J26, November in cell R26, and December in Z26.",{"$f":"UPPER(TEXT(B27,\"MMMM\"))","v":"SEPTEMBER"},{"$nulls":7},{"$f":"UPPER(TEXT(J27,\"MMMM\"))","v":"OCTOBER"},{"$nulls":7},{"$f":"UPPER(TEXT(R27,\"MMMM\"))","v":"NOVEMBER"},{"$nulls":7},{"$f":"UPPER(TEXT(Z27,\"MMMM\"))","v":"DECEMBER"}]
["September calendar starts in cells at right, cells B27 to H32, October calendar in cells J27 to P32, November calendar in cells R27 to X32, and December calendar in cells Z27 to AF32.",{"$f":"Days+DATE(CalYear,MONTH($B$27),1)-WEEKDAY(DATE(CalYear,MONTH($B$27),1),(WeekStart=\"Monday\")+1)+$AG29*7-6","v":"2019-09-01"},"2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07",null,{"$f":"Days+DATE(CalYear,MONTH($J$27),1)-WEEKDAY(DATE(CalYear,MONTH($J$27),1),(WeekStart=\"Monday\")+1)+$AG29*7-6","v":"2019-09-29"},"2019-09-30","2019-10-01","2019-10-02","2019-10-03","2019-10-04","2019-10-05",null,{"$f":"Days+DATE(CalYear,MONTH($R$27),1)-WEEKDAY(DATE(CalYear,MONTH($R$27),1),(WeekStart=\"Monday\")+1)+$AG29*7-6","v":"2019-10-27"},"2019-10-28","2019-10-29","2019-10-30","2019-10-31","2019-11-01","2019-11-02",null,{"$f":"Days+DATE(CalYear,MONTH($Z$27),1)-WEEKDAY(DATE(CalYear,MONTH($Z$27),1),(WeekStart=\"Monday\")+1)+$AG29*7-6","v":"2019-12-01"},"2019-12-02","2019-12-03","2019-12-04","2019-12-05","2019-12-06","2019-12-07",1]
[null,{"$f":"Days+DATE(CalYear,MONTH($B$27),1)-WEEKDAY(DATE(CalYear,MONTH($B$27),1),(WeekStart=\"Monday\")+1)+$AG30*7-6","v":"2019-09-08"},"2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14",null,{"$f":"Days+DATE(CalYear,MONTH($J$27),1)-WEEKDAY(DATE(CalYear,MONTH($J$27),1),(WeekStart=\"Monday\")+1)+$AG30*7-6","v":"2019-10-06"},"2019-10-07","2019-10-08","2019-10-09","2019-10-10","2019-10-11","2019-10-12",null,{"$f":"Days+DATE(CalYear,MONTH($R$27),1)-WEEKDAY(DATE(CalYear,MONTH($R$27),1),(WeekStart=\"Monday\")+1)+$AG30*7-6","v":"2019-11-03"},"2019-11-04","2019-11-05","2019-11-06","2019-11-07","2019-11-08","2019-11-09",null,{"$f":"Days+DATE(CalYear,MONTH($Z$27),1)-WEEKDAY(DATE(CalYear,MONTH($Z$27),1),(WeekStart=\"Monday\")+1)+$AG30*7-6","v":"2019-12-08"},"2019-12-09","2019-12-10","2019-12-11","2019-12-12","2019-12-13","2019-12-14",2]
[null,{"$f":"Days+DATE(CalYear,MONTH($B$27),1)-WEEKDAY(DATE(CalYear,MONTH($B$27),1),(WeekStart=\"Monday\")+1)+$AG31*7-6","v":"2019-09-15"},"2019-09-16","2019-09-17","2019-09-18","2019-09-19","2019-09-20","2019-09-21",null,{"$f":"Days+DATE(CalYear,MONTH($J$27),1)-WEEKDAY(DATE(CalYear,MONTH($J$27),1),(WeekStart=\"Monday\")+1)+$AG31*7-6","v":"2019-10-13"},"2019-10-14","2019-10-15","2019-10-16","2019-10-17","2019-10-18","2019-10-19",null,{"$f":"Days+DATE(CalYear,MONTH($R$27),1)-WEEKDAY(DATE(CalYear,MONTH($R$27),1),(WeekStart=\"Monday\")+1)+$AG31*7-6","v":"2019-11-10"},"2019-11-11","2019-11-12","2019-11-13","2019-11-14","2019-11-15","2019-11-16",null,{"$f":"Days+DATE(CalYear,MONTH($Z$27),1)-WEEKDAY(DATE(CalYear,MONTH($Z$27),1),(WeekStart=\"Monday\")+1)+$AG31*7-6","v":"2019-12-15"},"2019-12-16","2019-12-17","2019-12-18","2019-12-19","2019-12-20","2019-12-21",3]
[null,{"$f":"Days+DATE(CalYear,MONTH($B$27),1)-WEEKDAY(DATE(CalYear,MONTH($B$27),1),(WeekStart=\"Monday\")+1)+$AG32*7-6","v":"2019-09-22"},"2019-09-23","2019-09-24","2019-09-25","2019-09-26","2019-09-27","2019-09-28",null,{"$f":"Days+DATE(CalYear,MONTH($J$27),1)-WEEKDAY(DATE(CalYear,MONTH($J$27),1),(WeekStart=\"Monday\")+1)+$AG32*7-6","v":"2019-10-20"},"2019-10-21","2019-10-22","2019-10-23","2019-10-24","2019-10-25","2019-10-26",null,{"$f":"Days+DATE(CalYear,MONTH($R$27),1)-WEEKDAY(DATE(CalYear,MONTH($R$27),1),(WeekStart=\"Monday\")+1)+$AG32*7-6","v":"2019-11-17"},"2019-11-18","2019-11-19","2019-11-20","2019-11-21","2019-11-22","2019-11-23",null,{"$f":"Days+DATE(CalYear,MONTH($Z$27),1)-WEEKDAY(DATE(CalYear,MONTH($Z$27),1),(WeekStart=\"Monday\")+1)+$AG32*7-6","v":"2019-12-22"},"2019-12-23","2019-12-24","2019-12-25","2019-12-26","2019-12-27","2019-12-28",4]
[null,{"$f":"Days+DATE(CalYear,MONTH($B$27),1)-WEEKDAY(DATE(CalYear,MONTH($B$27),1),(WeekStart=\"Monday\")+1)+$AG33*7-6","v":"2019-09-29"},"2019-09-30","2019-10-01","2019-10-02","2019-10-03","2019-10-04","2019-10-05",null,{"$f":"Days+DATE(CalYear,MONTH($J$27),1)-WEEKDAY(DATE(CalYear,MONTH($J$27),1),(WeekStart=\"Monday\")+1)+$AG33*7-6","v":"2019-10-27"},"2019-10-28","2019-10-29","2019-10-30","2019-10-31","2019-11-01","2019-11-02",null,{"$f":"Days+DATE(CalYear,MONTH($R$27),1)-WEEKDAY(DATE(CalYear,MONTH($R$27),1),(WeekStart=\"Monday\")+1)+$AG33*7-6","v":"2019-11-24"},"2019-11-25","2019-11-26","2019-11-27","2019-11-28","2019-11-29","2019-11-30",null,{"$f":"Days+DATE(CalYear,MONTH($Z$27),1)-WEEKDAY(DATE(CalYear,MONTH($Z$27),1),(WeekStart=\"Monday\")+1)+$AG33*7-6","v":"2019-12-29"},"2019-12-30","2019-12-31","2020-01-01","2020-01-02","2020-01-03","2020-01-04",5]
[null,{"$f":"Days+DATE(CalYear,MONTH($B$27),1)-WEEKDAY(DATE(CalYear,MONTH($B$27),1),(WeekStart=\"Monday\")+1)+$AG34*7-6","v":"2019-10-06"},"2019-10-07","2019-10-08","2019-10-09","2019-10-10","2019-10-11","2019-10-12",null,{"$f":"Days+DATE(CalYear,MONTH($J$27),1)-WEEKDAY(DATE(CalYear,MONTH($J$27),1),(WeekStart=\"Monday\")+1)+$AG34*7-6","v":"2019-11-03"},"2019-11-04","2019-11-05","2019-11-06","2019-11-07","2019-11-08","2019-11-09",null,{"$f":"Days+DATE(CalYear,MONTH($R$27),1)-WEEKDAY(DATE(CalYear,MONTH($R$27),1),(WeekStart=\"Monday\")+1)+$AG34*7-6","v":"2019-12-01"},"2019-12-02","2019-12-03","2019-12-04","2019-12-05","2019-12-06","2019-12-07",null,{"$f":"Days+DATE(CalYear,MONTH($Z$27),1)-WEEKDAY(DATE(CalYear,MONTH($Z$27),1),(WeekStart=\"Monday\")+1)+$AG34*7-6","v":"2020-01-05"},"2020-01-06","2020-01-07","2020-01-08","2020-01-09","2020-01-10","2020-01-11",6]

{"sheet":"January","index":2,"n_rows":17,"n_cols":8,"rows_kept":17,"merged":[[1,1,1,3],[14,3,14,7],[15,3,15,7],[16,1,16,7]]}
["January month calendar for the year selected in Settings worksheet is auto updated in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Title of this worksheet is in cell at right. Select cell G2 to navigate to Settings worksheet and cell H2 to navigate to February worksheet. Next instruction is in cell A4.",{"$f":"B9","v":"2019-01-13"},{"$nulls":4},"Settings","February"]
[]
["Weekdays are in cells at right, cells B4 through H4.",{"$f":"WeekStart","v":"SUNDAY"},{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
["Calendar dates are in cells at right, cells B5 through H5. If the first cell does not contain number 1, then it’d be a previous month date.",{"$f":"Days+DATE(CalYear,1,1)-WEEKDAY(DATE(CalYear,1,1),(WeekStart=\"Monday\")+1)+1","v":"2018-12-30"},"2018-12-31","2019-01-01","2019-01-02","2019-01-03","2019-01-04","2019-01-05"]
["Holidays or special occasions are auto highlighted in cells at right, cells B6 through H6. ",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"New Years Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B7 through H7.",{"$f":"Days+DATE(CalYear,1,1)-WEEKDAY(DATE(CalYear,1,1),(WeekStart=\"Monday\")+1)+8","v":"2019-01-06"},"2019-01-07","2019-01-08","2019-01-09","2019-01-10","2019-01-11","2019-01-12"]
["Holidays or special occasions are auto highlighted in cells at right, cells B8 through H8.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B9 through H9.",{"$f":"Days+DATE(CalYear,1,1)-WEEKDAY(DATE(CalYear,1,1),(WeekStart=\"Monday\")+1)+15","v":"2019-01-13"},"2019-01-14","2019-01-15","2019-01-16","2019-01-17","2019-01-18","2019-01-19"]
["Holidays or special occasions are auto highlighted in cells at right, cells B10 through H10.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B11 through H11.",{"$f":"Days+DATE(CalYear,1,1)-WEEKDAY(DATE(CalYear,1,1),(WeekStart=\"Monday\")+1)+22","v":"2019-01-20"},"2019-01-21","2019-01-22","2019-01-23","2019-01-24","2019-01-25","2019-01-26"]
["Holidays or special occasions are auto highlighted in cells at right, cells B12 through H12.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Martin Luther King, Jr. Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B13 through H13.",{"$f":"Days+DATE(CalYear,1,1)-WEEKDAY(DATE(CalYear,1,1),(WeekStart=\"Monday\")+1)+29","v":"2019-01-27"},"2019-01-28","2019-01-29","2019-01-30","2019-01-31","2019-02-01","2019-02-02"]
["Holidays or special occasions are auto highlighted in cells at right, cells B14 through H14.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar date is in cell at right and cell C15, and Notes label in cell D15.",{"$f":"Days+DATE(CalYear,1,1)-WEEKDAY(DATE(CalYear,1,1),(WeekStart=\"Monday\")+1)+36","v":"2019-02-03"},"2019-02-04","NOTES"]
["Holidays or special occasions are auto highlighted in cells at right, cells B16 and C16. Enter notes in cell D16 for the entire month.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"IF(Holidays!$C$6=\"Martin Luther King, Jr. Day *\",\"* Martin Luther King Jr. Day and Inaguration Day\", \"\")","v":""}]

{"sheet":"February","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]]}
["February month calendar for the year selected in Settings worksheet is auto updated in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Title of this worksheet is in cell at right. Select cell G2 to navigate to January worksheet and cell H2 to navigate to March worksheet. Next instruction is in cell A4.",{"$f":"B9","v":"2019-02-10"},{"$nulls":4},"January","March"]
[]
["Weekdays are in cells at right, cells B4 through H4.","SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
["Calendar dates are in cells at right, cells B5 through H5. If the first cell does not contain number 1, then it’d be a previous month date.",{"$f":"Days+DATE(CalYear,2,1)-WEEKDAY(DATE(CalYear,2,1),(WeekStart=\"Monday\")+1)+1","v":"2019-01-27"},"2019-01-28","2019-01-29","2019-01-30","2019-01-31","2019-02-01","2019-02-02"]
["Holidays or special occasions are auto highlighted in cells at right, cells B6 through H6. ",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B7 through H7.",{"$f":"Days+DATE(CalYear,2,1)-WEEKDAY(DATE(CalYear,2,1),(WeekStart=\"Monday\")+1)+8","v":"2019-02-03"},"2019-02-04","2019-02-05","2019-02-06","2019-02-07","2019-02-08","2019-02-09"]
["Holidays or special occasions are auto highlighted in cells at right, cells B8 through H8.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B9 through H9.",{"$f":"Days+DATE(CalYear,2,1)-WEEKDAY(DATE(CalYear,2,1),(WeekStart=\"Monday\")+1)+15","v":"2019-02-10"},"2019-02-11","2019-02-12","2019-02-13","2019-02-14","2019-02-15","2019-02-16"]
["Holidays or special occasions are auto highlighted in cells at right, cells B10 through H10.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B11 through H11.",{"$f":"Days+DATE(CalYear,2,1)-WEEKDAY(DATE(CalYear,2,1),(WeekStart=\"Monday\")+1)+22","v":"2019-02-17"},"2019-02-18","2019-02-19","2019-02-20","2019-02-21","2019-02-22","2019-02-23"]
["Holidays or special occasions are auto highlighted in cells at right, cells B12 through H12.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Presidents Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B13 through H13.",{"$f":"Days+DATE(CalYear,2,1)-WEEKDAY(DATE(CalYear,2,1),(WeekStart=\"Monday\")+1)+29","v":"2019-02-24"},"2019-02-25","2019-02-26","2019-02-27","2019-02-28","2019-03-01","2019-03-02"]
["Holidays or special occasions are auto highlighted in cells at right, cells B14 through H14.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar date is in cell at right and cell C15, and Notes label in cell D15.",{"$f":"Days+DATE(CalYear,2,1)-WEEKDAY(DATE(CalYear,2,1),(WeekStart=\"Monday\")+1)+36","v":"2019-03-03"},"2019-03-04","NOTES"]
["Holidays or special occasions are auto highlighted in cells at right, cells B16 and C16. Enter notes in cell D16 for the entire month.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"March","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]]}
["March month calendar for the year selected in Settings worksheet is auto updated in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Title of this worksheet is in cell at right. Select cell G2 to navigate to February worksheet and cell H2 to navigate to April worksheet. Next instruction is in cell A4.",{"$f":"B9","v":"2019-03-10"},{"$nulls":4},"February","April"]
[]
["Weekdays are in cells at right, cells B4 through H4.","SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
["Calendar dates are in cells at right, cells B5 through H5. If the first cell does not contain number 1, then it’d be a previous month date.",{"$f":"Days+DATE(CalYear,3,1)-WEEKDAY(DATE(CalYear,3,1),(WeekStart=\"Monday\")+1)+1","v":"2019-02-24"},"2019-02-25","2019-02-26","2019-02-27","2019-02-28","2019-03-01","2019-03-02"]
["Holidays or special occasions are auto highlighted in cells at right, cells B6 through H6. ",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B7 through H7.",{"$f":"Days+DATE(CalYear,3,1)-WEEKDAY(DATE(CalYear,3,1),(WeekStart=\"Monday\")+1)+8","v":"2019-03-03"},"2019-03-04","2019-03-05","2019-03-06","2019-03-07","2019-03-08","2019-03-09"]
["Holidays or special occasions are auto highlighted in cells at right, cells B8 through H8.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B9 through H9.",{"$f":"Days+DATE(CalYear,3,1)-WEEKDAY(DATE(CalYear,3,1),(WeekStart=\"Monday\")+1)+15","v":"2019-03-10"},"2019-03-11","2019-03-12","2019-03-13","2019-03-14","2019-03-15","2019-03-16"]
["Holidays or special occasions are auto highlighted in cells at right, cells B10 through H10.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B11 through H11.",{"$f":"Days+DATE(CalYear,3,1)-WEEKDAY(DATE(CalYear,3,1),(WeekStart=\"Monday\")+1)+22","v":"2019-03-17"},"2019-03-18","2019-03-19","2019-03-20","2019-03-21","2019-03-22","2019-03-23"]
["Holidays or special occasions are auto highlighted in cells at right, cells B12 through H12.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B13 through H13.",{"$f":"Days+DATE(CalYear,3,1)-WEEKDAY(DATE(CalYear,3,1),(WeekStart=\"Monday\")+1)+29","v":"2019-03-24"},"2019-03-25","2019-03-26","2019-03-27","2019-03-28","2019-03-29","2019-03-30"]
["Holidays or special occasions are auto highlighted in cells at right, cells B14 through H14.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar date is in cell at right and cell C15, and Notes label in cell D15.",{"$f":"Days+DATE(CalYear,3,1)-WEEKDAY(DATE(CalYear,3,1),(WeekStart=\"Monday\")+1)+36","v":"2019-03-31"},"2019-04-01","NOTES"]
["Holidays or special occasions are auto highlighted in cells at right, cells B16 and C16. Enter notes in cell D16 for the entire month.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"April","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]]}
["April month calendar for the year selected in Settings worksheet is auto updated in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Title of this worksheet is in cell at right. Select cell G2 to navigate to March worksheet and cell H2 to navigate to May worksheet. Next instruction is in cell A4.",{"$f":"B9","v":"2019-04-14"},{"$nulls":4},"March","May"]
[]
["Weekdays are in cells at right, cells B4 through H4.","SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
["Calendar dates are in cells at right, cells B5 through H5. If the first cell does not contain number 1, then it’d be a previous month date.",{"$f":"Days+DATE(CalYear,4,1)-WEEKDAY(DATE(CalYear,4,1),(WeekStart=\"Monday\")+1)+1","v":"2019-03-31"},"2019-04-01","2019-04-02","2019-04-03","2019-04-04","2019-04-05","2019-04-06"]
["Holidays or special occasions are auto highlighted in cells at right, cells B6 through H6. ",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B7 through H7.",{"$f":"Days+DATE(CalYear,4,1)-WEEKDAY(DATE(CalYear,4,1),(WeekStart=\"Monday\")+1)+8","v":"2019-04-07"},"2019-04-08","2019-04-09","2019-04-10","2019-04-11","2019-04-12","2019-04-13"]
["Holidays or special occasions are auto highlighted in cells at right, cells B8 through H8.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B9 through H9.",{"$f":"Days+DATE(CalYear,4,1)-WEEKDAY(DATE(CalYear,4,1),(WeekStart=\"Monday\")+1)+15","v":"2019-04-14"},"2019-04-15","2019-04-16","2019-04-17","2019-04-18","2019-04-19","2019-04-20"]
["Holidays or special occasions are auto highlighted in cells at right, cells B10 through H10.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B11 through H11.",{"$f":"Days+DATE(CalYear,4,1)-WEEKDAY(DATE(CalYear,4,1),(WeekStart=\"Monday\")+1)+22","v":"2019-04-21"},"2019-04-22","2019-04-23","2019-04-24","2019-04-25","2019-04-26","2019-04-27"]
["Holidays or special occasions are auto highlighted in cells at right, cells B12 through H12.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B13 through H13.",{"$f":"Days+DATE(CalYear,4,1)-WEEKDAY(DATE(CalYear,4,1),(WeekStart=\"Monday\")+1)+29","v":"2019-04-28"},"2019-04-29","2019-04-30","2019-05-01","2019-05-02","2019-05-03","2019-05-04"]
["Holidays or special occasions are auto highlighted in cells at right, cells B14 through H14.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar date is in cell at right and cell C15, and Notes label in cell D15.",{"$f":"Days+DATE(CalYear,4,1)-WEEKDAY(DATE(CalYear,4,1),(WeekStart=\"Monday\")+1)+36","v":"2019-05-05"},"2019-05-06","NOTES"]
["Holidays or special occasions are auto highlighted in cells at right, cells B16 and C16. Enter notes in cell D16 for the entire month.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"May","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]]}
["May month calendar for the year selected in Settings worksheet is auto updated in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Title of this worksheet is in cell at right. Select cell G2 to navigate to April worksheet and cell H2 to navigate to June worksheet. Next instruction is in cell A4.",{"$f":"B9","v":"2019-05-12"},{"$nulls":4},"April","June"]
[]
["Weekdays are in cells at right, cells B4 through H4.","SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
["Calendar dates are in cells at right, cells B5 through H5. If the first cell does not contain number 1, then it’d be a previous month date.",{"$f":"Days+DATE(CalYear,5,1)-WEEKDAY(DATE(CalYear,5,1),(WeekStart=\"Monday\")+1)+1","v":"2019-04-28"},"2019-04-29","2019-04-30","2019-05-01","2019-05-02","2019-05-03","2019-05-04"]
["Holidays or special occasions are auto highlighted in cells at right, cells B6 through H6. ",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B7 through H7.",{"$f":"Days+DATE(CalYear,5,1)-WEEKDAY(DATE(CalYear,5,1),(WeekStart=\"Monday\")+1)+8","v":"2019-05-05"},"2019-05-06","2019-05-07","2019-05-08","2019-05-09","2019-05-10","2019-05-11"]
["Holidays or special occasions are auto highlighted in cells at right, cells B8 through H8.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B9 through H9.",{"$f":"Days+DATE(CalYear,5,1)-WEEKDAY(DATE(CalYear,5,1),(WeekStart=\"Monday\")+1)+15","v":"2019-05-12"},"2019-05-13","2019-05-14","2019-05-15","2019-05-16","2019-05-17","2019-05-18"]
["Holidays or special occasions are auto highlighted in cells at right, cells B10 through H10.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B11 through H11.",{"$f":"Days+DATE(CalYear,5,1)-WEEKDAY(DATE(CalYear,5,1),(WeekStart=\"Monday\")+1)+22","v":"2019-05-19"},"2019-05-20","2019-05-21","2019-05-22","2019-05-23","2019-05-24","2019-05-25"]
["Holidays or special occasions are auto highlighted in cells at right, cells B12 through H12.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B13 through H13.",{"$f":"Days+DATE(CalYear,5,1)-WEEKDAY(DATE(CalYear,5,1),(WeekStart=\"Monday\")+1)+29","v":"2019-05-26"},"2019-05-27","2019-05-28","2019-05-29","2019-05-30","2019-05-31","2019-06-01"]
["Holidays or special occasions are auto highlighted in cells at right, cells B14 through H14.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Memorial Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar date is in cell at right and cell C15, and Notes label in cell D15.",{"$f":"Days+DATE(CalYear,5,1)-WEEKDAY(DATE(CalYear,5,1),(WeekStart=\"Monday\")+1)+36","v":"2019-06-02"},"2019-06-03","NOTES"]
["Holidays or special occasions are auto highlighted in cells at right, cells B16 and C16. Enter notes in cell D16 for the entire month.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"June","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]]}
["June month calendar for the year selected in Settings worksheet is auto updated in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Title of this worksheet is in cell at right. Select cell G2 to navigate to May worksheet and cell H2 to navigate to July worksheet. Next instruction is in cell A4.",{"$f":"B9","v":"2019-06-09"},{"$nulls":4},"May","July"]
[]
["Weekdays are in cells at right, cells B4 through H4.","SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
["Calendar dates are in cells at right, cells B5 through H5. If the first cell does not contain number 1, then it’d be a previous month date.",{"$f":"Days+DATE(CalYear,6,1)-WEEKDAY(DATE(CalYear,6,1),(WeekStart=\"Monday\")+1)+1","v":"2019-05-26"},"2019-05-27","2019-05-28","2019-05-29","2019-05-30","2019-05-31","2019-06-01"]
["Holidays or special occasions are auto highlighted in cells at right, cells B6 through H6. ",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B7 through H7.",{"$f":"Days+DATE(CalYear,6,1)-WEEKDAY(DATE(CalYear,6,1),(WeekStart=\"Monday\")+1)+8","v":"2019-06-02"},"2019-06-03","2019-06-04","2019-06-05","2019-06-06","2019-06-07","2019-06-08"]
["Holidays or special occasions are auto highlighted in cells at right, cells B8 through H8.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B9 through H9.",{"$f":"Days+DATE(CalYear,6,1)-WEEKDAY(DATE(CalYear,6,1),(WeekStart=\"Monday\")+1)+15","v":"2019-06-09"},"2019-06-10","2019-06-11","2019-06-12","2019-06-13","2019-06-14","2019-06-15"]
["Holidays or special occasions are auto highlighted in cells at right, cells B10 through H10.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B11 through H11.",{"$f":"Days+DATE(CalYear,6,1)-WEEKDAY(DATE(CalYear,6,1),(WeekStart=\"Monday\")+1)+22","v":"2019-06-16"},"2019-06-17","2019-06-18","2019-06-19","2019-06-20","2019-06-21","2019-06-22"]
["Holidays or special occasions are auto highlighted in cells at right, cells B12 through H12.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B13 through H13.",{"$f":"Days+DATE(CalYear,6,1)-WEEKDAY(DATE(CalYear,6,1),(WeekStart=\"Monday\")+1)+29","v":"2019-06-23"},"2019-06-24","2019-06-25","2019-06-26","2019-06-27","2019-06-28","2019-06-29"]
["Holidays or special occasions are auto highlighted in cells at right, cells B14 through H14.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar date is in cell at right and cell C15, and Notes label in cell D15.",{"$f":"Days+DATE(CalYear,6,1)-WEEKDAY(DATE(CalYear,6,1),(WeekStart=\"Monday\")+1)+36","v":"2019-06-30"},"2019-07-01","NOTES"]
["Holidays or special occasions are auto highlighted in cells at right, cells B16 and C16. Enter notes in cell D16 for the entire month.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"July","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]]}
["July month calendar for the year selected in Settings worksheet is auto updated in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Title of this worksheet is in cell at right. Select cell G2 to navigate to June worksheet and cell H2 to navigate to August worksheet. Next instruction is in cell A4.",{"$f":"B9","v":"2019-07-14"},{"$nulls":4},"June","August"]
[]
["Weekdays are in cells at right, cells B4 through H4.","SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
["Calendar dates are in cells at right, cells B5 through H5. If the first cell does not contain number 1, then it’d be a previous month date.",{"$f":"Days+DATE(CalYear,7,1)-WEEKDAY(DATE(CalYear,7,1),(WeekStart=\"Monday\")+1)+1","v":"2019-06-30"},"2019-07-01","2019-07-02","2019-07-03","2019-07-04","2019-07-05","2019-07-06"]
["Holidays or special occasions are auto highlighted in cells at right, cells B6 through H6. ",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Independence Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B7 through H7.",{"$f":"Days+DATE(CalYear,7,1)-WEEKDAY(DATE(CalYear,7,1),(WeekStart=\"Monday\")+1)+8","v":"2019-07-07"},"2019-07-08","2019-07-09","2019-07-10","2019-07-11","2019-07-12","2019-07-13"]
["Holidays or special occasions are auto highlighted in cells at right, cells B8 through H8.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B9 through H9.",{"$f":"Days+DATE(CalYear,7,1)-WEEKDAY(DATE(CalYear,7,1),(WeekStart=\"Monday\")+1)+15","v":"2019-07-14"},"2019-07-15","2019-07-16","2019-07-17","2019-07-18","2019-07-19","2019-07-20"]
["Holidays or special occasions are auto highlighted in cells at right, cells B10 through H10.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B11 through H11.",{"$f":"Days+DATE(CalYear,7,1)-WEEKDAY(DATE(CalYear,7,1),(WeekStart=\"Monday\")+1)+22","v":"2019-07-21"},"2019-07-22","2019-07-23","2019-07-24","2019-07-25","2019-07-26","2019-07-27"]
["Holidays or special occasions are auto highlighted in cells at right, cells B12 through H12.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B13 through H13.",{"$f":"Days+DATE(CalYear,7,1)-WEEKDAY(DATE(CalYear,7,1),(WeekStart=\"Monday\")+1)+29","v":"2019-07-28"},"2019-07-29","2019-07-30","2019-07-31","2019-08-01","2019-08-02","2019-08-03"]
["Holidays or special occasions are auto highlighted in cells at right, cells B14 through H14.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar date is in cell at right and cell C15, and Notes label in cell D15.",{"$f":"Days+DATE(CalYear,7,1)-WEEKDAY(DATE(CalYear,7,1),(WeekStart=\"Monday\")+1)+36","v":"2019-08-04"},"2019-08-05","NOTES"]
["Holidays or special occasions are auto highlighted in cells at right, cells B16 and C16. Enter notes in cell D16 for the entire month.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"August","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]]}
["August month calendar for the year selected in Settings worksheet is auto updated in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Title of this worksheet is in cell at right. Select cell G2 to navigate to July worksheet and cell H2 to navigate to September worksheet. Next instruction is in cell A4.",{"$f":"B9","v":"2019-08-11"},{"$nulls":4},"July","September"]
[]
["Weekdays are in cells at right, cells B4 through H4.","SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
["Calendar dates are in cells at right, cells B5 through H5. If the first cell does not contain number 1, then it’d be a previous month date.",{"$f":"Days+DATE(CalYear,8,1)-WEEKDAY(DATE(CalYear,8,1),(WeekStart=\"Monday\")+1)+1","v":"2019-07-28"},"2019-07-29","2019-07-30","2019-07-31","2019-08-01","2019-08-02","2019-08-03"]
["Holidays or special occasions are auto highlighted in cells at right, cells B6 through H6. ",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B7 through H7.",{"$f":"Days+DATE(CalYear,8,1)-WEEKDAY(DATE(CalYear,8,1),(WeekStart=\"Monday\")+1)+8","v":"2019-08-04"},"2019-08-05","2019-08-06","2019-08-07","2019-08-08","2019-08-09","2019-08-10"]
["Holidays or special occasions are auto highlighted in cells at right, cells B8 through H8.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B9 through H9.",{"$f":"Days+DATE(CalYear,8,1)-WEEKDAY(DATE(CalYear,8,1),(WeekStart=\"Monday\")+1)+15","v":"2019-08-11"},"2019-08-12","2019-08-13","2019-08-14","2019-08-15","2019-08-16","2019-08-17"]
["Holidays or special occasions are auto highlighted in cells at right, cells B10 through H10.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B11 through H11.",{"$f":"Days+DATE(CalYear,8,1)-WEEKDAY(DATE(CalYear,8,1),(WeekStart=\"Monday\")+1)+22","v":"2019-08-18"},"2019-08-19","2019-08-20","2019-08-21","2019-08-22","2019-08-23","2019-08-24"]
["Holidays or special occasions are auto highlighted in cells at right, cells B12 through H12.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B13 through H13.",{"$f":"Days+DATE(CalYear,8,1)-WEEKDAY(DATE(CalYear,8,1),(WeekStart=\"Monday\")+1)+29","v":"2019-08-25"},"2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31"]
["Holidays or special occasions are auto highlighted in cells at right, cells B14 through H14.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar date is in cell at right and cell C15, and Notes label in cell D15.",{"$f":"Days+DATE(CalYear,8,1)-WEEKDAY(DATE(CalYear,8,1),(WeekStart=\"Monday\")+1)+36","v":"2019-09-01"},"2019-09-02","NOTES"]
["Holidays or special occasions are auto highlighted in cells at right, cells B16 and C16. Enter notes in cell D16 for the entire month.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Labor Day"}]

{"sheet":"September","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]]}
["September month calendar for the year selected in Settings worksheet is auto updated in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Title of this worksheet is in cell at right. Select cell G2 to navigate to August worksheet and cell H2 to navigate to October worksheet. Next instruction is in cell A4.",{"$f":"B9","v":"2019-09-15"},{"$nulls":4},"August","October"]
[]
["Weekdays are in cells at right, cells B4 through H4.","SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
["Calendar dates are in cells at right, cells B5 through H5. If the first cell does not contain number 1, then it’d be a previous month date.",{"$f":"Days+DATE(CalYear,9,1)-WEEKDAY(DATE(CalYear,9,1),(WeekStart=\"Monday\")+1)+1","v":"2019-09-01"},"2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07"]
["Holidays or special occasions are auto highlighted in cells at right, cells B6 through H6. ",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Labor Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B7 through H7.",{"$f":"Days+DATE(CalYear,9,1)-WEEKDAY(DATE(CalYear,9,1),(WeekStart=\"Monday\")+1)+8","v":"2019-09-08"},"2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14"]
["Holidays or special occasions are auto highlighted in cells at right, cells B8 through H8.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B9 through H9.",{"$f":"Days+DATE(CalYear,9,1)-WEEKDAY(DATE(CalYear,9,1),(WeekStart=\"Monday\")+1)+15","v":"2019-09-15"},"2019-09-16","2019-09-17","2019-09-18","2019-09-19","2019-09-20","2019-09-21"]
["Holidays or special occasions are auto highlighted in cells at right, cells B10 through H10.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B11 through H11.",{"$f":"Days+DATE(CalYear,9,1)-WEEKDAY(DATE(CalYear,9,1),(WeekStart=\"Monday\")+1)+22","v":"2019-09-22"},"2019-09-23","2019-09-24","2019-09-25","2019-09-26","2019-09-27","2019-09-28"]
["Holidays or special occasions are auto highlighted in cells at right, cells B12 through H12.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B13 through H13.",{"$f":"Days+DATE(CalYear,9,1)-WEEKDAY(DATE(CalYear,9,1),(WeekStart=\"Monday\")+1)+29","v":"2019-09-29"},"2019-09-30","2019-10-01","2019-10-02","2019-10-03","2019-10-04","2019-10-05"]
["Holidays or special occasions are auto highlighted in cells at right, cells B14 through H14.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar date is in cell at right and cell C15, and Notes label in cell D15.",{"$f":"Days+DATE(CalYear,9,1)-WEEKDAY(DATE(CalYear,9,1),(WeekStart=\"Monday\")+1)+36","v":"2019-10-06"},"2019-10-07","NOTES"]
["Holidays or special occasions are auto highlighted in cells at right, cells B16 and C16. Enter notes in cell D16 for the entire month.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"October","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]]}
["October month calendar for the year selected in Settings worksheet is auto updated in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Title of this worksheet is in cell at right. Select cell G2 to navigate to September worksheet and cell H2 to navigate to November worksheet. Next instruction is in cell A4.",{"$f":"B9","v":"2019-10-13"},{"$nulls":4},"September","November"]
[]
["Weekdays are in cells at right, cells B4 through H4.","SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
["Calendar dates are in cells at right, cells B5 through H5. If the first cell does not contain number 1, then it’d be a previous month date.",{"$f":"Days+DATE(CalYear,10,1)-WEEKDAY(DATE(CalYear,10,1),(WeekStart=\"Monday\")+1)+1","v":"2019-09-29"},"2019-09-30","2019-10-01","2019-10-02","2019-10-03","2019-10-04","2019-10-05"]
["Holidays or special occasions are auto highlighted in cells at right, cells B6 through H6. ",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B7 through H7.",{"$f":"Days+DATE(CalYear,10,1)-WEEKDAY(DATE(CalYear,10,1),(WeekStart=\"Monday\")+1)+8","v":"2019-10-06"},"2019-10-07","2019-10-08","2019-10-09","2019-10-10","2019-10-11","2019-10-12"]
["Holidays or special occasions are auto highlighted in cells at right, cells B8 through H8.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B9 through H9.",{"$f":"Days+DATE(CalYear,10,1)-WEEKDAY(DATE(CalYear,10,1),(WeekStart=\"Monday\")+1)+15","v":"2019-10-13"},"2019-10-14","2019-10-15","2019-10-16","2019-10-17","2019-10-18","2019-10-19"]
["Holidays or special occasions are auto highlighted in cells at right, cells B10 through H10.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Columbus Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B11 through H11.",{"$f":"Days+DATE(CalYear,10,1)-WEEKDAY(DATE(CalYear,10,1),(WeekStart=\"Monday\")+1)+22","v":"2019-10-20"},"2019-10-21","2019-10-22","2019-10-23","2019-10-24","2019-10-25","2019-10-26"]
["Holidays or special occasions are auto highlighted in cells at right, cells B12 through H12.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B13 through H13.",{"$f":"Days+DATE(CalYear,10,1)-WEEKDAY(DATE(CalYear,10,1),(WeekStart=\"Monday\")+1)+29","v":"2019-10-27"},"2019-10-28","2019-10-29","2019-10-30","2019-10-31","2019-11-01","2019-11-02"]
["Holidays or special occasions are auto highlighted in cells at right, cells B14 through H14.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar date is in cell at right and cell C15, and Notes label in cell D15.",{"$f":"Days+DATE(CalYear,10,1)-WEEKDAY(DATE(CalYear,10,1),(WeekStart=\"Monday\")+1)+36","v":"2019-11-03"},"2019-11-04","NOTES"]
["Holidays or special occasions are auto highlighted in cells at right, cells B16 and C16. Enter notes in cell D16 for the entire month.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"November","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]]}
["November month calendar for the year selected in Settings worksheet is auto updated in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Title of this worksheet is in cell at right. Select cell G2 to navigate to October worksheet and cell H2 to navigate to December worksheet. Next instruction is in cell A4.",{"$f":"B9","v":"2019-11-10"},{"$nulls":4},"October","December"]
[]
["Weekdays are in cells at right, cells B4 through H4.","SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
["Calendar dates are in cells at right, cells B5 through H5. If the first cell does not contain number 1, then it’d be a previous month date.",{"$f":"Days+DATE(CalYear,11,1)-WEEKDAY(DATE(CalYear,11,1),(WeekStart=\"Monday\")+1)+1","v":"2019-10-27"},"2019-10-28","2019-10-29","2019-10-30","2019-10-31","2019-11-01","2019-11-02"]
["Holidays or special occasions are auto highlighted in cells at right, cells B6 through H6. ",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B7 through H7.",{"$f":"Days+DATE(CalYear,11,1)-WEEKDAY(DATE(CalYear,11,1),(WeekStart=\"Monday\")+1)+8","v":"2019-11-03"},"2019-11-04","2019-11-05","2019-11-06","2019-11-07","2019-11-08","2019-11-09"]
["Holidays or special occasions are auto highlighted in cells at right, cells B8 through H8. ",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B9 through H9.",{"$f":"Days+DATE(CalYear,11,1)-WEEKDAY(DATE(CalYear,11,1),(WeekStart=\"Monday\")+1)+15","v":"2019-11-10"},"2019-11-11","2019-11-12","2019-11-13","2019-11-14","2019-11-15","2019-11-16"]
["Holidays or special occasions are auto highlighted in cells at right, cells B10 through H10.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Veterans Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B11 through H11.",{"$f":"Days+DATE(CalYear,11,1)-WEEKDAY(DATE(CalYear,11,1),(WeekStart=\"Monday\")+1)+22","v":"2019-11-17"},"2019-11-18","2019-11-19","2019-11-20","2019-11-21","2019-11-22","2019-11-23"]
["Holidays or special occasions are auto highlighted in cells at right, cells B12 through H12.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B13 through H13.",{"$f":"Days+DATE(CalYear,11,1)-WEEKDAY(DATE(CalYear,11,1),(WeekStart=\"Monday\")+1)+29","v":"2019-11-24"},"2019-11-25","2019-11-26","2019-11-27","2019-11-28","2019-11-29","2019-11-30"]
["Holidays or special occasions are auto highlighted in cells at right, cells B14 through H14.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Thanksgiving Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar date is in cell at right and cell C15, and Notes label in cell D15.",{"$f":"Days+DATE(CalYear,11,1)-WEEKDAY(DATE(CalYear,11,1),(WeekStart=\"Monday\")+1)+36","v":"2019-12-01"},"2019-12-02","NOTES"]
["Holidays or special occasions are auto highlighted in cells at right, cells B16 and C16. Enter notes in cell D16 for the entire month.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"December","index":13,"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]]}
["December month calendar for the year selected in Settings worksheet is auto updated in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Title of this worksheet is in cell at right. Select cell G2 to navigate to November worksheet and cell H2 to navigate to Holidays worksheet. Next instruction is in cell A4.",{"$f":"B9","v":"2019-12-15"},{"$nulls":4},"November","Holidays"]
[]
["Weekdays are in cells at right, cells B4 through H4.","SUNDAY",{"$f":"UPPER(TEXT(C5,\"dddd\"))","v":"MONDAY"},"TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","SATURDAY"]
["Calendar dates are in cells at right, cells B5 through H5. If the first cell does not contain number 1, then it’d be a previous month date.",{"$f":"Days+DATE(CalYear,12,1)-WEEKDAY(DATE(CalYear,12,1),(WeekStart=\"Monday\")+1)+1","v":"2019-12-01"},"2019-12-02","2019-12-03","2019-12-04","2019-12-05","2019-12-06","2019-12-07"]
["Holidays or special occasions are auto highlighted in cells at right, cells B6 through H6. ",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(B5)>15)+(ROW()>6),MONTH(B5),DAY(B5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(C5)>15)+(ROW()>6),MONTH(C5),DAY(C5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(D5)>15)+(ROW()>6),MONTH(D5),DAY(D5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(E5)>15)+(ROW()>6),MONTH(E5),DAY(E5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(F5)>15)+(ROW()>6),MONTH(F5),DAY(F5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(G5)>15)+(ROW()>6),MONTH(G5),DAY(G5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear-(DAY(H5)>15)+(ROW()>6),MONTH(H5),DAY(H5)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B7 through H7.",{"$f":"Days+DATE(CalYear,12,1)-WEEKDAY(DATE(CalYear,12,1),(WeekStart=\"Monday\")+1)+8","v":"2019-12-08"},"2019-12-09","2019-12-10","2019-12-11","2019-12-12","2019-12-13","2019-12-14"]
["Holidays or special occasions are auto highlighted in cells at right, cells B8 through H8. ",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B7),DAY(B7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C7),DAY(C7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D7),DAY(D7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E7),DAY(E7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F7),DAY(F7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G7),DAY(G7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H7),DAY(H7)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B9 through H9.",{"$f":"Days+DATE(CalYear,12,1)-WEEKDAY(DATE(CalYear,12,1),(WeekStart=\"Monday\")+1)+15","v":"2019-12-15"},"2019-12-16","2019-12-17","2019-12-18","2019-12-19","2019-12-20","2019-12-21"]
["Holidays or special occasions are auto highlighted in cells at right, cells B10 through H10.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B9),DAY(B9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C9),DAY(C9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D9),DAY(D9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E9),DAY(E9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F9),DAY(F9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G9),DAY(G9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H9),DAY(H9)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B11 through H11.",{"$f":"Days+DATE(CalYear,12,1)-WEEKDAY(DATE(CalYear,12,1),(WeekStart=\"Monday\")+1)+22","v":"2019-12-22"},"2019-12-23","2019-12-24","2019-12-25","2019-12-26","2019-12-27","2019-12-28"]
["Holidays or special occasions are auto highlighted in cells at right, cells B12 through H12.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B11),DAY(B11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C11),DAY(C11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D11),DAY(D11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E11),DAY(E11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"Christmas Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F11),DAY(F11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G11),DAY(G11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H11),DAY(H11)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar dates are in cells at right, cells B13 through H13.",{"$f":"Days+DATE(CalYear,12,1)-WEEKDAY(DATE(CalYear,12,1),(WeekStart=\"Monday\")+1)+29","v":"2019-12-29"},"2019-12-30","2019-12-31","2020-01-01","2020-01-02","2020-01-03","2020-01-04"]
["Holidays or special occasions are auto highlighted in cells at right, cells B14 through H14.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B13),DAY(B13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C13),DAY(C13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(D13),DAY(D13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(E13),DAY(E13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":"New Years Day"},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(F13),DAY(F13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(G13),DAY(G13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(H13),DAY(H13)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]
["Calendar date is in cell at right and cell C15, and Notes label in cell D15.",{"$f":"Days+DATE(CalYear,12,1)-WEEKDAY(DATE(CalYear,12,1),(WeekStart=\"Monday\")+1)+36","v":"2020-01-05"},"2020-01-06","NOTES"]
["Holidays or special occasions are auto highlighted in cells at right, cells B16 and C16. Enter notes in cell D16 for the entire month.",{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(B15),DAY(B15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ShowHolidays,IF(INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),6),INDEX(Holidays[],MATCH(DATE(CalYear,MONTH(C15),DAY(C15)),IF(ShowObserved,Holidays[CORRECTED],Holidays[DAY]),0),2),\"\"),\"\"),\"\")","v":""}]

{"sheet":"Holidays","index":14,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[15,1,28,2]]}
["Use the US Holidays list as provided in this worksheet, or customize it per requirements. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Title of this worksheet is in cell at right. Select cell E2 to navigate to December worksheet and cell F2 to navigate to Settings worksheet. Next instruction is in cell A4.","US Holidays",null,null,"December","Settings",null," "]
[]
["Enter or modify holidays and other details in Holidays table starting in cell at right.","DAY","HOLIDAY","FALLS ON","WEEKDAY","CORRECTED","SHOW"]
[null,{"$f":"DATE(CalYear,1,1)","v":"2019-01-01"},"New Years Day","January 1",{"$f":"IFERROR(WEEKDAY(Holidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":3},{"$f":"IF(ISTEXT(Holidays[[#This Row],[DAY]]),\"Not Observed\",IF(Holidays[[#This Row],[WEEKDAY]]=1,Holidays[[#This Row],[DAY]]+1,IF(Holidays[[#This Row],[WEEKDAY]]=7,Holidays[[#This Row],[DAY]]-1,Holidays[[#This Row],[DAY]])))","v":"2019-01-01"},true]
[null,{"$f":"DATE(CalYear,1,1+((3-(2>=WEEKDAY(DATE(CalYear,1,1))))*7)+(2-WEEKDAY(DATE(CalYear,1,1))))","v":"2019-01-21"},{"$f":"IF(COUNTIF(Holidays[DAY],Holidays[[#This Row],[DAY]])>1,\"Martin Luther King, Jr. Day *\",\"Martin Luther King, Jr. Day\")","v":"Martin Luther King, Jr. Day"},"Third Monday of January",{"$f":"IFERROR(WEEKDAY(Holidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(Holidays[[#This Row],[DAY]]),\"Not Observed\",IF(Holidays[[#This Row],[WEEKDAY]]=1,Holidays[[#This Row],[DAY]]+1,IF(Holidays[[#This Row],[WEEKDAY]]=7,Holidays[[#This Row],[DAY]]-1,Holidays[[#This Row],[DAY]])))","v":"2019-01-21"},true]
[null,{"$f":"IF(MOD(CalYear,4)=1,DATE(CalYear,1,20)+(WEEKDAY(DATE(CalYear,1,20))=1),\"Not observed\")","v":"Not observed"},"Inaguration Day","January 20, every fourth year, following Presidential election",{"$f":"IFERROR(WEEKDAY(Holidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":0},{"$f":"IF(ISTEXT(Holidays[[#This Row],[DAY]]),\"Not Observed\",IF(Holidays[[#This Row],[WEEKDAY]]=1,Holidays[[#This Row],[DAY]]+1,IF(Holidays[[#This Row],[WEEKDAY]]=7,Holidays[[#This Row],[DAY]]-1,Holidays[[#This Row],[DAY]])))","v":"Not Observed"},true]
[null,{"$f":"DATE(CalYear,2,1+((3-(2>=WEEKDAY(DATE(CalYear,2,1))))*7)+(2-WEEKDAY(DATE(CalYear,2,1))))","v":"2019-02-18"},"Presidents Day","Third Monday in February",{"$f":"IFERROR(WEEKDAY(Holidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(Holidays[[#This Row],[DAY]]),\"Not Observed\",IF(Holidays[[#This Row],[WEEKDAY]]=1,Holidays[[#This Row],[DAY]]+1,IF(Holidays[[#This Row],[WEEKDAY]]=7,Holidays[[#This Row],[DAY]]-1,Holidays[[#This Row],[DAY]])))","v":"2019-02-18"},true]
[null,{"$f":"DATE(CalYear,5,1+((MayMondays-(2>=WEEKDAY(DATE(CalYear,5,1))))*7)+(2-WEEKDAY(DATE(CalYear,5,1))))","v":"2019-05-27"},"Memorial Day","Last Monday in May",{"$f":"IFERROR(WEEKDAY(Holidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(Holidays[[#This Row],[DAY]]),\"Not Observed\",IF(Holidays[[#This Row],[WEEKDAY]]=1,Holidays[[#This Row],[DAY]]+1,IF(Holidays[[#This Row],[WEEKDAY]]=7,Holidays[[#This Row],[DAY]]-1,Holidays[[#This Row],[DAY]])))","v":"2019-05-27"},true]
[null,{"$f":"DATE(CalYear,7,4)","v":"2019-07-04"},"Independence Day","July 4",{"$f":"IFERROR(WEEKDAY(Holidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":5},{"$f":"IF(ISTEXT(Holidays[[#This Row],[DAY]]),\"Not Observed\",IF(Holidays[[#This Row],[WEEKDAY]]=1,Holidays[[#This Row],[DAY]]+1,IF(Holidays[[#This Row],[WEEKDAY]]=7,Holidays[[#This Row],[DAY]]-1,Holidays[[#This Row],[DAY]])))","v":"2019-07-04"},true]
[null,{"$f":"DATE(CalYear,9,1+((1-(2>=WEEKDAY(DATE(CalYear,9,1))))*7)+(2-WEEKDAY(DATE(CalYear,9,1))))","v":"2019-09-02"},"Labor Day","First Monday in September",{"$f":"IFERROR(WEEKDAY(Holidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(Holidays[[#This Row],[DAY]]),\"Not Observed\",IF(Holidays[[#This Row],[WEEKDAY]]=1,Holidays[[#This Row],[DAY]]+1,IF(Holidays[[#This Row],[WEEKDAY]]=7,Holidays[[#This Row],[DAY]]-1,Holidays[[#This Row],[DAY]])))","v":"2019-09-02"},true]
[null,{"$f":"DATE(CalYear,10,1+((2-(2>=WEEKDAY(DATE(CalYear,10,1))))*7)+(2-WEEKDAY(DATE(CalYear,10,1))))","v":"2019-10-14"},"Columbus Day","Second Monday in October",{"$f":"IFERROR(WEEKDAY(Holidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(Holidays[[#This Row],[DAY]]),\"Not Observed\",IF(Holidays[[#This Row],[WEEKDAY]]=1,Holidays[[#This Row],[DAY]]+1,IF(Holidays[[#This Row],[WEEKDAY]]=7,Holidays[[#This Row],[DAY]]-1,Holidays[[#This Row],[DAY]])))","v":"2019-10-14"},true]
[null,{"$f":"DATE(CalYear,11,11)","v":"2019-11-11"},"Veterans Day","November 11",{"$f":"IFERROR(WEEKDAY(Holidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":2},{"$f":"IF(ISTEXT(Holidays[[#This Row],[DAY]]),\"Not Observed\",IF(Holidays[[#This Row],[WEEKDAY]]=1,Holidays[[#This Row],[DAY]]+1,IF(Holidays[[#This Row],[WEEKDAY]]=7,Holidays[[#This Row],[DAY]]-1,Holidays[[#This Row],[DAY]])))","v":"2019-11-11"},true]
[null,{"$f":"DATE(CalYear,11,1+((4-(5>=WEEKDAY(DATE(CalYear,11,1))))*7)+(5-WEEKDAY(DATE(CalYear,11,1))))","v":"2019-11-28"},"Thanksgiving Day","Fourth Thursday in November",{"$f":"IFERROR(WEEKDAY(Holidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":5},{"$f":"IF(ISTEXT(Holidays[[#This Row],[DAY]]),\"Not Observed\",IF(Holidays[[#This Row],[WEEKDAY]]=1,Holidays[[#This Row],[DAY]]+1,IF(Holidays[[#This Row],[WEEKDAY]]=7,Holidays[[#This Row],[DAY]]-1,Holidays[[#This Row],[DAY]])))","v":"2019-11-28"},true]
[null,{"$f":"DATE(CalYear,12,25)","v":"2019-12-25"},"Christmas Day","December 25",{"$f":"IFERROR(WEEKDAY(Holidays[[#This Row],[DAY]],IF(WeekStart=\"MONDAY\",2,1)),0)","v":4},{"$f":"IF(ISTEXT(Holidays[[#This Row],[DAY]]),\"Not Observed\",IF(Holidays[[#This Row],[WEEKDAY]]=1,Holidays[[#This Row],[DAY]]+1,IF(Holidays[[#This Row],[WEEKDAY]]=7,Holidays[[#This Row],[DAY]]-1,Holidays[[#This Row],[DAY]])))","v":"2019-12-25"},true]
[null,"Tip:\nThese dates will automatically adjust for you. You can show or not show holidays as you want by changing the SHOW column.\n\nThe CORRECTED column will change if the observed holiday needs to fall on a weekday.  Sunday will be observed on the following Monday, and Saturday will be observed on the previous Friday.\n\nYou can add other holidays as well."]