工作日解决方案，求解过程，附件是2019-2021工作日清单

求比如2020.1.1日 到2020.2.13一共有几个工作日，网上查了一圈，没有工作日维护清单，excle也没有工作日调用接口；

仔细考虑，也确实没有工作日的通用公示，美国和中国都不一样，今年和明年也不一样，这个是国家法定的；

所以思路就变成了，维护每天是否是工作日，然后按照一个起始点来计算。

比如我维护了2019.1.1日开始的工作日清单，然后按照2020.1.1到2019.1.1一共有250个工作日，到2020.2.13有275个工作日

所以他们之间有275-250=25个工作日，至于掐头还是去尾巴（+1,-1还是不加不减），就根据实际需要来操作。

要求工作日的几个步骤：

第一步：确定起始日期，就是最早起始日期，比如1999.1.1

第二步：维护起始日期开始后到现在的每天是否工作日，比如1999.1.1,1999.1.2日每天都要维护；这个要网上查每年的放假清单；

第三步：根据工作日差，求任意两个日期间的工作日差

--附件是2019-2021年的工作日清单

2019-2021工作日清单.xls-互联网文档类资源-CSDN下载

下面是2019年1月的工作日清单案例，是个xml格式的，保存到txt，然后另存为xml，用wps打开就行。

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><Author>User</Author><LastAuthor>User</LastAuthor><Created>2022-05-21T11:33:06Z</Created><LastSaved>2022-05-21T11:33:26Z</LastSaved></DocumentProperties><CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><KSOProductBuildVer dt:dt="string">2052-11.1.0.10132</KSOProductBuildVer></CustomDocumentProperties><ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"><WindowWidth>18600</WindowWidth><WindowHeight>6980</WindowHeight><ProtectStructure>False</ProtectStructure><ProtectWindows>False</ProtectWindows></ExcelWorkbook><Styles><Style ss:ID="s25" ss:Name="计算"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FA7D00" ss:Bold="1"/><Interior ss:Color="#F2F2F2" ss:Pattern="Solid"/></Style><Style ss:ID="s12" ss:Name="已访问的超链接"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#800080" ss:Underline="Single"/></Style><Style ss:ID="s8" ss:Name="千位分隔"><NumberFormat ss:Format="_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * &quot;-&quot;??_ ;_ @_ "/></Style><Style ss:ID="s20" ss:Name="标题 2"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2" ss:Color="#5B9BD5"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="13" ss:Color="#44546A" ss:Bold="1"/></Style><Style ss:ID="s17" ss:Name="标题"><Font ss:FontName="宋体" x:CharSet="134" ss:Size="18" ss:Color="#44546A" ss:Bold="1"/></Style><Style ss:ID="s5" ss:Name="千位分隔[0]"><NumberFormat ss:Format="_ * #,##0_ ;_ * \-#,##0_ ;_ * &quot;-&quot;_ ;_ @_ "/></Style><Style ss:ID="s22" ss:Name="标题 3"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2" ss:Color="#ACCCEA"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#44546A" ss:Bold="1"/></Style><Style ss:ID="s11" ss:Name="百分比"><NumberFormat ss:Format="0%"/></Style><Style ss:ID="s4" ss:Name="货币"><NumberFormat ss:Format="_ &quot;￥&quot;* #,##0.00_ ;_ &quot;￥&quot;* \-#,##0.00_ ;_ &quot;￥&quot;* &quot;-&quot;??_ ;_ @_ "/></Style><Style ss:ID="s18" ss:Name="解释性文本"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#7F7F7F" ss:Italic="1"/></Style><Style ss:ID="s15" ss:Name="标题 4"><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#44546A" ss:Bold="1"/></Style><Style ss:ID="s3" ss:Name="输入"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#3F3F76"/><Interior ss:Color="#FFCC99" ss:Pattern="Solid"/></Style><Style ss:ID="s26" ss:Name="检查单元格"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#3F3F3F"/><Border ss:Position="Left" ss:LineStyle="Double" ss:Weight="3" ss:Color="#3F3F3F"/><Border ss:Position="Right" ss:LineStyle="Double" ss:Weight="3" ss:Color="#3F3F3F"/><Border ss:Position="Top" ss:LineStyle="Double" ss:Weight="3" ss:Color="#3F3F3F"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF" ss:Bold="1"/><Interior ss:Color="#A5A5A5" ss:Pattern="Solid"/></Style><Style ss:ID="s19" ss:Name="标题 1"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2" ss:Color="#5B9BD5"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="15" ss:Color="#44546A" ss:Bold="1"/></Style><Style ss:ID="s1" ss:Name="货币[0]"><NumberFormat ss:Format="_ &quot;￥&quot;* #,##0_ ;_ &quot;￥&quot;* \-#,##0_ ;_ &quot;￥&quot;* &quot;-&quot;_ ;_ @_ "/></Style><Style ss:ID="s29" ss:Name="链接单元格"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#FF8001"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FA7D00"/></Style><Style ss:ID="s16" ss:Name="警告文本"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FF0000"/></Style><Style ss:ID="Default" ss:Name="Normal"><Alignment ss:Vertical="Center"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s31" ss:Name="好"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#006100"/><Interior ss:Color="#C6EFCE" ss:Pattern="Solid"/></Style><Style ss:ID="s6" ss:Name="40% - 强调文字颜色 3"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/></Style><Style ss:ID="s7" ss:Name="差"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#9C0006"/><Interior ss:Color="#FFC7CE" ss:Pattern="Solid"/></Style><Style ss:ID="s48" ss:Name="60% - 强调文字颜色 6"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#A9D08E" ss:Pattern="Solid"/></Style><Style ss:ID="s45" ss:Name="60% - 强调文字颜色 5"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#8EA9DB" ss:Pattern="Solid"/></Style><Style ss:ID="s41" ss:Name="20% - 强调文字颜色 4"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFF2CC" ss:Pattern="Solid"/></Style><Style ss:ID="s27" ss:Name="20% - 强调文字颜色 6"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#E2EFDA" ss:Pattern="Solid"/></Style><Style ss:ID="s2" ss:Name="20% - 强调文字颜色 3"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#EDEDED" ss:Pattern="Solid"/></Style><Style ss:ID="s35" ss:Name="20% - 强调文字颜色 1"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#DDEBF7" ss:Pattern="Solid"/></Style><Style ss:ID="s33" ss:Name="20% - 强调文字颜色 5"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#D9E1F2" ss:Pattern="Solid"/></Style><Style ss:ID="s9" ss:Name="60% - 强调文字颜色 3"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#C9C9C9" ss:Pattern="Solid"/></Style><Style ss:ID="s30" ss:Name="汇总"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#5B9BD5"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#5B9BD5"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" ss:Bold="1"/></Style><Style ss:ID="s13" ss:Name="注释"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#B2B2B2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#B2B2B2"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#B2B2B2"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#B2B2B2"/></Borders><Interior ss:Color="#FFFFCC" ss:Pattern="Solid"/></Style><Style ss:ID="s10" ss:Name="超链接"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#0000FF" ss:Underline="Single"/></Style><Style ss:ID="s44" ss:Name="40% - 强调文字颜色 5"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#B4C6E7" ss:Pattern="Solid"/></Style><Style ss:ID="s43" ss:Name="强调文字颜色 5"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#4472C4" ss:Pattern="Solid"/></Style><Style ss:ID="s14" ss:Name="60% - 强调文字颜色 2"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#F4B084" ss:Pattern="Solid"/></Style><Style ss:ID="s28" ss:Name="强调文字颜色 2"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#ED7D31" ss:Pattern="Solid"/></Style><Style ss:ID="s23" ss:Name="60% - 强调文字颜色 4"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#FFD966" ss:Pattern="Solid"/></Style><Style ss:ID="s21" ss:Name="60% - 强调文字颜色 1"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#9BC2E6" ss:Pattern="Solid"/></Style><Style ss:ID="s24" ss:Name="输出"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#3F3F3F"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#3F3F3F"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#3F3F3F"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#3F3F3F"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#3F3F3F" ss:Bold="1"/><Interior ss:Color="#F2F2F2" ss:Pattern="Solid"/></Style><Style ss:ID="s36" ss:Name="40% - 强调文字颜色 1"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#BDD7EE" ss:Pattern="Solid"/></Style><Style ss:ID="s34" ss:Name="强调文字颜色 1"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#5B9BD5" ss:Pattern="Solid"/></Style><Style ss:ID="s32" ss:Name="适中"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#9C6500"/><Interior ss:Color="#FFEB9C" ss:Pattern="Solid"/></Style><Style ss:ID="s47" ss:Name="40% - 强调文字颜色 6"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#C6E0B4" ss:Pattern="Solid"/></Style><Style ss:ID="s42" ss:Name="40% - 强调文字颜色 4"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFE699" ss:Pattern="Solid"/></Style><Style ss:ID="s40" ss:Name="强调文字颜色 4"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#FFC000" ss:Pattern="Solid"/></Style><Style ss:ID="s37" ss:Name="20% - 强调文字颜色 2"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FCE4D6" ss:Pattern="Solid"/></Style><Style ss:ID="s46" ss:Name="强调文字颜色 6"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#70AD47" ss:Pattern="Solid"/></Style><Style ss:ID="s39" ss:Name="强调文字颜色 3"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#A5A5A5" ss:Pattern="Solid"/></Style><Style ss:ID="s38" ss:Name="40% - 强调文字颜色 2"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#F8CBAD" ss:Pattern="Solid"/></Style><Style ss:ID="s49"/><Style ss:ID="s50"><Alignment ss:Vertical="Bottom"/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/><Interior/></Style><Style ss:ID="s51"><Alignment ss:Vertical="Bottom"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s52"><Alignment ss:Vertical="Bottom"/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/><Interior/><NumberFormat ss:Format="yyyy/mm/dd;@"/></Style></Styles><Worksheet ss:Name="Sheet1"><Table ss:ExpandedColumnCount="4" ss:ExpandedRowCount="32" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="48" ss:DefaultRowHeight="14"><Row><Cell ss:StyleID="s50"><Data ss:Type="String">日期</Data></Cell><Cell ss:StyleID="s51"><Data ss:Type="String">星期几</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">节假日0,1</Data></Cell><Cell ss:StyleID="s51"><Data ss:Type="String">工作日</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43466</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">2</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="Number">0</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=RC[-1]"><Data ss:Type="Number">0</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43467</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">3</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">1</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43468</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">4</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">2</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43469</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">5</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">3</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43470</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">6</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">0</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">3</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43471</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">7</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">0</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">3</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43472</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">4</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43473</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">2</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">5</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43474</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">3</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">6</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43475</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">4</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">7</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43476</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">5</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">8</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43477</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">6</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">0</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">8</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43478</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">7</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">0</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">8</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43479</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">9</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43480</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">2</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">10</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43481</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">3</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">11</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43482</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">4</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">12</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43483</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">5</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">13</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43484</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">6</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">0</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">13</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43485</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">7</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">0</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">13</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43486</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">14</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43487</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">2</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">15</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43488</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">3</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">16</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43489</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">4</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">17</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43490</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">5</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">18</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43491</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">6</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">0</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">18</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43492</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">7</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">0</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">18</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43493</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">19</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43494</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">2</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">20</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43495</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">3</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">21</Data></Cell></Row><Row><Cell ss:StyleID="s52"><Data ss:Type="Number">43496</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=WEEKDAY(RC[-1],2)"><Data ss:Type="Number">4</Data></Cell><Cell ss:StyleID="s50" ss:Formula="=IF(RC[-1]&gt;5,0,1)"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s51" ss:Formula="=R[-1]C+RC[-1]"><Data ss:Type="Number">22</Data></Cell></Row></Table><WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"><PageSetup><Header/><Footer/></PageSetup><Selected/><TopRowVisible>18</TopRowVisible><LeftColumnVisible>0</LeftColumnVisible><PageBreakZoom>100</PageBreakZoom><Panes><Pane><Number>3</Number><ActiveRow>0</ActiveRow><ActiveCol>0</ActiveCol><RangeSelection>R1C1:R32C4</RangeSelection></Pane></Panes><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</ProtectScenarios></WorksheetOptions></Worksheet></Workbook>