{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","12-Month","16-Month","Tables"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["About Dave Seah's Compact Calendar"]
["US : WEEK STARTING SUNDAY"]
[]
["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","For small projects, I don't usually need the entire calendar, so I just select the rows I need then PRINT SELECTION from the print dialog. The headers/footers are set up so that it \"prints clean\" with the legends. Works great!"]
[]
["Change the Date","If you need to change the year, just update the DATE cell in the upper right corner of the calendar header; the rest of the calendar should automatically be calculated and updated. "]
[]
["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."]
[]
["Customizing Days","If you don't like the use of R for Thursday, change the WEEKDAY TABLE on the 'Tables' worksheet."]
[]
["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","http://davidseah.com/pceo/cal"]

{"sheet":"12-Month","index":1,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[1,2,1,8],[0,4,0,8],[59,0,59,8]]}
["Compact Calendar",null,null,null,{"$f":"YEAR(C2)","v":2012}]
["STARTING DATE",null,"2012-01-01"]
["MONTH",null,{"$f":"VLOOKUP(WEEKDAY(C5),Tables!$L$4:$M$10,2)","v":"Su"},{"$f":"VLOOKUP(WEEKDAY(D5),Tables!$L$4:$M$10,2)","v":"Mo"},{"$f":"VLOOKUP(WEEKDAY(E5),Tables!$L$4:$M$10,2)","v":"Tu"},{"$f":"VLOOKUP(WEEKDAY(F5),Tables!$L$4:$M$10,2)","v":"We"},{"$f":"VLOOKUP(WEEKDAY(G5),Tables!$L$4:$M$10,2)","v":"Th"},{"$f":"VLOOKUP(WEEKDAY(H5),Tables!$L$4:$M$10,2)","v":"Fr"},{"$f":"VLOOKUP(WEEKDAY(I5),Tables!$L$4:$M$10,2)","v":"Sa"}]
[]
[{"$f":"IF(SUM(1*(DAY(C5:I5)=1))>0,I5,\"\")","v":""},null,{"$f":"D5-1","v":"2011-12-25"},"2011-12-26","2011-12-27","2011-12-28","2011-12-29","2011-12-30",{"$f":"$C$2-WEEKDAY($C$2)","v":"2011-12-31"}]
[{"$f":"IF(SUM(1*(DAY(C6:I6)=1))>0,I6,\"\")","v":"2012-01-07"},null,{"$f":"I5+1","v":"2012-01-01"},{"$f":"C6+1","v":"2012-01-02"},"2012-01-03","2012-01-04","2012-01-05","2012-01-06","2012-01-07"]
[{"$f":"IF(SUM(1*(DAY(C7:I7)=1))>0,I7,\"\")","v":""},null,"2012-01-08",{"$f":"C7+1","v":"2012-01-09"},{"$f":"D7+1","v":"2012-01-10"},"2012-01-11","2012-01-12","2012-01-13","2012-01-14"]
[{"$f":"IF(SUM(1*(DAY(C8:I8)=1))>0,I8,\"\")","v":""},null,"2012-01-15","2012-01-16","2012-01-17","2012-01-18","2012-01-19","2012-01-20","2012-01-21"]
[{"$f":"IF(SUM(1*(DAY(C9:I9)=1))>0,I9,\"\")","v":""},null,"2012-01-22","2012-01-23","2012-01-24","2012-01-25","2012-01-26","2012-01-27","2012-01-28"]
[{"$f":"IF(SUM(1*(DAY(C10:I10)=1))>0,I10,\"\")","v":"2012-02-04"},null,"2012-01-29","2012-01-30","2012-01-31","2012-02-01","2012-02-02","2012-02-03","2012-02-04"]
[{"$f":"IF(SUM(1*(DAY(C11:I11)=1))>0,I11,\"\")","v":""},null,"2012-02-05","2012-02-06","2012-02-07","2012-02-08","2012-02-09","2012-02-10","2012-02-11"]
[{"$f":"IF(SUM(1*(DAY(C12:I12)=1))>0,I12,\"\")","v":""},null,"2012-02-12","2012-02-13","2012-02-14","2012-02-15","2012-02-16","2012-02-17","2012-02-18"]
[{"$f":"IF(SUM(1*(DAY(C13:I13)=1))>0,I13,\"\")","v":""},null,"2012-02-19","2012-02-20","2012-02-21","2012-02-22","2012-02-23","2012-02-24","2012-02-25"]
[{"$f":"IF(SUM(1*(DAY(C14:I14)=1))>0,I14,\"\")","v":"2012-03-03"},null,"2012-02-26","2012-02-27","2012-02-28","2012-02-29","2012-03-01","2012-03-02","2012-03-03"]
[{"$f":"IF(SUM(1*(DAY(C15:I15)=1))>0,I15,\"\")","v":""},null,"2012-03-04","2012-03-05","2012-03-06","2012-03-07","2012-03-08","2012-03-09","2012-03-10"]
[{"$f":"IF(SUM(1*(DAY(C16:I16)=1))>0,I16,\"\")","v":""},null,"2012-03-11","2012-03-12","2012-03-13","2012-03-14","2012-03-15","2012-03-16","2012-03-17"]
[{"$f":"IF(SUM(1*(DAY(C17:I17)=1))>0,I17,\"\")","v":""},null,"2012-03-18","2012-03-19","2012-03-20","2012-03-21","2012-03-22","2012-03-23","2012-03-24"]
[{"$f":"IF(SUM(1*(DAY(C18:I18)=1))>0,I18,\"\")","v":""},null,"2012-03-25","2012-03-26","2012-03-27","2012-03-28","2012-03-29","2012-03-30","2012-03-31"]
[{"$f":"IF(SUM(1*(DAY(C19:I19)=1))>0,I19,\"\")","v":"2012-04-07"},null,"2012-04-01","2012-04-02","2012-04-03","2012-04-04","2012-04-05","2012-04-06","2012-04-07"]
[{"$f":"IF(SUM(1*(DAY(C20:I20)=1))>0,I20,\"\")","v":""},null,"2012-04-08","2012-04-09","2012-04-10","2012-04-11","2012-04-12","2012-04-13","2012-04-14"]
[{"$f":"IF(SUM(1*(DAY(C21:I21)=1))>0,I21,\"\")","v":""},null,"2012-04-15","2012-04-16","2012-04-17","2012-04-18","2012-04-19","2012-04-20","2012-04-21"]
[{"$f":"IF(SUM(1*(DAY(C22:I22)=1))>0,I22,\"\")","v":""},null,"2012-04-22","2012-04-23","2012-04-24","2012-04-25","2012-04-26","2012-04-27","2012-04-28"]
[{"$f":"IF(SUM(1*(DAY(C23:I23)=1))>0,I23,\"\")","v":"2012-05-05"},null,"2012-04-29","2012-04-30","2012-05-01","2012-05-02","2012-05-03","2012-05-04","2012-05-05"]
[{"$f":"IF(SUM(1*(DAY(C24:I24)=1))>0,I24,\"\")","v":""},null,"2012-05-06","2012-05-07","2012-05-08","2012-05-09","2012-05-10","2012-05-11","2012-05-12"]
[{"$f":"IF(SUM(1*(DAY(C25:I25)=1))>0,I25,\"\")","v":""},null,"2012-05-13","2012-05-14","2012-05-15","2012-05-16","2012-05-17","2012-05-18","2012-05-19"]
[{"$f":"IF(SUM(1*(DAY(C26:I26)=1))>0,I26,\"\")","v":""},null,"2012-05-20","2012-05-21","2012-05-22","2012-05-23","2012-05-24","2012-05-25","2012-05-26"]
[{"$f":"IF(SUM(1*(DAY(C27:I27)=1))>0,I27,\"\")","v":"2012-06-02"},null,"2012-05-27","2012-05-28","2012-05-29","2012-05-30","2012-05-31","2012-06-01","2012-06-02"]
[{"$f":"IF(SUM(1*(DAY(C28:I28)=1))>0,I28,\"\")","v":""},null,"2012-06-03","2012-06-04","2012-06-05","2012-06-06","2012-06-07","2012-06-08","2012-06-09"]
[{"$f":"IF(SUM(1*(DAY(C29:I29)=1))>0,I29,\"\")","v":""},null,"2012-06-10","2012-06-11","2012-06-12","2012-06-13","2012-06-14","2012-06-15","2012-06-16"]
[{"$f":"IF(SUM(1*(DAY(C30:I30)=1))>0,I30,\"\")","v":""},null,"2012-06-17","2012-06-18","2012-06-19","2012-06-20","2012-06-21","2012-06-22","2012-06-23"]
[{"$f":"IF(SUM(1*(DAY(C31:I31)=1))>0,I31,\"\")","v":""},null,"2012-06-24","2012-06-25","2012-06-26","2012-06-27","2012-06-28","2012-06-29","2012-06-30"]
[{"$f":"IF(SUM(1*(DAY(C32:I32)=1))>0,I32,\"\")","v":"2012-07-07"},null,"2012-07-01","2012-07-02","2012-07-03","2012-07-04","2012-07-05","2012-07-06","2012-07-07"]
[{"$f":"IF(SUM(1*(DAY(C33:I33)=1))>0,I33,\"\")","v":""},null,"2012-07-08","2012-07-09","2012-07-10","2012-07-11","2012-07-12","2012-07-13","2012-07-14"]
[{"$f":"IF(SUM(1*(DAY(C34:I34)=1))>0,I34,\"\")","v":""},null,"2012-07-15","2012-07-16","2012-07-17","2012-07-18","2012-07-19","2012-07-20","2012-07-21"]
[{"$f":"IF(SUM(1*(DAY(C35:I35)=1))>0,I35,\"\")","v":""},null,"2012-07-22","2012-07-23","2012-07-24","2012-07-25","2012-07-26","2012-07-27","2012-07-28"]
[{"$f":"IF(SUM(1*(DAY(C36:I36)=1))>0,I36,\"\")","v":"2012-08-04"},null,"2012-07-29","2012-07-30","2012-07-31","2012-08-01","2012-08-02","2012-08-03","2012-08-04"]
[{"$f":"IF(SUM(1*(DAY(C37:I37)=1))>0,I37,\"\")","v":""},null,"2012-08-05","2012-08-06","2012-08-07","2012-08-08","2012-08-09","2012-08-10","2012-08-11"]
[{"$f":"IF(SUM(1*(DAY(C38:I38)=1))>0,I38,\"\")","v":""},null,"2012-08-12","2012-08-13","2012-08-14","2012-08-15","2012-08-16","2012-08-17","2012-08-18"]
[{"$f":"IF(SUM(1*(DAY(C39:I39)=1))>0,I39,\"\")","v":""},null,{"$f":"I38+1","v":"2012-08-19"},{"$f":"C39+1","v":"2012-08-20"},"2012-08-21","2012-08-22","2012-08-23","2012-08-24","2012-08-25"]
[{"$f":"IF(SUM(1*(DAY(C40:I40)=1))>0,I40,\"\")","v":"2012-09-01"},null,"2012-08-26","2012-08-27","2012-08-28","2012-08-29","2012-08-30","2012-08-31","2012-09-01"]
[{"$f":"IF(SUM(1*(DAY(C41:I41)=1))>0,I41,\"\")","v":""},null,"2012-09-02","2012-09-03","2012-09-04","2012-09-05","2012-09-06","2012-09-07","2012-09-08"]
[{"$f":"IF(SUM(1*(DAY(C42:I42)=1))>0,I42,\"\")","v":""},null,"2012-09-09","2012-09-10","2012-09-11","2012-09-12","2012-09-13","2012-09-14","2012-09-15"]
[{"$f":"IF(SUM(1*(DAY(C43:I43)=1))>0,I43,\"\")","v":""},null,"2012-09-16","2012-09-17","2012-09-18","2012-09-19","2012-09-20","2012-09-21","2012-09-22"]
[{"$f":"IF(SUM(1*(DAY(C44:I44)=1))>0,I44,\"\")","v":""},null,"2012-09-23","2012-09-24","2012-09-25","2012-09-26","2012-09-27","2012-09-28","2012-09-29"]
[{"$f":"IF(SUM(1*(DAY(C45:I45)=1))>0,I45,\"\")","v":"2012-10-06"},null,"2012-09-30","2012-10-01","2012-10-02","2012-10-03","2012-10-04","2012-10-05","2012-10-06"]
[{"$f":"IF(SUM(1*(DAY(C46:I46)=1))>0,I46,\"\")","v":""},null,"2012-10-07","2012-10-08","2012-10-09","2012-10-10","2012-10-11","2012-10-12","2012-10-13"]
[{"$f":"IF(SUM(1*(DAY(C47:I47)=1))>0,I47,\"\")","v":""},null,"2012-10-14","2012-10-15","2012-10-16","2012-10-17","2012-10-18","2012-10-19","2012-10-20"]
[{"$f":"IF(SUM(1*(DAY(C48:I48)=1))>0,I48,\"\")","v":""},null,"2012-10-21","2012-10-22","2012-10-23","2012-10-24","2012-10-25","2012-10-26","2012-10-27"]
[{"$f":"IF(SUM(1*(DAY(C49:I49)=1))>0,I49,\"\")","v":"2012-11-03"},null,"2012-10-28","2012-10-29","2012-10-30","2012-10-31","2012-11-01","2012-11-02","2012-11-03"]
[{"$f":"IF(SUM(1*(DAY(C50:I50)=1))>0,I50,\"\")","v":""},null,"2012-11-04","2012-11-05","2012-11-06","2012-11-07","2012-11-08","2012-11-09","2012-11-10"]
[{"$f":"IF(SUM(1*(DAY(C51:I51)=1))>0,I51,\"\")","v":""},null,"2012-11-11","2012-11-12","2012-11-13","2012-11-14","2012-11-15","2012-11-16","2012-11-17"]
[{"$f":"IF(SUM(1*(DAY(C52:I52)=1))>0,I52,\"\")","v":""},null,"2012-11-18","2012-11-19","2012-11-20","2012-11-21",{"$f":"F52+1","v":"2012-11-22"},"2012-11-23","2012-11-24"]
[{"$f":"IF(SUM(1*(DAY(C53:I53)=1))>0,I53,\"\")","v":"2012-12-01"},null,"2012-11-25","2012-11-26","2012-11-27","2012-11-28","2012-11-29","2012-11-30","2012-12-01"]
[{"$f":"IF(SUM(1*(DAY(C54:I54)=1))>0,I54,\"\")","v":""},null,"2012-12-02","2012-12-03","2012-12-04","2012-12-05","2012-12-06","2012-12-07","2012-12-08"]
[{"$f":"IF(SUM(1*(DAY(C55:I55)=1))>0,I55,\"\")","v":""},null,"2012-12-09","2012-12-10","2012-12-11","2012-12-12","2012-12-13","2012-12-14","2012-12-15"]
[{"$f":"IF(SUM(1*(DAY(C56:I56)=1))>0,I56,\"\")","v":""},null,"2012-12-16","2012-12-17","2012-12-18","2012-12-19","2012-12-20","2012-12-21","2012-12-22"]
[{"$f":"IF(SUM(1*(DAY(C57:I57)=1))>0,I57,\"\")","v":""},null,"2012-12-23","2012-12-24","2012-12-25","2012-12-26","2012-12-27","2012-12-28","2012-12-29"]
[{"$f":"IF(SUM(1*(DAY(C58:I58)=1))>0,I58,\"\")","v":"2013-01-05"},null,"2012-12-30","2012-12-31",{"$f":"D58+1","v":"2013-01-01"},{"$f":"E58+1","v":"2013-01-02"},{"$f":"F58+1","v":"2013-01-03"},{"$f":"G58+1","v":"2013-01-04"},{"$f":"H58+1","v":"2013-01-05"}]
[{"$f":"IF(SUM(1*(DAY(C59:I59)=1))>0,I59,\"\")","v":""}]
["visit davidseah.com/pceo/cal for more info"]

{"sheet":"16-Month","index":2,"n_rows":91,"n_cols":9,"rows_kept":91,"cut":false,"hidden":false,"merged":[[0,4,0,8],[1,2,1,8],[90,0,90,8]]}
["Compact Calendar",null,null,null,{"$f":"CONCATENATE(YEAR(C2),\" ex\")","v":"2012 ex"}]
["STARTING DATE",null,"2012-01-01"]
["MONTH",null,{"$f":"VLOOKUP(WEEKDAY(C5),Tables!$L$4:$M$10,2)","v":"Su"},{"$f":"VLOOKUP(WEEKDAY(D5),Tables!$L$4:$M$10,2)","v":"Mo"},{"$f":"VLOOKUP(WEEKDAY(E5),Tables!$L$4:$M$10,2)","v":"Tu"},{"$f":"VLOOKUP(WEEKDAY(F5),Tables!$L$4:$M$10,2)","v":"We"},{"$f":"VLOOKUP(WEEKDAY(G5),Tables!$L$4:$M$10,2)","v":"Th"},{"$f":"VLOOKUP(WEEKDAY(H5),Tables!$L$4:$M$10,2)","v":"Fr"},{"$f":"VLOOKUP(WEEKDAY(I5),Tables!$L$4:$M$10,2)","v":"Sa"}]
[]
[{"$f":"IF(SUM(1*(DAY(C5:I5)=1))>0,I5,\"\")","v":""},null,{"$f":"D5-1","v":"2011-12-25"},"2011-12-26","2011-12-27","2011-12-28","2011-12-29","2011-12-30",{"$f":"$C$2-WEEKDAY($C$2)","v":"2011-12-31"}]
[{"$f":"IF(SUM(1*(DAY(C6:I6)=1))>0,I6,\"\")","v":"2012-01-07"},null,{"$f":"I5+1","v":"2012-01-01"},{"$f":"C6+1","v":"2012-01-02"},"2012-01-03","2012-01-04","2012-01-05","2012-01-06","2012-01-07"]
[{"$f":"IF(SUM(1*(DAY(C7:I7)=1))>0,I7,\"\")","v":""},null,"2012-01-08","2012-01-09","2012-01-10","2012-01-11","2012-01-12","2012-01-13","2012-01-14"]
[{"$f":"IF(SUM(1*(DAY(C8:I8)=1))>0,I8,\"\")","v":""},null,"2012-01-15","2012-01-16","2012-01-17","2012-01-18","2012-01-19","2012-01-20","2012-01-21"]
[{"$f":"IF(SUM(1*(DAY(C9:I9)=1))>0,I9,\"\")","v":""},null,"2012-01-22","2012-01-23","2012-01-24","2012-01-25","2012-01-26","2012-01-27","2012-01-28"]
[{"$f":"IF(SUM(1*(DAY(C10:I10)=1))>0,I10,\"\")","v":"2012-02-04"},null,"2012-01-29","2012-01-30","2012-01-31","2012-02-01","2012-02-02","2012-02-03","2012-02-04"]
[{"$f":"IF(SUM(1*(DAY(C11:I11)=1))>0,I11,\"\")","v":""},null,"2012-02-05","2012-02-06","2012-02-07","2012-02-08","2012-02-09","2012-02-10","2012-02-11"]
[{"$f":"IF(SUM(1*(DAY(C12:I12)=1))>0,I12,\"\")","v":""},null,"2012-02-12","2012-02-13","2012-02-14","2012-02-15","2012-02-16","2012-02-17","2012-02-18"]
[{"$f":"IF(SUM(1*(DAY(C13:I13)=1))>0,I13,\"\")","v":""},null,"2012-02-19","2012-02-20","2012-02-21","2012-02-22","2012-02-23","2012-02-24","2012-02-25"]
[{"$f":"IF(SUM(1*(DAY(C14:I14)=1))>0,I14,\"\")","v":"2012-03-03"},null,"2012-02-26","2012-02-27","2012-02-28","2012-02-29","2012-03-01","2012-03-02","2012-03-03"]
[{"$f":"IF(SUM(1*(DAY(C15:I15)=1))>0,I15,\"\")","v":""},null,"2012-03-04","2012-03-05","2012-03-06","2012-03-07","2012-03-08","2012-03-09","2012-03-10"]
[{"$f":"IF(SUM(1*(DAY(C16:I16)=1))>0,I16,\"\")","v":""},null,"2012-03-11","2012-03-12","2012-03-13","2012-03-14","2012-03-15","2012-03-16","2012-03-17"]
[{"$f":"IF(SUM(1*(DAY(C17:I17)=1))>0,I17,\"\")","v":""},null,"2012-03-18","2012-03-19","2012-03-20","2012-03-21","2012-03-22","2012-03-23","2012-03-24"]
[{"$f":"IF(SUM(1*(DAY(C18:I18)=1))>0,I18,\"\")","v":""},null,"2012-03-25","2012-03-26","2012-03-27","2012-03-28","2012-03-29","2012-03-30","2012-03-31"]
[{"$f":"IF(SUM(1*(DAY(C19:I19)=1))>0,I19,\"\")","v":"2012-04-07"},null,"2012-04-01","2012-04-02","2012-04-03","2012-04-04","2012-04-05","2012-04-06","2012-04-07"]
[{"$f":"IF(SUM(1*(DAY(C20:I20)=1))>0,I20,\"\")","v":""},null,"2012-04-08","2012-04-09","2012-04-10","2012-04-11","2012-04-12","2012-04-13","2012-04-14"]
[{"$f":"IF(SUM(1*(DAY(C21:I21)=1))>0,I21,\"\")","v":""},null,"2012-04-15","2012-04-16","2012-04-17","2012-04-18","2012-04-19","2012-04-20","2012-04-21"]
[{"$f":"IF(SUM(1*(DAY(C22:I22)=1))>0,I22,\"\")","v":""},null,"2012-04-22",{"$f":"C22+1","v":"2012-04-23"},"2012-04-24","2012-04-25","2012-04-26","2012-04-27","2012-04-28"]
[{"$f":"IF(SUM(1*(DAY(C23:I23)=1))>0,I23,\"\")","v":"2012-05-05"},null,"2012-04-29","2012-04-30","2012-05-01","2012-05-02","2012-05-03","2012-05-04","2012-05-05"]
[{"$f":"IF(SUM(1*(DAY(C24:I24)=1))>0,I24,\"\")","v":""},null,"2012-05-06","2012-05-07","2012-05-08","2012-05-09","2012-05-10","2012-05-11","2012-05-12"]
[{"$f":"IF(SUM(1*(DAY(C25:I25)=1))>0,I25,\"\")","v":""},null,"2012-05-13","2012-05-14","2012-05-15","2012-05-16","2012-05-17","2012-05-18","2012-05-19"]
[{"$f":"IF(SUM(1*(DAY(C26:I26)=1))>0,I26,\"\")","v":""},null,"2012-05-20","2012-05-21","2012-05-22","2012-05-23","2012-05-24","2012-05-25","2012-05-26"]
[{"$f":"IF(SUM(1*(DAY(C27:I27)=1))>0,I27,\"\")","v":"2012-06-02"},null,"2012-05-27","2012-05-28","2012-05-29","2012-05-30","2012-05-31","2012-06-01","2012-06-02"]
[{"$f":"IF(SUM(1*(DAY(C28:I28)=1))>0,I28,\"\")","v":""},null,"2012-06-03","2012-06-04","2012-06-05","2012-06-06","2012-06-07","2012-06-08","2012-06-09"]
[{"$f":"IF(SUM(1*(DAY(C29:I29)=1))>0,I29,\"\")","v":""},null,"2012-06-10","2012-06-11","2012-06-12","2012-06-13","2012-06-14","2012-06-15","2012-06-16"]
[{"$f":"IF(SUM(1*(DAY(C30:I30)=1))>0,I30,\"\")","v":""},null,"2012-06-17","2012-06-18","2012-06-19","2012-06-20","2012-06-21","2012-06-22","2012-06-23"]
[{"$f":"IF(SUM(1*(DAY(C31:I31)=1))>0,I31,\"\")","v":""},null,"2012-06-24","2012-06-25","2012-06-26","2012-06-27","2012-06-28","2012-06-29","2012-06-30"]
[{"$f":"IF(SUM(1*(DAY(C32:I32)=1))>0,I32,\"\")","v":"2012-07-07"},null,"2012-07-01","2012-07-02","2012-07-03","2012-07-04","2012-07-05","2012-07-06","2012-07-07"]
[{"$f":"IF(SUM(1*(DAY(C33:I33)=1))>0,I33,\"\")","v":""},null,"2012-07-08","2012-07-09","2012-07-10","2012-07-11","2012-07-12","2012-07-13","2012-07-14"]
[{"$f":"IF(SUM(1*(DAY(C34:I34)=1))>0,I34,\"\")","v":""},null,"2012-07-15","2012-07-16","2012-07-17","2012-07-18","2012-07-19","2012-07-20","2012-07-21"]
[{"$f":"IF(SUM(1*(DAY(C35:I35)=1))>0,I35,\"\")","v":""},null,"2012-07-22","2012-07-23","2012-07-24","2012-07-25","2012-07-26","2012-07-27","2012-07-28"]
[{"$f":"IF(SUM(1*(DAY(C36:I36)=1))>0,I36,\"\")","v":"2012-08-04"},null,"2012-07-29","2012-07-30","2012-07-31","2012-08-01","2012-08-02","2012-08-03","2012-08-04"]
[{"$f":"IF(SUM(1*(DAY(C37:I37)=1))>0,I37,\"\")","v":""},null,"2012-08-05","2012-08-06","2012-08-07","2012-08-08","2012-08-09","2012-08-10","2012-08-11"]
[{"$f":"IF(SUM(1*(DAY(C38:I38)=1))>0,I38,\"\")","v":""},null,"2012-08-12","2012-08-13","2012-08-14","2012-08-15","2012-08-16","2012-08-17","2012-08-18"]
[{"$f":"IF(SUM(1*(DAY(C39:I39)=1))>0,I39,\"\")","v":""},null,"2012-08-19","2012-08-20","2012-08-21","2012-08-22","2012-08-23","2012-08-24","2012-08-25"]
[{"$f":"IF(SUM(1*(DAY(C40:I40)=1))>0,I40,\"\")","v":"2012-09-01"},null,"2012-08-26","2012-08-27","2012-08-28","2012-08-29","2012-08-30","2012-08-31","2012-09-01"]
[{"$f":"IF(SUM(1*(DAY(C41:I41)=1))>0,I41,\"\")","v":""},null,"2012-09-02","2012-09-03","2012-09-04","2012-09-05","2012-09-06","2012-09-07","2012-09-08"]
[{"$f":"IF(SUM(1*(DAY(C42:I42)=1))>0,I42,\"\")","v":""},null,"2012-09-09","2012-09-10","2012-09-11","2012-09-12","2012-09-13","2012-09-14","2012-09-15"]
[{"$f":"IF(SUM(1*(DAY(C43:I43)=1))>0,I43,\"\")","v":""},null,"2012-09-16","2012-09-17","2012-09-18","2012-09-19","2012-09-20","2012-09-21","2012-09-22"]
[{"$f":"IF(SUM(1*(DAY(C44:I44)=1))>0,I44,\"\")","v":""},null,"2012-09-23","2012-09-24","2012-09-25","2012-09-26","2012-09-27","2012-09-28","2012-09-29"]
[{"$f":"IF(SUM(1*(DAY(C45:I45)=1))>0,I45,\"\")","v":"2012-10-06"},null,"2012-09-30","2012-10-01","2012-10-02","2012-10-03","2012-10-04","2012-10-05","2012-10-06"]
[{"$f":"IF(SUM(1*(DAY(C46:I46)=1))>0,I46,\"\")","v":""},null,"2012-10-07","2012-10-08","2012-10-09","2012-10-10","2012-10-11","2012-10-12","2012-10-13"]
[{"$f":"IF(SUM(1*(DAY(C47:I47)=1))>0,I47,\"\")","v":""},null,"2012-10-14","2012-10-15","2012-10-16","2012-10-17","2012-10-18","2012-10-19","2012-10-20"]
[{"$f":"IF(SUM(1*(DAY(C48:I48)=1))>0,I48,\"\")","v":""},null,"2012-10-21","2012-10-22","2012-10-23","2012-10-24","2012-10-25","2012-10-26","2012-10-27"]
[{"$f":"IF(SUM(1*(DAY(C49:I49)=1))>0,I49,\"\")","v":"2012-11-03"},null,"2012-10-28","2012-10-29","2012-10-30","2012-10-31","2012-11-01","2012-11-02","2012-11-03"]
[{"$f":"IF(SUM(1*(DAY(C50:I50)=1))>0,I50,\"\")","v":""},null,"2012-11-04","2012-11-05","2012-11-06","2012-11-07","2012-11-08","2012-11-09","2012-11-10"]
[{"$f":"IF(SUM(1*(DAY(C51:I51)=1))>0,I51,\"\")","v":""},null,"2012-11-11","2012-11-12","2012-11-13","2012-11-14","2012-11-15","2012-11-16","2012-11-17"]
[{"$f":"IF(SUM(1*(DAY(C52:I52)=1))>0,I52,\"\")","v":""},null,"2012-11-18","2012-11-19","2012-11-20","2012-11-21",{"$f":"F52+1","v":"2012-11-22"},"2012-11-23","2012-11-24"]
[{"$f":"IF(SUM(1*(DAY(C53:I53)=1))>0,I53,\"\")","v":"2012-12-01"},null,"2012-11-25","2012-11-26","2012-11-27","2012-11-28","2012-11-29","2012-11-30","2012-12-01"]
[{"$f":"IF(SUM(1*(DAY(C54:I54)=1))>0,I54,\"\")","v":""},null,"2012-12-02",{"$f":"C54+1","v":"2012-12-03"},"2012-12-04","2012-12-05","2012-12-06","2012-12-07","2012-12-08"]
[{"$f":"IF(SUM(1*(DAY(C55:I55)=1))>0,I55,\"\")","v":""},null,"2012-12-09","2012-12-10","2012-12-11","2012-12-12","2012-12-13","2012-12-14","2012-12-15"]
[{"$f":"IF(SUM(1*(DAY(C56:I56)=1))>0,I56,\"\")","v":""},null,"2012-12-16","2012-12-17","2012-12-18","2012-12-19","2012-12-20","2012-12-21","2012-12-22"]
[{"$f":"IF(SUM(1*(DAY(C57:I57)=1))>0,I57,\"\")","v":""},null,"2012-12-23","2012-12-24","2012-12-25","2012-12-26","2012-12-27","2012-12-28","2012-12-29"]
[{"$f":"IF(SUM(1*(DAY(C58:I58)=1))>0,I58,\"\")","v":"2013-01-05"},null,"2012-12-30","2012-12-31",{"$f":"D58+1","v":"2013-01-01"},{"$f":"E58+1","v":"2013-01-02"},{"$f":"F58+1","v":"2013-01-03"},{"$f":"G58+1","v":"2013-01-04"},{"$f":"H58+1","v":"2013-01-05"}]
[{"$f":"IF(SUM(1*(DAY(C59:I59)=1))>0,I59,\"\")","v":""},null,{"$f":"I58+1","v":"2013-01-06"},{"$f":"C59+1","v":"2013-01-07"},{"$f":"D59+1","v":"2013-01-08"},{"$f":"E59+1","v":"2013-01-09"},{"$f":"F59+1","v":"2013-01-10"},{"$f":"G59+1","v":"2013-01-11"},{"$f":"H59+1","v":"2013-01-12"}]
[{"$f":"IF(SUM(1*(DAY(C60:I60)=1))>0,I60,\"\")","v":""},null,"2013-01-13","2013-01-14","2013-01-15","2013-01-16","2013-01-17","2013-01-18","2013-01-19"]
[{"$f":"IF(SUM(1*(DAY(C61:I61)=1))>0,I61,\"\")","v":""},null,"2013-01-20","2013-01-21","2013-01-22","2013-01-23","2013-01-24","2013-01-25","2013-01-26"]
[{"$f":"IF(SUM(1*(DAY(C62:I62)=1))>0,I62,\"\")","v":"2013-02-02"},null,"2013-01-27","2013-01-28","2013-01-29","2013-01-30","2013-01-31","2013-02-01","2013-02-02"]
[{"$f":"IF(SUM(1*(DAY(C63:I63)=1))>0,I63,\"\")","v":""},null,"2013-02-03","2013-02-04","2013-02-05","2013-02-06","2013-02-07","2013-02-08","2013-02-09"]
[{"$f":"IF(SUM(1*(DAY(C64:I64)=1))>0,I64,\"\")","v":""},null,"2013-02-10","2013-02-11","2013-02-12","2013-02-13","2013-02-14","2013-02-15","2013-02-16"]
[{"$f":"IF(SUM(1*(DAY(C65:I65)=1))>0,I65,\"\")","v":""},null,"2013-02-17","2013-02-18","2013-02-19","2013-02-20","2013-02-21","2013-02-22","2013-02-23"]
[{"$f":"IF(SUM(1*(DAY(C66:I66)=1))>0,I66,\"\")","v":"2013-03-02"},null,"2013-02-24","2013-02-25","2013-02-26","2013-02-27","2013-02-28","2013-03-01","2013-03-02"]
[{"$f":"IF(SUM(1*(DAY(C67:I67)=1))>0,I67,\"\")","v":""},null,"2013-03-03","2013-03-04","2013-03-05","2013-03-06","2013-03-07","2013-03-08","2013-03-09"]
[{"$f":"IF(SUM(1*(DAY(C68:I68)=1))>0,I68,\"\")","v":""},null,"2013-03-10","2013-03-11","2013-03-12","2013-03-13","2013-03-14","2013-03-15","2013-03-16"]
[{"$f":"IF(SUM(1*(DAY(C69:I69)=1))>0,I69,\"\")","v":""},null,"2013-03-17","2013-03-18","2013-03-19","2013-03-20","2013-03-21","2013-03-22","2013-03-23"]
[{"$f":"IF(SUM(1*(DAY(C70:I70)=1))>0,I70,\"\")","v":""},null,"2013-03-24","2013-03-25","2013-03-26","2013-03-27","2013-03-28","2013-03-29","2013-03-30"]
[{"$f":"IF(SUM(1*(DAY(C71:I71)=1))>0,I71,\"\")","v":"2013-04-06"},null,"2013-03-31","2013-04-01","2013-04-02","2013-04-03","2013-04-04","2013-04-05","2013-04-06"]
[{"$f":"IF(SUM(1*(DAY(C72:I72)=1))>0,I72,\"\")","v":""},null,"2013-04-07","2013-04-08","2013-04-09","2013-04-10","2013-04-11","2013-04-12","2013-04-13"]
[{"$f":"IF(SUM(1*(DAY(C73:I73)=1))>0,I73,\"\")","v":""},null,"2013-04-14","2013-04-15","2013-04-16","2013-04-17","2013-04-18","2013-04-19","2013-04-20"]
[{"$f":"IF(SUM(1*(DAY(C74:I74)=1))>0,I74,\"\")","v":""},null,"2013-04-21","2013-04-22","2013-04-23","2013-04-24","2013-04-25","2013-04-26","2013-04-27"]
[{"$f":"IF(SUM(1*(DAY(C75:I75)=1))>0,I75,\"\")","v":"2013-05-04"},null,"2013-04-28","2013-04-29","2013-04-30","2013-05-01","2013-05-02","2013-05-03","2013-05-04"]
[{"$f":"IF(SUM(1*(DAY(C76:I76)=1))>0,I76,\"\")","v":""},null,"2013-05-05","2013-05-06","2013-05-07","2013-05-08","2013-05-09","2013-05-10","2013-05-11"]
[{"$f":"IF(SUM(1*(DAY(C77:I77)=1))>0,I77,\"\")","v":""},null,"2013-05-12","2013-05-13","2013-05-14","2013-05-15","2013-05-16","2013-05-17","2013-05-18"]
[{"$f":"IF(SUM(1*(DAY(C78:I78)=1))>0,I78,\"\")","v":""},null,"2013-05-19","2013-05-20","2013-05-21","2013-05-22","2013-05-23","2013-05-24","2013-05-25"]
[{"$f":"IF(SUM(1*(DAY(C79:I79)=1))>0,I79,\"\")","v":"2013-06-01"},null,"2013-05-26","2013-05-27","2013-05-28","2013-05-29","2013-05-30","2013-05-31","2013-06-01"]
[{"$f":"IF(SUM(1*(DAY(C80:I80)=1))>0,I80,\"\")","v":""},null,"2013-06-02","2013-06-03","2013-06-04","2013-06-05","2013-06-06","2013-06-07","2013-06-08"]
[{"$f":"IF(SUM(1*(DAY(C81:I81)=1))>0,I81,\"\")","v":""},null,"2013-06-09","2013-06-10","2013-06-11","2013-06-12","2013-06-13","2013-06-14","2013-06-15"]
[{"$f":"IF(SUM(1*(DAY(C82:I82)=1))>0,I82,\"\")","v":""},null,{"$f":"I81+1","v":"2013-06-16"},{"$f":"C82+1","v":"2013-06-17"},"2013-06-18","2013-06-19","2013-06-20","2013-06-21","2013-06-22"]
[{"$f":"IF(SUM(1*(DAY(C83:I83)=1))>0,I83,\"\")","v":""},null,{"$f":"I82+1","v":"2013-06-23"},"2013-06-24","2013-06-25","2013-06-26","2013-06-27","2013-06-28","2013-06-29"]
[{"$f":"IF(SUM(1*(DAY(C84:I84)=1))>0,I84,\"\")","v":"2013-07-06"},null,{"$f":"I83+1","v":"2013-06-30"},"2013-07-01","2013-07-02","2013-07-03","2013-07-04","2013-07-05","2013-07-06"]
[{"$f":"IF(SUM(1*(DAY(C85:I85)=1))>0,I85,\"\")","v":""},null,{"$f":"I84+1","v":"2013-07-07"},{"$f":"C85+1","v":"2013-07-08"},"2013-07-09","2013-07-10","2013-07-11","2013-07-12","2013-07-13"]
[{"$f":"IF(SUM(1*(DAY(C86:I86)=1))>0,I86,\"\")","v":""},null,"2013-07-14",{"$f":"C86+1","v":"2013-07-15"},"2013-07-16","2013-07-17","2013-07-18","2013-07-19","2013-07-20"]
[{"$f":"IF(SUM(1*(DAY(C87:I87)=1))>0,I87,\"\")","v":""},null,"2013-07-21",{"$f":"C87+1","v":"2013-07-22"},"2013-07-23","2013-07-24","2013-07-25","2013-07-26","2013-07-27"]
[{"$f":"IF(SUM(1*(DAY(C88:I88)=1))>0,I88,\"\")","v":"2013-08-03"},null,"2013-07-28",{"$f":"C88+1","v":"2013-07-29"},"2013-07-30","2013-07-31","2013-08-01","2013-08-02","2013-08-03"]
[{"$f":"IF(SUM(1*(DAY(C89:I89)=1))>0,I89,\"\")","v":""},null,"2013-08-04",{"$f":"C89+1","v":"2013-08-05"},"2013-08-06","2013-08-07","2013-08-08","2013-08-09","2013-08-10"]
[]
["visit davidseah.com/pceo/cal for more info"]

{"sheet":"Tables","index":3,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["HOLIDAY LOOKUP TABLE",null,null,null,null,null,null,null,null,null,null,"WEEKDAYS TABLE"]
["The holidays in this table are calculated automatically. Change the year on Calendar worksheet to update this list",null,null,null,null,null,null,null,null,null,null,"Modify NAME column only"]
["DATE",null,"DESCRIPTION",null,"Mo","DoW","NthWk","NoMo",null,"Notes",null,"DAY#","NAME","NOTE"]
[{"$f":"IF(WEEKDAY(DATE(YEAR('12-Month'!$C$2),1,1))=1,DATE(YEAR('12-Month'!$C$2),1,2),IF(WEEKDAY(DATE(YEAR('12-Month'!$C$2),1,1))=7,DATE(YEAR('12-Month'!$C$2)-1,12,31),DATE(YEAR('12-Month'!$C$2),1,1)))","v":"2012-01-02"},{"$f":"A4","v":"2012-01-02"},"New Year's Day (Obs)",null,null,null,null,null,null,"Observed holiday is on weekday",null,1,"Su","Sunday"]
[{"$f":"DATE(YEAR('12-Month'!$C$2),E5,1+((G5-(F5>=WEEKDAY(DATE(YEAR('12-Month'!$C$2),E5,1))))*7)+(F5-WEEKDAY(DATE(YEAR('12-Month'!$C$2),E5,1))))","v":"2012-01-16"},{"$f":"A5","v":"2012-01-16"},"Martin Luther King Day",null,1,2,3,null,null,"3rd Monday in January",null,2,"Mo","Monday"]
[{"$f":"DATE(YEAR('12-Month'!$C$2),E6,1+((G6-(F6>=WEEKDAY(DATE(YEAR('12-Month'!$C$2),E6,1))))*7)+(F6-WEEKDAY(DATE(YEAR('12-Month'!$C$2),E6,1))))","v":"2012-02-20"},"2012-02-20","President's Day",null,2,2,3,null,null,"3rd Monday in February",null,3,"Tu","Tuesday"]
[{"$f":"FLOOR(DATE(YEAR('12-Month'!$C$2),5,DAY(MINUTE(YEAR('12-Month'!$C$2)/38)/2+56)),7)-34","v":"2012-04-08"},"2012-04-08","Easter Sunday",null,null,null,null,null,null,"Calculated",null,4,"We","Wednesday"]
[{"$f":"DATE(YEAR('12-Month'!$C$2),E8,1+((H8-(F8>=WEEKDAY(DATE(YEAR('12-Month'!$C$2),E8,1))))*7)+(F8-WEEKDAY(DATE(YEAR('12-Month'!$C$2),E8,1))))","v":"2012-05-28"},"2012-05-28","Memorial Day",null,5,2,null,{"$f":"SUM((WEEKDAY(DATE(YEAR('12-Month'!$C$2),E8,(ROW(INDIRECT(\"1:\"&DAY(DATE(YEAR('12-Month'!$C$2),E8+1,0)))))))=F8)*1)","v":4},null,"Last Monday in May (special calc)",null,5,"Th","Thursday"]
[{"$f":"IF(WEEKDAY(DATE(YEAR('12-Month'!$C$2),7,4))=1,DATE(YEAR('12-Month'!$C$2),7,5),IF(WEEKDAY(DATE(YEAR('12-Month'!$C$2),7,4))=7,DATE(YEAR('12-Month'!$C$2),7,3),DATE(YEAR('12-Month'!$C$2),7,4)))","v":"2012-07-04"},"2012-07-04","Independence Day (Obs)",null,null,null,null,null,null,"Observed holiday is on weekday",null,6,"Fr","Friday"]
[{"$f":"DATE(YEAR('12-Month'!$C$2),E10,1+((G10-(F10>=WEEKDAY(DATE(YEAR('12-Month'!$C$2),E10,1))))*7)+(F10-WEEKDAY(DATE(YEAR('12-Month'!$C$2),E10,1))))","v":"2012-09-03"},"2012-09-03","Labor Day",null,9,2,1,null,null,"1st Monday in September",null,7,"Sa","Saturday"]
[{"$f":"DATE(YEAR('12-Month'!$C$2),E11,1+((G11-(F11>=WEEKDAY(DATE(YEAR('12-Month'!$C$2),E11,1))))*7)+(F11-WEEKDAY(DATE(YEAR('12-Month'!$C$2),E11,1))))","v":"2012-11-22"},"2012-11-22","Thanksgiving Day",null,11,5,4,null,null,"4th Thursday in November"]
[{"$f":"IF(WEEKDAY(DATE(YEAR('12-Month'!$C$2),11,11))=1,DATE(YEAR('12-Month'!$C$2),11,12),IF(WEEKDAY(DATE(YEAR('12-Month'!$C$2),11,11))=7,DATE(YEAR('12-Month'!$C$2),11,10),DATE(YEAR('12-Month'!$C$2),11,11)))","v":"2012-11-12"},{"$f":"A12","v":"2012-11-12"},"Veterans Day (Obs)",null,null,null,null,null,null,null,null,"Choose what letter to use to"]
[{"$f":"DATE(YEAR('12-Month'!$C$2),12,25)","v":"2012-12-25"},"2012-12-25","Christmas Day",null,null,null,null,null,null,"Always December 25",null,"represent the day"]
[{"$f":"IF(WEEKDAY(DATE(YEAR('12-Month'!$C$2),12,25))=1,DATE(YEAR('12-Month'!$C$2),12,26),IF(WEEKDAY(DATE(YEAR('12-Month'!$C$2),12,25))=7,DATE(YEAR('12-Month'!$C$2),12,24),DATE(YEAR('12-Month'!$C$2),12,25)))","v":"2012-12-25"},{"$f":"A14","v":"2012-12-25"},"Christmas Day (Obs)",null,null,null,null,null,null,"If Dec 25 on weekend, add observed"]
[{"$f":"IF(WEEKDAY(DATE(YEAR('12-Month'!$C$2)+1,1,1))=1,DATE(YEAR('12-Month'!$C$2)+1,1,2),IF(WEEKDAY(DATE(YEAR('12-Month'!$C$2)+1,1,1))=7,DATE(YEAR('12-Month'!$C$2),12,31),DATE(YEAR('12-Month'!$C$2)+1,1,1)))","v":"2013-01-01"},"2013-01-01","New Year's Day (Obs)",null,null,null,null,null,null,"Observed holiday is on weekday"]
[{"$f":"DATE(YEAR('12-Month'!$C$2)+1,E16,1+((G16-(F16>=WEEKDAY(DATE(YEAR('12-Month'!$C$2)+1,E16,1))))*7)+(F16-WEEKDAY(DATE(YEAR('12-Month'!$C$2)+1,E16,1))))","v":"2013-01-21"},"2013-01-21","Martin Luther King Day",null,1,2,3,null,null,"3rd Monday in January"]
[{"$f":"DATE(YEAR('12-Month'!$C$2)+1,E17,1+((G17-(F17>=WEEKDAY(DATE(YEAR('12-Month'!$C$2)+1,E17,1))))*7)+(F17-WEEKDAY(DATE(YEAR('12-Month'!$C$2)+1,E17,1))))","v":"2013-02-18"},"2013-02-18","President's Day",null,2,2,3,null,null,"3rd Monday in February"]
[{"$f":"FLOOR(DATE(YEAR('12-Month'!$C$2)+1,5,DAY(MINUTE((YEAR('12-Month'!$C$2)+1)/38)/2+56)),7)-34","v":"2013-03-31"},"2013-03-31","Easter Sunday",null,null,null,null,null,null,"Calculated"]
[{"$f":"DATE(YEAR('12-Month'!$C$2)+1,E19,1+((H19-(F19>=WEEKDAY(DATE(YEAR('12-Month'!$C$2)+1,E19,1))))*7)+(F19-WEEKDAY(DATE(YEAR('12-Month'!$C$2)+1,E19,1))))","v":"2013-05-27"},"2013-05-27","Memorial Day",null,5,2,null,{"$f":"SUM((WEEKDAY(DATE(YEAR('12-Month'!$C$2)+1,E19,(ROW(INDIRECT(\"1:\"&DAY(DATE(YEAR('12-Month'!$C$2)+1,E19+1,0)))))))=F19)*1)","v":4},null,"Last Monday in May (special calc)"]
[{"$f":"IF(WEEKDAY(DATE(YEAR('12-Month'!$C$2)+1,7,4))=1,DATE(YEAR('12-Month'!$C$2)+1,7,5),IF(WEEKDAY(DATE(YEAR('12-Month'!$C$2)+1,7,4))=7,DATE(YEAR('12-Month'!$C$2)+1,7,3),DATE(YEAR('12-Month'!$C$2)+1,7,4)))","v":"2013-07-04"},"2013-07-04","Independence Day (Obs)",null,null,null,null,null,null,"Observed holiday is on weekday"]
[]
[]
[]
[]
[]
[]
[]
[]
[">>> insert rows above this line"]
[]
["To add your own holidays, copy one of the lines",null,null,null,"Mo","Month (Jan=1)"]
["that matches the pattern, and edit the corresponding",null,null,null,"DoW","Day of Week (Sun=1)"]
["columns E-H. See right for codes.",null,null,null,"NthWk","Nth Week in Month"]
[null,null,null,null,"NoMo","Num Days in Month"]
["For holidays that occur on the same date every year,"]
["just edit the formula that is in column A."]