{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","12-Month","18-Month","12-Month (no holidays)","Tables"],"not_rendered":{"defined_names":7,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":25,"n_cols":2,"rows_kept":25,"merged":[[0,0,0,1]]}
["About Sri's Compact Calendar"]
["US : WEEK STARTING MONDAY"]
[]
["SET START DATE >","2024-01-01"]
[null,"If you need to change the starting date, just update it above. This is the default for each of the three styles of calendar in this spreadsheet. You can override each individual calendar's start date as well."]
[]
["About Compact Calendar","I use this calendar template for project estimating. It's compact, easy to print, and most importantly allows me to visualize time as blocks."]
[]
["Using the  Calendar","I usually just circle the starting dates of a task, then run a line out to the right side where I can make a note as to what it is. With the amount of whitespace available on the right, there's plenty of room to leave notes. After I'm done, I then either make a clean version with another sheet of paper, or type up the dates right on a copy of this spreadsheet"]
[]
["Printing Partial Calendars","Just select the rows I need then PRINT SELECTION from the print dialog. The headers/footers will be added automatically."]
[]
["Adding Holidays","The 'Tables' worksheet tab has a list of holidays that you can change. The capability for calculating holidays automatically have been added; please study the formulas to see how it works."]
[]
["Day Abbreviations","Change the WEEKDAY TABLE on the 'Tables' worksheet. Useful for localizing to other languages."]
[]
["Enjoy! ","Click on the CALENDAR worksheet tab below to see the calendar itself"]
[]
["Credits","Auto-calculation of first day based on year cell provided by Todd Foster http://www.boidem.org/"]
[null,"Automatic month calculation tip from Jim Service and \"Jenny\""]
[null,"Auto calculations of holidays from: http://cpearson.com"]
[null,"Month boundary trick from Daniel Kinal of Melbourne, Australia"]
[null,"ISO 8601 Week Information and calculation from http://www.rondebruin.nl/weeknumber.htm"]
[]
["Detailed Instructions","https://davidseah.com/node/compact-calendar/"]

{"sheet":"12-Month","index":1,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[0,4,0,10],[60,0,60,10]]}
["STARTING DATE",{"$nulls":3},{"$f":"Instructions!B4","v":"2024-01-01"}]
[{"$f":"CONCATENATE(\" Compact Calendar \",YEAR(E1))","v":" Compact Calendar 2024"}]
[]
["#",null,"MONTH",null,{"$f":"VLOOKUP(WEEKDAY(E6),Tables!$A$45:$B$51,2)","v":"Mo"},{"$f":"VLOOKUP(WEEKDAY(F6),Tables!$A$45:$B$51,2)","v":"Tu"},{"$f":"VLOOKUP(WEEKDAY(G6),Tables!$A$45:$B$51,2)","v":"We"},{"$f":"VLOOKUP(WEEKDAY(H6),Tables!$A$45:$B$51,2)","v":"Th"},{"$f":"VLOOKUP(WEEKDAY(I6),Tables!$A$45:$B$51,2)","v":"Fr"},{"$f":"VLOOKUP(WEEKDAY(J6),Tables!$A$45:$B$51,2)","v":"Sa"},{"$f":"VLOOKUP(WEEKDAY(K6),Tables!$A$45:$B$51,2)","v":"Sun"}]
[]
[{"$f":"INT((E6-DATE(YEAR(E6-WEEKDAY(E6-1)+4),1,3)+WEEKDAY(DATE(YEAR(E6-WEEKDAY(E6-1)+4),1,3))+ 5)/7)","v":52},null,{"$f":"IF(SUM(1*(DAY(E6:K6)=1))>0,K6,\"\")","v":""},null,{"$f":"F6-1","v":"2023-12-25"},"2023-12-26","2023-12-27","2023-12-28","2023-12-29","2023-12-30",{"$f":"$E$1-WEEKDAY($E$1)+1","v":"2023-12-31"}]
[{"$f":"INT((E7-DATE(YEAR(E7-WEEKDAY(E7-1)+4),1,3)+WEEKDAY(DATE(YEAR(E7-WEEKDAY(E7-1)+4),1,3))+ 5)/7)","v":1},null,{"$f":"IF(SUM(1*(DAY(E7:K7)=1))>0,K7,\"\")","v":"2024-01-07"},null,{"$f":"K6+1","v":"2024-01-01"},{"$f":"E7+1","v":"2024-01-02"},"2024-01-03","2024-01-04","2024-01-05","2024-01-06","2024-01-07"]
[{"$f":"INT((E8-DATE(YEAR(E8-WEEKDAY(E8-1)+4),1,3)+WEEKDAY(DATE(YEAR(E8-WEEKDAY(E8-1)+4),1,3))+ 5)/7)","v":2},null,{"$f":"IF(SUM(1*(DAY(E8:K8)=1))>0,K8,\"\")","v":""},null,"2024-01-08",{"$f":"E8+1","v":"2024-01-09"},{"$f":"F8+1","v":"2024-01-10"},"2024-01-11","2024-01-12","2024-01-13","2024-01-14"]
[3,null,{"$f":"IF(SUM(1*(DAY(E9:K9)=1))>0,K9,\"\")","v":""},null,"2024-01-15","2024-01-16","2024-01-17","2024-01-18","2024-01-19","2024-01-20","2024-01-21"]
[4,null,{"$f":"IF(SUM(1*(DAY(E10:K10)=1))>0,K10,\"\")","v":""},null,"2024-01-22","2024-01-23","2024-01-24","2024-01-25","2024-01-26","2024-01-27","2024-01-28"]
[5,null,{"$f":"IF(SUM(1*(DAY(E11:K11)=1))>0,K11,\"\")","v":"2024-02-04"},null,"2024-01-29","2024-01-30","2024-01-31","2024-02-01","2024-02-02","2024-02-03","2024-02-04"]
[6,null,{"$f":"IF(SUM(1*(DAY(E12:K12)=1))>0,K12,\"\")","v":""},null,"2024-02-05","2024-02-06","2024-02-07","2024-02-08","2024-02-09","2024-02-10","2024-02-11"]
[7,null,{"$f":"IF(SUM(1*(DAY(E13:K13)=1))>0,K13,\"\")","v":""},null,"2024-02-12","2024-02-13","2024-02-14","2024-02-15","2024-02-16","2024-02-17","2024-02-18"]
[8,null,{"$f":"IF(SUM(1*(DAY(E14:K14)=1))>0,K14,\"\")","v":""},null,"2024-02-19","2024-02-20","2024-02-21","2024-02-22","2024-02-23","2024-02-24","2024-02-25"]
[9,null,{"$f":"IF(SUM(1*(DAY(E15:K15)=1))>0,K15,\"\")","v":"2024-03-03"},null,"2024-02-26","2024-02-27","2024-02-28","2024-02-29","2024-03-01","2024-03-02","2024-03-03"]
[10,null,{"$f":"IF(SUM(1*(DAY(E16:K16)=1))>0,K16,\"\")","v":""},null,"2024-03-04","2024-03-05","2024-03-06","2024-03-07","2024-03-08","2024-03-09","2024-03-10"]
[11,null,{"$f":"IF(SUM(1*(DAY(E17:K17)=1))>0,K17,\"\")","v":""},null,"2024-03-11","2024-03-12","2024-03-13","2024-03-14","2024-03-15","2024-03-16","2024-03-17"]
[12,null,{"$f":"IF(SUM(1*(DAY(E18:K18)=1))>0,K18,\"\")","v":""},null,"2024-03-18","2024-03-19","2024-03-20","2024-03-21","2024-03-22","2024-03-23","2024-03-24"]
[13,null,{"$f":"IF(SUM(1*(DAY(E19:K19)=1))>0,K19,\"\")","v":""},null,"2024-03-25","2024-03-26","2024-03-27","2024-03-28","2024-03-29","2024-03-30","2024-03-31"]
[14,null,{"$f":"IF(SUM(1*(DAY(E20:K20)=1))>0,K20,\"\")","v":"2024-04-07"},null,"2024-04-01","2024-04-02","2024-04-03","2024-04-04","2024-04-05","2024-04-06","2024-04-07"]
[15,null,{"$f":"IF(SUM(1*(DAY(E21:K21)=1))>0,K21,\"\")","v":""},null,"2024-04-08","2024-04-09","2024-04-10","2024-04-11","2024-04-12","2024-04-13","2024-04-14"]
[16,null,{"$f":"IF(SUM(1*(DAY(E22:K22)=1))>0,K22,\"\")","v":""},null,"2024-04-15","2024-04-16","2024-04-17","2024-04-18","2024-04-19","2024-04-20","2024-04-21"]
[17,null,{"$f":"IF(SUM(1*(DAY(E23:K23)=1))>0,K23,\"\")","v":""},null,"2024-04-22","2024-04-23","2024-04-24","2024-04-25","2024-04-26","2024-04-27","2024-04-28"]
[18,null,{"$f":"IF(SUM(1*(DAY(E24:K24)=1))>0,K24,\"\")","v":"2024-05-05"},null,"2024-04-29","2024-04-30","2024-05-01","2024-05-02","2024-05-03","2024-05-04","2024-05-05"]
[19,null,{"$f":"IF(SUM(1*(DAY(E25:K25)=1))>0,K25,\"\")","v":""},null,"2024-05-06","2024-05-07","2024-05-08","2024-05-09","2024-05-10","2024-05-11","2024-05-12"]
[20,null,{"$f":"IF(SUM(1*(DAY(E26:K26)=1))>0,K26,\"\")","v":""},null,"2024-05-13","2024-05-14","2024-05-15","2024-05-16","2024-05-17","2024-05-18","2024-05-19"]
[21,null,{"$f":"IF(SUM(1*(DAY(E27:K27)=1))>0,K27,\"\")","v":""},null,"2024-05-20","2024-05-21","2024-05-22","2024-05-23","2024-05-24","2024-05-25","2024-05-26"]
[22,null,{"$f":"IF(SUM(1*(DAY(E28:K28)=1))>0,K28,\"\")","v":"2024-06-02"},null,"2024-05-27","2024-05-28","2024-05-29","2024-05-30","2024-05-31","2024-06-01","2024-06-02"]
[23,null,{"$f":"IF(SUM(1*(DAY(E29:K29)=1))>0,K29,\"\")","v":""},null,"2024-06-03","2024-06-04","2024-06-05","2024-06-06","2024-06-07","2024-06-08","2024-06-09"]
[24,null,{"$f":"IF(SUM(1*(DAY(E30:K30)=1))>0,K30,\"\")","v":""},null,"2024-06-10","2024-06-11","2024-06-12","2024-06-13","2024-06-14","2024-06-15","2024-06-16"]
[25,null,{"$f":"IF(SUM(1*(DAY(E31:K31)=1))>0,K31,\"\")","v":""},null,"2024-06-17","2024-06-18","2024-06-19","2024-06-20","2024-06-21","2024-06-22","2024-06-23"]
[26,null,{"$f":"IF(SUM(1*(DAY(E32:K32)=1))>0,K32,\"\")","v":""},null,"2024-06-24","2024-06-25","2024-06-26","2024-06-27","2024-06-28","2024-06-29","2024-06-30"]
[27,null,{"$f":"IF(SUM(1*(DAY(E33:K33)=1))>0,K33,\"\")","v":"2024-07-07"},null,"2024-07-01","2024-07-02","2024-07-03","2024-07-04","2024-07-05","2024-07-06","2024-07-07"]
[28,null,{"$f":"IF(SUM(1*(DAY(E34:K34)=1))>0,K34,\"\")","v":""},null,"2024-07-08","2024-07-09","2024-07-10","2024-07-11","2024-07-12","2024-07-13","2024-07-14"]
[29,null,{"$f":"IF(SUM(1*(DAY(E35:K35)=1))>0,K35,\"\")","v":""},null,"2024-07-15","2024-07-16","2024-07-17","2024-07-18","2024-07-19","2024-07-20","2024-07-21"]
[30,null,{"$f":"IF(SUM(1*(DAY(E36:K36)=1))>0,K36,\"\")","v":""},null,"2024-07-22","2024-07-23","2024-07-24","2024-07-25","2024-07-26","2024-07-27","2024-07-28"]
[31,null,{"$f":"IF(SUM(1*(DAY(E37:K37)=1))>0,K37,\"\")","v":"2024-08-04"},null,"2024-07-29","2024-07-30","2024-07-31","2024-08-01","2024-08-02","2024-08-03","2024-08-04"]
[32,null,{"$f":"IF(SUM(1*(DAY(E38:K38)=1))>0,K38,\"\")","v":""},null,"2024-08-05","2024-08-06","2024-08-07","2024-08-08","2024-08-09","2024-08-10","2024-08-11"]
[33,null,{"$f":"IF(SUM(1*(DAY(E39:K39)=1))>0,K39,\"\")","v":""},null,"2024-08-12","2024-08-13","2024-08-14","2024-08-15","2024-08-16","2024-08-17","2024-08-18"]
[34,null,{"$f":"IF(SUM(1*(DAY(E40:K40)=1))>0,K40,\"\")","v":""},null,{"$f":"K39+1","v":"2024-08-19"},{"$f":"E40+1","v":"2024-08-20"},"2024-08-21","2024-08-22","2024-08-23","2024-08-24","2024-08-25"]
[35,null,{"$f":"IF(SUM(1*(DAY(E41:K41)=1))>0,K41,\"\")","v":"2024-09-01"},null,"2024-08-26","2024-08-27","2024-08-28","2024-08-29","2024-08-30","2024-08-31","2024-09-01"]
[36,null,{"$f":"IF(SUM(1*(DAY(E42:K42)=1))>0,K42,\"\")","v":""},null,"2024-09-02","2024-09-03","2024-09-04","2024-09-05","2024-09-06","2024-09-07","2024-09-08"]
[37,null,{"$f":"IF(SUM(1*(DAY(E43:K43)=1))>0,K43,\"\")","v":""},null,"2024-09-09","2024-09-10","2024-09-11","2024-09-12","2024-09-13","2024-09-14","2024-09-15"]
[38,null,{"$f":"IF(SUM(1*(DAY(E44:K44)=1))>0,K44,\"\")","v":""},null,"2024-09-16","2024-09-17","2024-09-18","2024-09-19","2024-09-20","2024-09-21","2024-09-22"]
[39,null,{"$f":"IF(SUM(1*(DAY(E45:K45)=1))>0,K45,\"\")","v":""},null,"2024-09-23","2024-09-24","2024-09-25","2024-09-26","2024-09-27","2024-09-28","2024-09-29"]
[40,null,{"$f":"IF(SUM(1*(DAY(E46:K46)=1))>0,K46,\"\")","v":"2024-10-06"},null,"2024-09-30","2024-10-01","2024-10-02","2024-10-03","2024-10-04","2024-10-05","2024-10-06"]
[41,null,{"$f":"IF(SUM(1*(DAY(E47:K47)=1))>0,K47,\"\")","v":""},null,"2024-10-07","2024-10-08","2024-10-09","2024-10-10","2024-10-11","2024-10-12","2024-10-13"]
[42,null,{"$f":"IF(SUM(1*(DAY(E48:K48)=1))>0,K48,\"\")","v":""},null,"2024-10-14","2024-10-15","2024-10-16","2024-10-17","2024-10-18","2024-10-19","2024-10-20"]
[43,null,{"$f":"IF(SUM(1*(DAY(E49:K49)=1))>0,K49,\"\")","v":""},null,"2024-10-21","2024-10-22","2024-10-23","2024-10-24","2024-10-25","2024-10-26","2024-10-27"]
[44,null,{"$f":"IF(SUM(1*(DAY(E50:K50)=1))>0,K50,\"\")","v":"2024-11-03"},null,"2024-10-28","2024-10-29","2024-10-30","2024-10-31","2024-11-01","2024-11-02","2024-11-03"]
[45,null,{"$f":"IF(SUM(1*(DAY(E51:K51)=1))>0,K51,\"\")","v":""},null,"2024-11-04","2024-11-05","2024-11-06","2024-11-07","2024-11-08","2024-11-09","2024-11-10"]
[46,null,{"$f":"IF(SUM(1*(DAY(E52:K52)=1))>0,K52,\"\")","v":""},null,"2024-11-11","2024-11-12","2024-11-13","2024-11-14","2024-11-15","2024-11-16","2024-11-17"]
[47,null,{"$f":"IF(SUM(1*(DAY(E53:K53)=1))>0,K53,\"\")","v":""},null,"2024-11-18","2024-11-19","2024-11-20","2024-11-21",{"$f":"H53+1","v":"2024-11-22"},"2024-11-23","2024-11-24"]
[48,null,{"$f":"IF(SUM(1*(DAY(E54:K54)=1))>0,K54,\"\")","v":"2024-12-01"},null,"2024-11-25","2024-11-26","2024-11-27","2024-11-28","2024-11-29","2024-11-30","2024-12-01"]
[49,null,{"$f":"IF(SUM(1*(DAY(E55:K55)=1))>0,K55,\"\")","v":""},null,"2024-12-02","2024-12-03","2024-12-04","2024-12-05","2024-12-06","2024-12-07","2024-12-08"]
[50,null,{"$f":"IF(SUM(1*(DAY(E56:K56)=1))>0,K56,\"\")","v":""},null,"2024-12-09","2024-12-10","2024-12-11","2024-12-12","2024-12-13","2024-12-14","2024-12-15"]
[51,null,{"$f":"IF(SUM(1*(DAY(E57:K57)=1))>0,K57,\"\")","v":""},null,"2024-12-16","2024-12-17","2024-12-18","2024-12-19","2024-12-20","2024-12-21","2024-12-22"]
[52,null,{"$f":"IF(SUM(1*(DAY(E58:K58)=1))>0,K58,\"\")","v":""},null,"2024-12-23","2024-12-24","2024-12-25","2024-12-26","2024-12-27","2024-12-28","2024-12-29"]
[1,null,{"$f":"IF(SUM(1*(DAY(E59:K59)=1))>0,K59,\"\")","v":"2025-01-05"},null,"2024-12-30","2024-12-31",{"$f":"F59+1","v":"2025-01-01"},{"$f":"G59+1","v":"2025-01-02"},{"$f":"H59+1","v":"2025-01-03"},{"$f":"I59+1","v":"2025-01-04"},{"$f":"J59+1","v":"2025-01-05"}]
[]
["davidseah.com/pceo/cal"]

{"sheet":"18-Month","index":2,"n_rows":91,"n_cols":11,"rows_kept":91,"merged":[[0,4,0,10],[90,0,90,10]]}
["STARTING DATE",{"$nulls":3},{"$f":"Instructions!B4","v":"2024-01-01"}]
[{"$f":"CONCATENATE(\" Compact Calendar \",YEAR(E1),\" 18mo\")","v":" Compact Calendar 2024 18mo"}]
[]
["#",null,"MONTH",null,{"$f":"VLOOKUP(WEEKDAY(E6),Tables!$A$45:$B$51,2)","v":"Mo"},{"$f":"VLOOKUP(WEEKDAY(F6),Tables!$A$45:$B$51,2)","v":"Tu"},{"$f":"VLOOKUP(WEEKDAY(G6),Tables!$A$45:$B$51,2)","v":"We"},{"$f":"VLOOKUP(WEEKDAY(H6),Tables!$A$45:$B$51,2)","v":"Th"},{"$f":"VLOOKUP(WEEKDAY(I6),Tables!$A$45:$B$51,2)","v":"Fr"},{"$f":"VLOOKUP(WEEKDAY(J6),Tables!$A$45:$B$51,2)","v":"Sa"},{"$f":"VLOOKUP(WEEKDAY(K6),Tables!$A$45:$B$51,2)","v":"Sun"}]
[]
[{"$f":"INT((E6-DATE(YEAR(E6-WEEKDAY(E6-1)+4),1,3)+WEEKDAY(DATE(YEAR(E6-WEEKDAY(E6-1)+4),1,3))+ 5)/7)","v":52},null,{"$f":"IF(SUM(1*(DAY(E6:K6)=1))>0,K6,\"\")","v":""},null,{"$f":"F6-1","v":"2023-12-25"},"2023-12-26","2023-12-27","2023-12-28","2023-12-29","2023-12-30",{"$f":"$E$1-WEEKDAY($E$1)+1","v":"2023-12-31"}]
[{"$f":"INT((E7-DATE(YEAR(E7-WEEKDAY(E7-1)+4),1,3)+WEEKDAY(DATE(YEAR(E7-WEEKDAY(E7-1)+4),1,3))+ 5)/7)","v":1},null,{"$f":"IF(SUM(1*(DAY(E7:K7)=1))>0,K7,\"\")","v":"2024-01-07"},null,{"$f":"K6+1","v":"2024-01-01"},{"$f":"E7+1","v":"2024-01-02"},"2024-01-03","2024-01-04","2024-01-05","2024-01-06","2024-01-07"]
[{"$f":"INT((E8-DATE(YEAR(E8-WEEKDAY(E8-1)+4),1,3)+WEEKDAY(DATE(YEAR(E8-WEEKDAY(E8-1)+4),1,3))+ 5)/7)","v":2},null,{"$f":"IF(SUM(1*(DAY(E8:K8)=1))>0,K8,\"\")","v":""},null,"2024-01-08","2024-01-09","2024-01-10","2024-01-11","2024-01-12","2024-01-13","2024-01-14"]
[3,null,{"$f":"IF(SUM(1*(DAY(E9:K9)=1))>0,K9,\"\")","v":""},null,"2024-01-15","2024-01-16","2024-01-17","2024-01-18","2024-01-19","2024-01-20","2024-01-21"]
[4,null,{"$f":"IF(SUM(1*(DAY(E10:K10)=1))>0,K10,\"\")","v":""},null,"2024-01-22","2024-01-23","2024-01-24","2024-01-25","2024-01-26","2024-01-27","2024-01-28"]
[5,null,{"$f":"IF(SUM(1*(DAY(E11:K11)=1))>0,K11,\"\")","v":"2024-02-04"},null,"2024-01-29","2024-01-30","2024-01-31","2024-02-01","2024-02-02","2024-02-03","2024-02-04"]
[6,null,{"$f":"IF(SUM(1*(DAY(E12:K12)=1))>0,K12,\"\")","v":""},null,"2024-02-05","2024-02-06","2024-02-07","2024-02-08","2024-02-09","2024-02-10","2024-02-11"]
[7,null,{"$f":"IF(SUM(1*(DAY(E13:K13)=1))>0,K13,\"\")","v":""},null,"2024-02-12","2024-02-13","2024-02-14","2024-02-15","2024-02-16","2024-02-17","2024-02-18"]
[8,null,{"$f":"IF(SUM(1*(DAY(E14:K14)=1))>0,K14,\"\")","v":""},null,"2024-02-19","2024-02-20","2024-02-21","2024-02-22","2024-02-23","2024-02-24","2024-02-25"]
[9,null,{"$f":"IF(SUM(1*(DAY(E15:K15)=1))>0,K15,\"\")","v":"2024-03-03"},null,"2024-02-26","2024-02-27","2024-02-28","2024-02-29","2024-03-01","2024-03-02","2024-03-03"]
[10,null,{"$f":"IF(SUM(1*(DAY(E16:K16)=1))>0,K16,\"\")","v":""},null,"2024-03-04","2024-03-05","2024-03-06","2024-03-07","2024-03-08","2024-03-09","2024-03-10"]
[11,null,{"$f":"IF(SUM(1*(DAY(E17:K17)=1))>0,K17,\"\")","v":""},null,"2024-03-11","2024-03-12","2024-03-13","2024-03-14","2024-03-15","2024-03-16","2024-03-17"]
[12,null,{"$f":"IF(SUM(1*(DAY(E18:K18)=1))>0,K18,\"\")","v":""},null,"2024-03-18","2024-03-19","2024-03-20","2024-03-21","2024-03-22","2024-03-23","2024-03-24"]
[13,null,{"$f":"IF(SUM(1*(DAY(E19:K19)=1))>0,K19,\"\")","v":""},null,"2024-03-25","2024-03-26","2024-03-27","2024-03-28","2024-03-29","2024-03-30","2024-03-31"]
[14,null,{"$f":"IF(SUM(1*(DAY(E20:K20)=1))>0,K20,\"\")","v":"2024-04-07"},null,"2024-04-01","2024-04-02","2024-04-03","2024-04-04","2024-04-05","2024-04-06","2024-04-07"]
[15,null,{"$f":"IF(SUM(1*(DAY(E21:K21)=1))>0,K21,\"\")","v":""},null,"2024-04-08","2024-04-09","2024-04-10","2024-04-11","2024-04-12","2024-04-13","2024-04-14"]
[16,null,{"$f":"IF(SUM(1*(DAY(E22:K22)=1))>0,K22,\"\")","v":""},null,"2024-04-15","2024-04-16","2024-04-17","2024-04-18","2024-04-19","2024-04-20","2024-04-21"]
[17,null,{"$f":"IF(SUM(1*(DAY(E23:K23)=1))>0,K23,\"\")","v":""},null,"2024-04-22",{"$f":"E23+1","v":"2024-04-23"},"2024-04-24","2024-04-25","2024-04-26","2024-04-27","2024-04-28"]
[18,null,{"$f":"IF(SUM(1*(DAY(E24:K24)=1))>0,K24,\"\")","v":"2024-05-05"},null,"2024-04-29","2024-04-30","2024-05-01","2024-05-02","2024-05-03","2024-05-04","2024-05-05"]
[19,null,{"$f":"IF(SUM(1*(DAY(E25:K25)=1))>0,K25,\"\")","v":""},null,"2024-05-06","2024-05-07","2024-05-08","2024-05-09","2024-05-10","2024-05-11","2024-05-12"]
[20,null,{"$f":"IF(SUM(1*(DAY(E26:K26)=1))>0,K26,\"\")","v":""},null,"2024-05-13","2024-05-14","2024-05-15","2024-05-16","2024-05-17","2024-05-18","2024-05-19"]
[21,null,{"$f":"IF(SUM(1*(DAY(E27:K27)=1))>0,K27,\"\")","v":""},null,"2024-05-20","2024-05-21","2024-05-22","2024-05-23","2024-05-24","2024-05-25","2024-05-26"]
[22,null,{"$f":"IF(SUM(1*(DAY(E28:K28)=1))>0,K28,\"\")","v":"2024-06-02"},null,"2024-05-27","2024-05-28","2024-05-29","2024-05-30","2024-05-31","2024-06-01","2024-06-02"]
[23,null,{"$f":"IF(SUM(1*(DAY(E29:K29)=1))>0,K29,\"\")","v":""},null,"2024-06-03","2024-06-04","2024-06-05","2024-06-06","2024-06-07","2024-06-08","2024-06-09"]
[24,null,{"$f":"IF(SUM(1*(DAY(E30:K30)=1))>0,K30,\"\")","v":""},null,"2024-06-10","2024-06-11","2024-06-12","2024-06-13","2024-06-14","2024-06-15","2024-06-16"]
[25,null,{"$f":"IF(SUM(1*(DAY(E31:K31)=1))>0,K31,\"\")","v":""},null,"2024-06-17","2024-06-18","2024-06-19","2024-06-20","2024-06-21","2024-06-22","2024-06-23"]
[26,null,{"$f":"IF(SUM(1*(DAY(E32:K32)=1))>0,K32,\"\")","v":""},null,"2024-06-24","2024-06-25","2024-06-26","2024-06-27","2024-06-28","2024-06-29","2024-06-30"]
[27,null,{"$f":"IF(SUM(1*(DAY(E33:K33)=1))>0,K33,\"\")","v":"2024-07-07"},null,"2024-07-01","2024-07-02","2024-07-03","2024-07-04","2024-07-05","2024-07-06","2024-07-07"]
[28,null,{"$f":"IF(SUM(1*(DAY(E34:K34)=1))>0,K34,\"\")","v":""},null,"2024-07-08","2024-07-09","2024-07-10","2024-07-11","2024-07-12","2024-07-13","2024-07-14"]
[29,null,{"$f":"IF(SUM(1*(DAY(E35:K35)=1))>0,K35,\"\")","v":""},null,"2024-07-15","2024-07-16","2024-07-17","2024-07-18","2024-07-19","2024-07-20","2024-07-21"]
[30,null,{"$f":"IF(SUM(1*(DAY(E36:K36)=1))>0,K36,\"\")","v":""},null,"2024-07-22","2024-07-23","2024-07-24","2024-07-25","2024-07-26","2024-07-27","2024-07-28"]
[31,null,{"$f":"IF(SUM(1*(DAY(E37:K37)=1))>0,K37,\"\")","v":"2024-08-04"},null,"2024-07-29","2024-07-30","2024-07-31","2024-08-01","2024-08-02","2024-08-03","2024-08-04"]
[32,null,{"$f":"IF(SUM(1*(DAY(E38:K38)=1))>0,K38,\"\")","v":""},null,"2024-08-05","2024-08-06","2024-08-07","2024-08-08","2024-08-09","2024-08-10","2024-08-11"]
[33,null,{"$f":"IF(SUM(1*(DAY(E39:K39)=1))>0,K39,\"\")","v":""},null,"2024-08-12","2024-08-13","2024-08-14","2024-08-15","2024-08-16","2024-08-17","2024-08-18"]
[34,null,{"$f":"IF(SUM(1*(DAY(E40:K40)=1))>0,K40,\"\")","v":""},null,"2024-08-19","2024-08-20","2024-08-21","2024-08-22","2024-08-23","2024-08-24","2024-08-25"]
[35,null,{"$f":"IF(SUM(1*(DAY(E41:K41)=1))>0,K41,\"\")","v":"2024-09-01"},null,"2024-08-26","2024-08-27","2024-08-28","2024-08-29","2024-08-30","2024-08-31","2024-09-01"]
[36,null,{"$f":"IF(SUM(1*(DAY(E42:K42)=1))>0,K42,\"\")","v":""},null,"2024-09-02","2024-09-03","2024-09-04","2024-09-05","2024-09-06","2024-09-07","2024-09-08"]
[37,null,{"$f":"IF(SUM(1*(DAY(E43:K43)=1))>0,K43,\"\")","v":""},null,"2024-09-09","2024-09-10","2024-09-11","2024-09-12","2024-09-13","2024-09-14","2024-09-15"]
[38,null,{"$f":"IF(SUM(1*(DAY(E44:K44)=1))>0,K44,\"\")","v":""},null,"2024-09-16","2024-09-17","2024-09-18","2024-09-19","2024-09-20","2024-09-21","2024-09-22"]
[39,null,{"$f":"IF(SUM(1*(DAY(E45:K45)=1))>0,K45,\"\")","v":""},null,"2024-09-23","2024-09-24","2024-09-25","2024-09-26","2024-09-27","2024-09-28","2024-09-29"]
[40,null,{"$f":"IF(SUM(1*(DAY(E46:K46)=1))>0,K46,\"\")","v":"2024-10-06"},null,"2024-09-30","2024-10-01","2024-10-02","2024-10-03","2024-10-04","2024-10-05","2024-10-06"]
[41,null,{"$f":"IF(SUM(1*(DAY(E47:K47)=1))>0,K47,\"\")","v":""},null,"2024-10-07","2024-10-08","2024-10-09","2024-10-10","2024-10-11","2024-10-12","2024-10-13"]
[42,null,{"$f":"IF(SUM(1*(DAY(E48:K48)=1))>0,K48,\"\")","v":""},null,"2024-10-14","2024-10-15","2024-10-16","2024-10-17","2024-10-18","2024-10-19","2024-10-20"]
[43,null,{"$f":"IF(SUM(1*(DAY(E49:K49)=1))>0,K49,\"\")","v":""},null,"2024-10-21","2024-10-22","2024-10-23","2024-10-24","2024-10-25","2024-10-26","2024-10-27"]
[44,null,{"$f":"IF(SUM(1*(DAY(E50:K50)=1))>0,K50,\"\")","v":"2024-11-03"},null,"2024-10-28","2024-10-29","2024-10-30","2024-10-31","2024-11-01","2024-11-02","2024-11-03"]
[45,null,{"$f":"IF(SUM(1*(DAY(E51:K51)=1))>0,K51,\"\")","v":""},null,"2024-11-04","2024-11-05","2024-11-06","2024-11-07","2024-11-08","2024-11-09","2024-11-10"]
[46,null,{"$f":"IF(SUM(1*(DAY(E52:K52)=1))>0,K52,\"\")","v":""},null,"2024-11-11","2024-11-12","2024-11-13","2024-11-14","2024-11-15","2024-11-16","2024-11-17"]
[47,null,{"$f":"IF(SUM(1*(DAY(E53:K53)=1))>0,K53,\"\")","v":""},null,"2024-11-18","2024-11-19","2024-11-20","2024-11-21",{"$f":"H53+1","v":"2024-11-22"},"2024-11-23","2024-11-24"]
[48,null,{"$f":"IF(SUM(1*(DAY(E54:K54)=1))>0,K54,\"\")","v":"2024-12-01"},null,"2024-11-25","2024-11-26","2024-11-27","2024-11-28","2024-11-29","2024-11-30","2024-12-01"]
[49,null,{"$f":"IF(SUM(1*(DAY(E55:K55)=1))>0,K55,\"\")","v":""},null,"2024-12-02",{"$f":"E55+1","v":"2024-12-03"},"2024-12-04","2024-12-05","2024-12-06","2024-12-07","2024-12-08"]
[50,null,{"$f":"IF(SUM(1*(DAY(E56:K56)=1))>0,K56,\"\")","v":""},null,"2024-12-09","2024-12-10","2024-12-11","2024-12-12","2024-12-13","2024-12-14","2024-12-15"]
[51,null,{"$f":"IF(SUM(1*(DAY(E57:K57)=1))>0,K57,\"\")","v":""},null,"2024-12-16","2024-12-17","2024-12-18","2024-12-19","2024-12-20","2024-12-21","2024-12-22"]
[52,null,{"$f":"IF(SUM(1*(DAY(E58:K58)=1))>0,K58,\"\")","v":""},null,"2024-12-23","2024-12-24","2024-12-25","2024-12-26","2024-12-27","2024-12-28","2024-12-29"]
[1,null,{"$f":"IF(SUM(1*(DAY(E59:K59)=1))>0,K59,\"\")","v":"2025-01-05"},null,"2024-12-30","2024-12-31",{"$f":"F59+1","v":"2025-01-01"},{"$f":"G59+1","v":"2025-01-02"},{"$f":"H59+1","v":"2025-01-03"},{"$f":"I59+1","v":"2025-01-04"},{"$f":"J59+1","v":"2025-01-05"}]
[{"$f":"INT((E60-DATE(YEAR(E60-WEEKDAY(E60-1)+4),1,3)+WEEKDAY(DATE(YEAR(E60-WEEKDAY(E60-1)+4),1,3))+ 5)/7)","v":2},null,{"$f":"IF(SUM(1*(DAY(E60:K60)=1))>0,K60,\"\")","v":""},null,{"$f":"K59+1","v":"2025-01-06"},{"$f":"E60+1","v":"2025-01-07"},{"$f":"F60+1","v":"2025-01-08"},{"$f":"G60+1","v":"2025-01-09"},{"$f":"H60+1","v":"2025-01-10"},{"$f":"I60+1","v":"2025-01-11"},{"$f":"J60+1","v":"2025-01-12"}]
[3,null,{"$f":"IF(SUM(1*(DAY(E61:K61)=1))>0,K61,\"\")","v":""},null,"2025-01-13","2025-01-14","2025-01-15","2025-01-16","2025-01-17","2025-01-18","2025-01-19"]
[4,null,{"$f":"IF(SUM(1*(DAY(E62:K62)=1))>0,K62,\"\")","v":""},null,"2025-01-20","2025-01-21","2025-01-22","2025-01-23","2025-01-24","2025-01-25","2025-01-26"]
[5,null,{"$f":"IF(SUM(1*(DAY(E63:K63)=1))>0,K63,\"\")","v":"2025-02-02"},null,"2025-01-27","2025-01-28","2025-01-29","2025-01-30","2025-01-31","2025-02-01","2025-02-02"]
[6,null,{"$f":"IF(SUM(1*(DAY(E64:K64)=1))>0,K64,\"\")","v":""},null,"2025-02-03","2025-02-04","2025-02-05","2025-02-06","2025-02-07","2025-02-08","2025-02-09"]
[7,null,{"$f":"IF(SUM(1*(DAY(E65:K65)=1))>0,K65,\"\")","v":""},null,"2025-02-10","2025-02-11","2025-02-12","2025-02-13","2025-02-14","2025-02-15","2025-02-16"]
[8,null,{"$f":"IF(SUM(1*(DAY(E66:K66)=1))>0,K66,\"\")","v":""},null,"2025-02-17","2025-02-18","2025-02-19","2025-02-20","2025-02-21","2025-02-22","2025-02-23"]
[9,null,{"$f":"IF(SUM(1*(DAY(E67:K67)=1))>0,K67,\"\")","v":"2025-03-02"},null,"2025-02-24","2025-02-25","2025-02-26","2025-02-27","2025-02-28","2025-03-01","2025-03-02"]
[10,null,{"$f":"IF(SUM(1*(DAY(E68:K68)=1))>0,K68,\"\")","v":""},null,"2025-03-03","2025-03-04","2025-03-05","2025-03-06","2025-03-07","2025-03-08","2025-03-09"]
[11,null,{"$f":"IF(SUM(1*(DAY(E69:K69)=1))>0,K69,\"\")","v":""},null,"2025-03-10","2025-03-11","2025-03-12","2025-03-13","2025-03-14","2025-03-15","2025-03-16"]
[12,null,{"$f":"IF(SUM(1*(DAY(E70:K70)=1))>0,K70,\"\")","v":""},null,"2025-03-17","2025-03-18","2025-03-19","2025-03-20","2025-03-21","2025-03-22","2025-03-23"]
[13,null,{"$f":"IF(SUM(1*(DAY(E71:K71)=1))>0,K71,\"\")","v":""},null,"2025-03-24","2025-03-25","2025-03-26","2025-03-27","2025-03-28","2025-03-29","2025-03-30"]
[14,null,{"$f":"IF(SUM(1*(DAY(E72:K72)=1))>0,K72,\"\")","v":"2025-04-06"},null,"2025-03-31","2025-04-01","2025-04-02","2025-04-03","2025-04-04","2025-04-05","2025-04-06"]
[15,null,{"$f":"IF(SUM(1*(DAY(E73:K73)=1))>0,K73,\"\")","v":""},null,"2025-04-07","2025-04-08","2025-04-09","2025-04-10","2025-04-11","2025-04-12","2025-04-13"]
[16,null,{"$f":"IF(SUM(1*(DAY(E74:K74)=1))>0,K74,\"\")","v":""},null,"2025-04-14","2025-04-15","2025-04-16","2025-04-17","2025-04-18","2025-04-19","2025-04-20"]
[17,null,{"$f":"IF(SUM(1*(DAY(E75:K75)=1))>0,K75,\"\")","v":""},null,"2025-04-21","2025-04-22","2025-04-23","2025-04-24","2025-04-25","2025-04-26","2025-04-27"]
[18,null,{"$f":"IF(SUM(1*(DAY(E76:K76)=1))>0,K76,\"\")","v":"2025-05-04"},null,"2025-04-28","2025-04-29","2025-04-30","2025-05-01","2025-05-02","2025-05-03","2025-05-04"]
[19,null,{"$f":"IF(SUM(1*(DAY(E77:K77)=1))>0,K77,\"\")","v":""},null,"2025-05-05","2025-05-06","2025-05-07","2025-05-08","2025-05-09","2025-05-10","2025-05-11"]
[{"$f":"INT((E78-DATE(YEAR(E78-WEEKDAY(E78-1)+4),1,3)+WEEKDAY(DATE(YEAR(E78-WEEKDAY(E78-1)+4),1,3))+ 5)/7)","v":20},null,{"$f":"IF(SUM(1*(DAY(E78:K78)=1))>0,K78,\"\")","v":""},null,{"$f":"K77+1","v":"2025-05-12"},{"$f":"E78+1","v":"2025-05-13"},{"$f":"F78+1","v":"2025-05-14"},{"$f":"G78+1","v":"2025-05-15"},{"$f":"H78+1","v":"2025-05-16"},{"$f":"I78+1","v":"2025-05-17"},{"$f":"J78+1","v":"2025-05-18"}]
[21,null,{"$f":"IF(SUM(1*(DAY(E79:K79)=1))>0,K79,\"\")","v":""},null,"2025-05-19","2025-05-20","2025-05-21","2025-05-22","2025-05-23","2025-05-24","2025-05-25"]
[22,null,{"$f":"IF(SUM(1*(DAY(E80:K80)=1))>0,K80,\"\")","v":"2025-06-01"},null,"2025-05-26","2025-05-27","2025-05-28","2025-05-29","2025-05-30","2025-05-31","2025-06-01"]
[23,null,{"$f":"IF(SUM(1*(DAY(E81:K81)=1))>0,K81,\"\")","v":""},null,"2025-06-02","2025-06-03","2025-06-04","2025-06-05","2025-06-06","2025-06-07","2025-06-08"]
[24,null,{"$f":"IF(SUM(1*(DAY(E82:K82)=1))>0,K82,\"\")","v":""},null,"2025-06-09","2025-06-10","2025-06-11","2025-06-12","2025-06-13","2025-06-14","2025-06-15"]
[25,null,{"$f":"IF(SUM(1*(DAY(E83:K83)=1))>0,K83,\"\")","v":""},null,"2025-06-16","2025-06-17","2025-06-18","2025-06-19","2025-06-20","2025-06-21","2025-06-22"]
[26,null,{"$f":"IF(SUM(1*(DAY(E84:K84)=1))>0,K84,\"\")","v":""},null,"2025-06-23","2025-06-24","2025-06-25","2025-06-26","2025-06-27","2025-06-28","2025-06-29"]
[{"$f":"INT((E85-DATE(YEAR(E85-WEEKDAY(E85-1)+4),1,3)+WEEKDAY(DATE(YEAR(E85-WEEKDAY(E85-1)+4),1,3))+ 5)/7)","v":27},null,{"$f":"IF(SUM(1*(DAY(E85:K85)=1))>0,K85,\"\")","v":"2025-07-06"},null,{"$f":"K84+1","v":"2025-06-30"},{"$f":"E85+1","v":"2025-07-01"},{"$f":"F85+1","v":"2025-07-02"},{"$f":"G85+1","v":"2025-07-03"},{"$f":"H85+1","v":"2025-07-04"},{"$f":"I85+1","v":"2025-07-05"},{"$f":"J85+1","v":"2025-07-06"}]
[28,null,{"$f":"IF(SUM(1*(DAY(E86:K86)=1))>0,K86,\"\")","v":""},null,"2025-07-07","2025-07-08","2025-07-09","2025-07-10","2025-07-11","2025-07-12","2025-07-13"]
[29,null,{"$f":"IF(SUM(1*(DAY(E87:K87)=1))>0,K87,\"\")","v":""},null,"2025-07-14","2025-07-15","2025-07-16","2025-07-17","2025-07-18","2025-07-19","2025-07-20"]
[30,null,{"$f":"IF(SUM(1*(DAY(E88:K88)=1))>0,K88,\"\")","v":""},null,"2025-07-21","2025-07-22","2025-07-23","2025-07-24","2025-07-25","2025-07-26","2025-07-27"]
[31,null,{"$f":"IF(SUM(1*(DAY(E89:K89)=1))>0,K89,\"\")","v":"2025-08-03"},null,"2025-07-28","2025-07-29","2025-07-30","2025-07-31","2025-08-01","2025-08-02","2025-08-03"]
[]
["davidseah.com/pceo/cal"]

{"sheet":"12-Month (no holidays)","index":3,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[0,4,0,10],[60,0,60,10]]}
["STARTING DATE",{"$nulls":3},{"$f":"Instructions!B4","v":"2024-01-01"}]
[{"$f":"CONCATENATE(\" Compact Calendar \",YEAR(E1))","v":" Compact Calendar 2024"}]
[]
["#",null,"MONTH",null,{"$f":"VLOOKUP(WEEKDAY(E6),Tables!$A$45:$B$51,2)","v":"Mo"},{"$f":"VLOOKUP(WEEKDAY(F6),Tables!$A$45:$B$51,2)","v":"Tu"},{"$f":"VLOOKUP(WEEKDAY(G6),Tables!$A$45:$B$51,2)","v":"We"},{"$f":"VLOOKUP(WEEKDAY(H6),Tables!$A$45:$B$51,2)","v":"Th"},{"$f":"VLOOKUP(WEEKDAY(I6),Tables!$A$45:$B$51,2)","v":"Fr"},{"$f":"VLOOKUP(WEEKDAY(J6),Tables!$A$45:$B$51,2)","v":"Sa"},{"$f":"VLOOKUP(WEEKDAY(K6),Tables!$A$45:$B$51,2)","v":"Sun"}]
[]
[{"$f":"INT((E6-DATE(YEAR(E6-WEEKDAY(E6-1)+4),1,3)+WEEKDAY(DATE(YEAR(E6-WEEKDAY(E6-1)+4),1,3))+ 5)/7)","v":52},null,{"$f":"IF(SUM(1*(DAY(E6:K6)=1))>0,K6,\"\")","v":""},null,{"$f":"F6-1","v":"2023-12-25"},"2023-12-26","2023-12-27","2023-12-28","2023-12-29","2023-12-30",{"$f":"$E$1-WEEKDAY($E$1)+1","v":"2023-12-31"}]
[{"$f":"INT((E7-DATE(YEAR(E7-WEEKDAY(E7-1)+4),1,3)+WEEKDAY(DATE(YEAR(E7-WEEKDAY(E7-1)+4),1,3))+ 5)/7)","v":1},null,{"$f":"IF(SUM(1*(DAY(E7:K7)=1))>0,K7,\"\")","v":"2024-01-07"},null,{"$f":"K6+1","v":"2024-01-01"},{"$f":"E7+1","v":"2024-01-02"},"2024-01-03","2024-01-04","2024-01-05","2024-01-06","2024-01-07"]
[{"$f":"INT((E8-DATE(YEAR(E8-WEEKDAY(E8-1)+4),1,3)+WEEKDAY(DATE(YEAR(E8-WEEKDAY(E8-1)+4),1,3))+ 5)/7)","v":2},null,{"$f":"IF(SUM(1*(DAY(E8:K8)=1))>0,K8,\"\")","v":""},null,"2024-01-08","2024-01-09","2024-01-10","2024-01-11","2024-01-12","2024-01-13","2024-01-14"]
[3,null,{"$f":"IF(SUM(1*(DAY(E9:K9)=1))>0,K9,\"\")","v":""},null,"2024-01-15","2024-01-16","2024-01-17","2024-01-18","2024-01-19","2024-01-20","2024-01-21"]
[4,null,{"$f":"IF(SUM(1*(DAY(E10:K10)=1))>0,K10,\"\")","v":""},null,"2024-01-22","2024-01-23","2024-01-24","2024-01-25","2024-01-26","2024-01-27","2024-01-28"]
[5,null,{"$f":"IF(SUM(1*(DAY(E11:K11)=1))>0,K11,\"\")","v":"2024-02-04"},null,"2024-01-29","2024-01-30","2024-01-31","2024-02-01","2024-02-02","2024-02-03","2024-02-04"]
[6,null,{"$f":"IF(SUM(1*(DAY(E12:K12)=1))>0,K12,\"\")","v":""},null,"2024-02-05","2024-02-06","2024-02-07","2024-02-08","2024-02-09","2024-02-10","2024-02-11"]
[7,null,{"$f":"IF(SUM(1*(DAY(E13:K13)=1))>0,K13,\"\")","v":""},null,"2024-02-12","2024-02-13","2024-02-14","2024-02-15","2024-02-16","2024-02-17","2024-02-18"]
[8,null,{"$f":"IF(SUM(1*(DAY(E14:K14)=1))>0,K14,\"\")","v":""},null,"2024-02-19","2024-02-20","2024-02-21","2024-02-22","2024-02-23","2024-02-24","2024-02-25"]
[9,null,{"$f":"IF(SUM(1*(DAY(E15:K15)=1))>0,K15,\"\")","v":"2024-03-03"},null,"2024-02-26","2024-02-27","2024-02-28","2024-02-29","2024-03-01","2024-03-02","2024-03-03"]
[10,null,{"$f":"IF(SUM(1*(DAY(E16:K16)=1))>0,K16,\"\")","v":""},null,"2024-03-04","2024-03-05","2024-03-06","2024-03-07","2024-03-08","2024-03-09","2024-03-10"]
[11,null,{"$f":"IF(SUM(1*(DAY(E17:K17)=1))>0,K17,\"\")","v":""},null,"2024-03-11","2024-03-12","2024-03-13","2024-03-14","2024-03-15","2024-03-16","2024-03-17"]
[12,null,{"$f":"IF(SUM(1*(DAY(E18:K18)=1))>0,K18,\"\")","v":""},null,"2024-03-18","2024-03-19","2024-03-20","2024-03-21","2024-03-22","2024-03-23","2024-03-24"]
[13,null,{"$f":"IF(SUM(1*(DAY(E19:K19)=1))>0,K19,\"\")","v":""},null,"2024-03-25","2024-03-26","2024-03-27","2024-03-28","2024-03-29","2024-03-30","2024-03-31"]
[14,null,{"$f":"IF(SUM(1*(DAY(E20:K20)=1))>0,K20,\"\")","v":"2024-04-07"},null,"2024-04-01","2024-04-02","2024-04-03","2024-04-04","2024-04-05","2024-04-06","2024-04-07"]
[15,null,{"$f":"IF(SUM(1*(DAY(E21:K21)=1))>0,K21,\"\")","v":""},null,"2024-04-08","2024-04-09","2024-04-10","2024-04-11","2024-04-12","2024-04-13","2024-04-14"]
[16,null,{"$f":"IF(SUM(1*(DAY(E22:K22)=1))>0,K22,\"\")","v":""},null,"2024-04-15","2024-04-16","2024-04-17","2024-04-18","2024-04-19","2024-04-20","2024-04-21"]
[17,null,{"$f":"IF(SUM(1*(DAY(E23:K23)=1))>0,K23,\"\")","v":""},null,"2024-04-22",{"$f":"E23+1","v":"2024-04-23"},"2024-04-24","2024-04-25","2024-04-26","2024-04-27","2024-04-28"]
[18,null,{"$f":"IF(SUM(1*(DAY(E24:K24)=1))>0,K24,\"\")","v":"2024-05-05"},null,"2024-04-29","2024-04-30","2024-05-01","2024-05-02","2024-05-03","2024-05-04","2024-05-05"]
[19,null,{"$f":"IF(SUM(1*(DAY(E25:K25)=1))>0,K25,\"\")","v":""},null,"2024-05-06","2024-05-07","2024-05-08","2024-05-09","2024-05-10","2024-05-11","2024-05-12"]
[20,null,{"$f":"IF(SUM(1*(DAY(E26:K26)=1))>0,K26,\"\")","v":""},null,"2024-05-13","2024-05-14","2024-05-15","2024-05-16","2024-05-17","2024-05-18","2024-05-19"]
[21,null,{"$f":"IF(SUM(1*(DAY(E27:K27)=1))>0,K27,\"\")","v":""},null,"2024-05-20","2024-05-21","2024-05-22","2024-05-23","2024-05-24","2024-05-25","2024-05-26"]
[22,null,{"$f":"IF(SUM(1*(DAY(E28:K28)=1))>0,K28,\"\")","v":"2024-06-02"},null,"2024-05-27","2024-05-28","2024-05-29","2024-05-30","2024-05-31","2024-06-01","2024-06-02"]
[23,null,{"$f":"IF(SUM(1*(DAY(E29:K29)=1))>0,K29,\"\")","v":""},null,"2024-06-03","2024-06-04","2024-06-05","2024-06-06","2024-06-07","2024-06-08","2024-06-09"]
[24,null,{"$f":"IF(SUM(1*(DAY(E30:K30)=1))>0,K30,\"\")","v":""},null,"2024-06-10","2024-06-11","2024-06-12","2024-06-13","2024-06-14","2024-06-15","2024-06-16"]
[25,null,{"$f":"IF(SUM(1*(DAY(E31:K31)=1))>0,K31,\"\")","v":""},null,"2024-06-17","2024-06-18","2024-06-19","2024-06-20","2024-06-21","2024-06-22","2024-06-23"]
[26,null,{"$f":"IF(SUM(1*(DAY(E32:K32)=1))>0,K32,\"\")","v":""},null,"2024-06-24","2024-06-25","2024-06-26","2024-06-27","2024-06-28","2024-06-29","2024-06-30"]
[27,null,{"$f":"IF(SUM(1*(DAY(E33:K33)=1))>0,K33,\"\")","v":"2024-07-07"},null,"2024-07-01","2024-07-02","2024-07-03","2024-07-04","2024-07-05","2024-07-06","2024-07-07"]
[28,null,{"$f":"IF(SUM(1*(DAY(E34:K34)=1))>0,K34,\"\")","v":""},null,"2024-07-08","2024-07-09","2024-07-10","2024-07-11","2024-07-12","2024-07-13","2024-07-14"]
[29,null,{"$f":"IF(SUM(1*(DAY(E35:K35)=1))>0,K35,\"\")","v":""},null,"2024-07-15","2024-07-16","2024-07-17","2024-07-18","2024-07-19","2024-07-20","2024-07-21"]
[30,null,{"$f":"IF(SUM(1*(DAY(E36:K36)=1))>0,K36,\"\")","v":""},null,"2024-07-22","2024-07-23","2024-07-24","2024-07-25","2024-07-26","2024-07-27","2024-07-28"]
[31,null,{"$f":"IF(SUM(1*(DAY(E37:K37)=1))>0,K37,\"\")","v":"2024-08-04"},null,"2024-07-29","2024-07-30","2024-07-31","2024-08-01","2024-08-02","2024-08-03","2024-08-04"]
[32,null,{"$f":"IF(SUM(1*(DAY(E38:K38)=1))>0,K38,\"\")","v":""},null,"2024-08-05","2024-08-06","2024-08-07","2024-08-08","2024-08-09","2024-08-10","2024-08-11"]
[33,null,{"$f":"IF(SUM(1*(DAY(E39:K39)=1))>0,K39,\"\")","v":""},null,"2024-08-12","2024-08-13","2024-08-14","2024-08-15","2024-08-16","2024-08-17","2024-08-18"]
[34,null,{"$f":"IF(SUM(1*(DAY(E40:K40)=1))>0,K40,\"\")","v":""},null,"2024-08-19","2024-08-20","2024-08-21","2024-08-22","2024-08-23","2024-08-24","2024-08-25"]
[35,null,{"$f":"IF(SUM(1*(DAY(E41:K41)=1))>0,K41,\"\")","v":"2024-09-01"},null,"2024-08-26","2024-08-27","2024-08-28","2024-08-29","2024-08-30","2024-08-31","2024-09-01"]
[36,null,{"$f":"IF(SUM(1*(DAY(E42:K42)=1))>0,K42,\"\")","v":""},null,"2024-09-02","2024-09-03","2024-09-04","2024-09-05","2024-09-06","2024-09-07","2024-09-08"]
[37,null,{"$f":"IF(SUM(1*(DAY(E43:K43)=1))>0,K43,\"\")","v":""},null,"2024-09-09","2024-09-10","2024-09-11","2024-09-12","2024-09-13","2024-09-14","2024-09-15"]
[38,null,{"$f":"IF(SUM(1*(DAY(E44:K44)=1))>0,K44,\"\")","v":""},null,"2024-09-16","2024-09-17","2024-09-18","2024-09-19","2024-09-20","2024-09-21","2024-09-22"]
[39,null,{"$f":"IF(SUM(1*(DAY(E45:K45)=1))>0,K45,\"\")","v":""},null,"2024-09-23","2024-09-24","2024-09-25","2024-09-26","2024-09-27","2024-09-28","2024-09-29"]
[40,null,{"$f":"IF(SUM(1*(DAY(E46:K46)=1))>0,K46,\"\")","v":"2024-10-06"},null,"2024-09-30","2024-10-01","2024-10-02","2024-10-03","2024-10-04","2024-10-05","2024-10-06"]
[41,null,{"$f":"IF(SUM(1*(DAY(E47:K47)=1))>0,K47,\"\")","v":""},null,"2024-10-07","2024-10-08","2024-10-09","2024-10-10","2024-10-11","2024-10-12","2024-10-13"]
[42,null,{"$f":"IF(SUM(1*(DAY(E48:K48)=1))>0,K48,\"\")","v":""},null,"2024-10-14","2024-10-15","2024-10-16","2024-10-17","2024-10-18","2024-10-19","2024-10-20"]
[43,null,{"$f":"IF(SUM(1*(DAY(E49:K49)=1))>0,K49,\"\")","v":""},null,"2024-10-21","2024-10-22","2024-10-23","2024-10-24","2024-10-25","2024-10-26","2024-10-27"]
[44,null,{"$f":"IF(SUM(1*(DAY(E50:K50)=1))>0,K50,\"\")","v":"2024-11-03"},null,"2024-10-28","2024-10-29","2024-10-30","2024-10-31","2024-11-01","2024-11-02","2024-11-03"]
[45,null,{"$f":"IF(SUM(1*(DAY(E51:K51)=1))>0,K51,\"\")","v":""},null,"2024-11-04","2024-11-05","2024-11-06","2024-11-07","2024-11-08","2024-11-09","2024-11-10"]
[46,null,{"$f":"IF(SUM(1*(DAY(E52:K52)=1))>0,K52,\"\")","v":""},null,"2024-11-11","2024-11-12","2024-11-13","2024-11-14","2024-11-15","2024-11-16","2024-11-17"]
[47,null,{"$f":"IF(SUM(1*(DAY(E53:K53)=1))>0,K53,\"\")","v":""},null,"2024-11-18","2024-11-19","2024-11-20","2024-11-21",{"$f":"H53+1","v":"2024-11-22"},"2024-11-23","2024-11-24"]
[48,null,{"$f":"IF(SUM(1*(DAY(E54:K54)=1))>0,K54,\"\")","v":"2024-12-01"},null,"2024-11-25","2024-11-26","2024-11-27","2024-11-28","2024-11-29","2024-11-30","2024-12-01"]
[49,null,{"$f":"IF(SUM(1*(DAY(E55:K55)=1))>0,K55,\"\")","v":""},null,"2024-12-02",{"$f":"E55+1","v":"2024-12-03"},"2024-12-04","2024-12-05","2024-12-06","2024-12-07","2024-12-08"]
[50,null,{"$f":"IF(SUM(1*(DAY(E56:K56)=1))>0,K56,\"\")","v":""},null,"2024-12-09","2024-12-10","2024-12-11","2024-12-12","2024-12-13","2024-12-14","2024-12-15"]
[51,null,{"$f":"IF(SUM(1*(DAY(E57:K57)=1))>0,K57,\"\")","v":""},null,"2024-12-16","2024-12-17","2024-12-18","2024-12-19","2024-12-20","2024-12-21","2024-12-22"]
[52,null,{"$f":"IF(SUM(1*(DAY(E58:K58)=1))>0,K58,\"\")","v":""},null,"2024-12-23","2024-12-24","2024-12-25","2024-12-26","2024-12-27","2024-12-28","2024-12-29"]
[1,null,{"$f":"IF(SUM(1*(DAY(E59:K59)=1))>0,K59,\"\")","v":"2025-01-05"},null,"2024-12-30","2024-12-31",{"$f":"F59+1","v":"2025-01-01"},{"$f":"G59+1","v":"2025-01-02"},{"$f":"H59+1","v":"2025-01-03"},{"$f":"I59+1","v":"2025-01-04"},{"$f":"J59+1","v":"2025-01-05"}]
[]
["davidseah.com/pceo/cal"]

{"sheet":"Tables","index":4,"n_rows":54,"n_cols":11,"rows_kept":54}
["HOLIDAY LOOKUP TABLE",{"$nulls":8},{"$f":"YEAR('12-Month'!$E$1)","v":2024},"year copied from 12-Month Calendar Worksheet"]
["The holidays in this table are calculated automatically. Change the STARTING DATE on the 12-Month worksheet will update this list"]
["Note that this table covers TWO YEARS!!!"]
[]
["DATE",null,"DESCRIPTION",null,"Mo","DoW","NthWk",null,null,"Notes"]
[{"$f":"IF(WEEKDAY(DATE($J$1,1,1))=1,DATE($J$1,1,2),IF(WEEKDAY(DATE($J$1,1,1))=7,DATE($J$1-1,12,31),DATE($J$1,1,1)))","v":"2024-01-01"},{"$f":"A6","v":"2024-01-01"},"New Year's Day (Obs)",{"$nulls":6},"Observed holiday is on weekday"]
[{"$f":"DATE($J$1,E7,1+((G7-(F7>=WEEKDAY(DATE($J$1,E7,1))))*7)+(F7-WEEKDAY(DATE($J$1,E7,1))))","v":"2024-01-15"},{"$f":"A7","v":"2024-01-15"},"Martin Luther King Day",null,1,2,3,null,null,"3rd Monday in January"]
[{"$f":"DATE($J$1,E8,1+((G8-(F8>=WEEKDAY(DATE($J$1,E8,1))))*7)+(F8-WEEKDAY(DATE($J$1,E8,1))))","v":"2024-02-19"},"2024-02-19","President's Day",null,2,2,3,null,null,"3rd Monday in February"]
[{"$f":"FLOOR(DATE($J$1,5,DAY(MINUTE($J$1/38)/2+56)),7)-34","v":"2024-03-31"},"2024-03-31","Easter Sunday",{"$nulls":6},"Calculated"]
[{"$f":"DATE($J$1, E10 + 1, 0) - MOD(WEEKDAY(DATE($J$1, E10 + 1, 0)) - F10, 7)","v":"2024-05-27"},"2024-05-27","Memorial Day",null,5,2,{"$nulls":3},"Last Monday in May (special calc)"]
[{"$f":"IF(WEEKDAY(DATE($J$1,E11,F11))=1,DATE($J$1,E11,F11+1),IF(WEEKDAY(DATE($J$1,E11,F11))=7,DATE($J$1,E11,F11-1),DATE($J$1,E11,F11)))","v":"2024-06-19"},"2024-06-19","Juneteenth (Obs)",null,6,19,{"$nulls":3},"Juneteenth"]
[{"$f":"IF(WEEKDAY(DATE($J$1,E12,F12))=1,DATE($J$1,E12,F12+1),IF(WEEKDAY(DATE($J$1,E12,F12))=7,DATE($J$1,E12,F12-1),DATE($J$1,E12,F12)))","v":"2024-07-04"},"2024-07-04","Independence Day (Obs)",null,7,4,{"$nulls":3},"Observed holiday is on weekday"]
[{"$f":"DATE($J$1,E13,1+((G13-(F13>=WEEKDAY(DATE($J$1,E13,1))))*7)+(F13-WEEKDAY(DATE($J$1,E13,1))))","v":"2024-09-02"},{"$f":"A13","v":"2024-09-02"},"Labor Day",null,9,2,1,null,null,"1st Monday in September"]
[{"$f":"DATE($J$1,E14,1+((G14-(F14>=WEEKDAY(DATE($J$1,E14,1))))*7)+(F14-WEEKDAY(DATE($J$1,E14,1))))","v":"2024-11-28"},{"$f":"A14","v":"2024-11-28"},"Thanksgiving Day",null,11,5,4,null,null,"4th Thursday in November"]
[{"$f":"DATE($J$1,11,11)","v":"2024-11-11"},{"$f":"A15","v":"2024-11-11"},"Veterans Day",{"$nulls":6},"Always November 11"]
[{"$f":"DATE($J$1,E16,F16)","v":"2024-12-25"},{"$f":"A16","v":"2024-12-25"},"Christmas Day",null,12,25,{"$nulls":3},"Always December 25"]
[{"$f":"IF(WEEKDAY(DATE($J$1,E17,F17))=1,DATE($J$1,E17,F17+1),IF(WEEKDAY(DATE($J$1,E17,F17))=7,DATE($J$1,E17,F17-1),DATE($J$1,E17,F17)))","v":"2024-12-25"},{"$f":"A17","v":"2024-12-25"},"Christmas Day (Obs)",null,12,25,{"$nulls":3},"If Dec 25 on weekend, add observed"]
[]
[{"$f":"IF(WEEKDAY(DATE($J$1+1,1,1))=1,DATE($J$1,1,2),IF(WEEKDAY(DATE($J$1+1,1,1))=7,DATE($J$1,12,31),DATE($J$1+1,1,1)))","v":"2025-01-01"},{"$f":"A19","v":"2025-01-01"},"New Year's Day (Obs)",{"$nulls":6},"Observed holiday is on weekday"]
[{"$f":"DATE($J$1+1,E20,1+((G20-(F20>=WEEKDAY(DATE($J$1+1,E20,1))))*7)+(F20-WEEKDAY(DATE($J$1+1,E20,1))))","v":"2025-01-20"},{"$f":"A20","v":"2025-01-20"},"Martin Luther King Day",null,1,2,3,null,null,"3rd Monday in January"]
[{"$f":"DATE($J$1+1,E21,1+((G21-(F21>=WEEKDAY(DATE($J$1+1,E21,1))))*7)+(F21-WEEKDAY(DATE($J$1+1,E21,1))))","v":"2025-02-17"},"2025-02-17","President's Day",null,2,2,3,null,null,"3rd Monday in February"]
[{"$f":"FLOOR(DATE($J$1+1,5,DAY(MINUTE($J$1/38)/2+56)),7)-34","v":"2025-03-30"},"2025-03-30","Easter Sunday",{"$nulls":6},"Calculated"]
[{"$f":"DATE($J$1+1, E23 + 1, 0) - MOD(WEEKDAY(DATE($J$1+1, E23 + 1, 0)) - F23, 7)","v":"2025-05-26"},"2025-05-26","Memorial Day",null,5,2,{"$nulls":3},"Last Monday in May (special calc)"]
[{"$f":"IF(WEEKDAY(DATE($J$1+1,E24,F24))=1,DATE($J$1+1,E24,F24+1),IF(WEEKDAY(DATE($J$1+1,E24,F24))=7,DATE($J$1+1,E24,F24-1),DATE($J$1+1,E24,F24)))","v":"2025-06-19"},"2025-06-19","Juneteenth (Obs)",null,6,19,{"$nulls":3},"Juneteenth"]
[{"$f":"IF(WEEKDAY(DATE($J$1+1,E25,F25))=1,DATE($J$1+1,E25,F25+1),IF(WEEKDAY(DATE($J$1+1,E25,F25))=7,DATE($J$1+1,E25,F25-1),DATE($J$1+1,E25,F25)))","v":"2025-07-04"},"2025-07-04","Independence Day (Obs)",null,7,4,{"$nulls":3},"Observed holiday is on weekday"]
[{"$f":"DATE($J$1+1,E26,1+((G26-(F26>=WEEKDAY(DATE($J$1+1,E26,1))))*7)+(F26-WEEKDAY(DATE($J$1+1,E26,1))))","v":"2025-09-01"},{"$f":"A26","v":"2025-09-01"},"Labor Day",null,9,2,1,null,null,"1st Monday in September"]
[{"$f":"DATE($J$1+1,E27,1+((G27-(F27>=WEEKDAY(DATE($J$1+1,E27,1))))*7)+(F27-WEEKDAY(DATE($J$1+1,E27,1))))","v":"2025-11-27"},{"$f":"A27","v":"2025-11-27"},"Thanksgiving Day",null,11,5,4,null,null,"4th Thursday in November"]
[{"$f":"DATE($J$1+1,11,11)","v":"2025-11-11"},{"$f":"A28","v":"2025-11-11"},"Veterans Day",{"$nulls":6},"Always November 11"]
[{"$f":"IF(WEEKDAY(DATE($J$1+1,E29,F29))=1,DATE($J$1+1,E29,F29+1),IF(WEEKDAY(DATE($J$1+1,E29,F29))=7,DATE($J$1+1,E29,F29-1),DATE($J$1+1,E29,F29)))","v":"2025-12-25"},{"$f":"A29","v":"2025-12-25"},"Christmas Day",null,12,25,{"$nulls":3},"Always December 25"]
[{"$f":"IF(WEEKDAY(DATE($J$1+1,E30,F30))=1,DATE($J$1+1,E30,F30+1),IF(WEEKDAY(DATE($J$1+1,E30,F30))=7,DATE($J$1+1,E30,F30-1),DATE($J$1+1,E30,F30)))","v":"2025-12-25"},{"$f":"A30","v":"2025-12-25"},"Christmas Day (Obs)",null,12,25,{"$nulls":3},"If Dec 25 on weekend, add observed"]
[]
[">>> insert rows above this line"]
[]
["To add your own holidays, copy one of the lines",{"$nulls":3},"Mo","Month (Jan=1)",{"$nulls":3},"SPECIAL RULES"]
["that matches the pattern, and edit the corresponding",{"$nulls":3},"DoW","Day of Week (Sun=1)",{"$nulls":3},"Easter Sunday"]
["columns E-H. See right for codes.",{"$nulls":3},"NthWk","Nth Week in Month",{"$nulls":3},"New Year's Day"]
[{"$nulls":9},"Memorial Day (last week of)"]
["For holidays that occur on the same date every year,"]
["just edit the formula that is in column A."]
[]
["WEEKDAY SHORT NAMES"]
["Modify NAME column only"]
[]
["Day","SName","Note"]
[1,{"$f":"PROPER(TEXT(A45,\"ddd\"))","v":"Sun"},"Sunday"]
[2,"Mo","Monday"]
[3,"Tu","Tuesday"]
[4,"We","Wednesday"]
[5,"Th","Thursday"]
[6,"Fr","Friday"]
[7,"Sa","Saturday"]
[]
["Choose what short name (SName) to use to"]
["represent the day"]