Here is an example on how to display the result of your filters in a Calendar format.
Sheet1
<table style="padding-right: 2pt; padding-left: 2pt; font-size: 10pt; font-family: Arial,Arial; background-color: rgb(255, 255, 255);" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="font-weight: bold; width: 30px;"> <col style="width: 13px;"> <col style="width: 13px;"> <col style="width: 13px;"> <col style="width: 26px;"> <col style="width: 50px;"> <col style="width: 42px;"> <col style="width: 42px;"> <col style="width: 47px;"> <col style="width: 44px;"> <col style="width: 44px;"> <col style="width: 44px;"> <col style="width: 44px;"> <col style="width: 99px;"> <col style="width: 98px;"> <col style="width: 44px;"> <col style="width: 44px;"></colgroup> <tbody> <tr style="font-weight: bold; font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;"> <td>
</td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td> <td>G</td> <td>H</td> <td>I</td> <td>J</td> <td>K</td> <td>L</td> <td>M</td> <td>N</td> <td>O</td> <td>P</td></tr> <tr style="height: 17px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="text-align: center;">26-Feb</td> <td style="text-align: center;">
</td> <td>
</td> <td>
</td> <td>
</td> <td>Dynamic Calendar Dates Based on data</td> <td>
</td> <td>
</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>Date</td> <td>Item</td> <td>
</td> <td style="text-align: center;">Date</td> <td style="text-align: center;">Date</td> <td style="text-align: center;">Date</td> <td style="text-align: center;">Date</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td></tr> <tr style="height: 16px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td> <td style="font-size: 8pt;">
</td> <td style="font-size: 8pt;">
</td> <td style="font-size: 8pt;">
</td> <td style="font-size: 8pt;">
</td> <td style="font-size: 8pt; text-align: center;">28-Feb</td> <td style="font-size: 8pt; text-align: center;">a</td> <td style="font-size: 8pt;">
</td> <td style="font-size: 8pt; text-align: center;">26-Feb</td> <td style="font-size: 8pt; text-align: center;">27-Feb</td> <td style="font-size: 8pt; text-align: center;">28-Feb</td> <td style="font-size: 8pt; text-align: center;">1-Mar</td> <td style="font-size: 8pt;">
</td> <td style="font-size: 8pt; background-color: rgb(192, 192, 192); text-align: left;">26-Feb</td> <td style="font-size: 8pt; background-color: rgb(192, 192, 192); text-align: left;">27-Feb</td> <td style="font-size: 8pt;">
</td> <td style="font-size: 8pt;">
</td></tr> <tr style="height: 17px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">26-Feb</td> <td style="font-size: 8pt; text-align: center;">b</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="text-align: left;">b</td> <td style="text-align: left;">3</td> <td>
</td> <td>
</td></tr> <tr style="height: 17px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">26-Feb</td> <td style="font-size: 8pt; text-align: center;">c</td> <td>
</td> <td>Item</td> <td>Item</td> <td>Item</td> <td>Item</td> <td>
</td> <td style="text-align: left;">c</td> <td style="text-align: left;">4</td> <td>
</td> <td>
</td></tr> <tr style="height: 17px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">6</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">1-Mar</td> <td style="font-size: 8pt; text-align: center;">d</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">b</td> <td style="font-size: 8pt; text-align: center;">3</td> <td style="font-size: 8pt; text-align: center;">a</td> <td style="font-size: 8pt; text-align: center;">d</td> <td>
</td> <td style="text-align: left;">fe</td> <td style="text-align: left;">
</td> <td>
</td> <td>
</td></tr> <tr style="height: 17px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">7</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">26-Feb</td> <td style="font-size: 8pt; text-align: center;">fe</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">c</td> <td style="font-size: 8pt; text-align: center;">4</td> <td style="font-size: 8pt; text-align: center;">1</td> <td>
</td> <td>
</td> <td style="text-align: left;">g</td> <td style="text-align: left;">
</td> <td>
</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">8</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">26-Feb</td> <td style="font-size: 8pt; text-align: center;">g</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">fe</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">2</td> <td>
</td> <td>
</td> <td style="text-align: left;">t</td> <td style="text-align: left;">
</td> <td>
</td> <td>
</td></tr> <tr style="height: 17px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">9</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">26-Feb</td> <td style="font-size: 8pt; text-align: center;">t</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">g</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">6</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td></tr> <tr style="height: 17px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">10</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">28-Feb</td> <td style="font-size: 8pt; text-align: center;">1</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">t</td> <td>
</td> <td style="font-size: 8pt;">
</td> <td>
</td> <td>
</td> <td>For Fixed Dates on your Calendar</td> <td>
</td> <td>
</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">11</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">27-Feb</td> <td style="font-size: 8pt; text-align: center;">3</td> <td>
</td> <td style="font-size: 8pt;">
</td> <td>
</td> <td style="font-size: 8pt;">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">12</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">28-Feb</td> <td style="font-size: 8pt; text-align: center;">2</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="font-size: 8pt; background-color: rgb(192, 192, 192); text-align: left;">28-Feb</td> <td style="font-size: 8pt; background-color: rgb(192, 192, 192); text-align: left;">1-Mar</td> <td>
</td> <td>
</td></tr> <tr style="height: 17px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">13</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">27-Feb</td> <td style="font-size: 8pt; text-align: center;">4</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="text-align: left;">a</td> <td style="text-align: left;">d</td> <td>
</td> <td>
</td></tr> <tr style="height: 17px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">14</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="font-size: 8pt; text-align: center;">28-Feb</td> <td style="font-size: 8pt; text-align: center;">6</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="text-align: left;">1</td> <td style="text-align: left;">
</td> <td>
</td> <td>
</td></tr> <tr style="height: 17px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">15</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="text-align: left;">2</td> <td style="text-align: left;">
</td> <td>
</td> <td>
</td></tr> <tr style="height: 17px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">16</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="text-align: left;">6</td> <td style="text-align: left;">
</td> <td>
</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">17</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td style="text-align: left;">
</td> <td style="text-align: left;">
</td> <td>
</td> <td>
</td></tr> <tr style="height: 17px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">18</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td></tr> <tr style="height: 17px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">19</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>Zero values are unchecked in options</td> <td>
</td> <td>
</td> <td>
</td></tr> <tr style="height: 17px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">20</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td></tr></tbody></table>
<table style="font-size: 10pt; border-color: rgb(0, 255, 0); color: rgb(0, 0, 0); border-style: groove; font-family: Arial; background-color: rgb(255, 252, 249);"> <tbody> <tr> <td>
Spreadsheet Formulas</td></tr> <tr> <td> <table style="font-size: 9pt; font-family: Arial;" border="1" cellpadding="2" cellspacing="0"> <tbody> <tr style="font-size: 10pt; background-color: rgb(202, 202, 202);"> <td>Cell</td> <td>Formula</td></tr> <tr> <td>H1</td> <td>=MIN(E3:E14)</td></tr> <tr> <td>H3</td> <td>=H1+$I$1</td></tr> <tr> <td>I3</td> <td>=H3+1</td></tr> <tr> <td>J3</td> <td>=I3+1</td></tr> <tr> <td>K3</td> <td>=J3+1</td></tr> <tr> <td>M3</td> <td>=H3</td></tr> <tr> <td>N3</td> <td>=I3</td></tr> <tr> <td>M4</td> <td>=H6</td></tr> <tr> <td>N4</td> <td>=I6</td></tr> <tr> <td>M5</td> <td>=H7</td></tr> <tr> <td>N5</td> <td>=I7</td></tr> <tr> <td>M6</td> <td>=H8</td></tr> <tr> <td>N6</td> <td>=I8</td></tr> <tr> <td>M7</td> <td>=H9</td></tr> <tr> <td>N7</td> <td>=I9</td></tr> <tr> <td>M8</td> <td>=H10</td></tr> <tr> <td>N8</td> <td>=I10</td></tr> <tr> <td>M13</td> <td>=IF(ISERROR
(HLOOKUP(M$12,$H$3:$K$14,ROW(A4),FALSE)),"",HLOOKUP
(M$12,$H$3:$K$14,ROW(A4),FALSE))</td></tr> <tr> <td>N13</td> <td>=IF(ISERROR
(HLOOKUP(N$12,$H$3:$K$14,ROW(B4),FALSE)),"",HLOOKUP
(N$12,$H$3:$K$14,ROW(B4),FALSE))</td></tr> <tr> <td>M14</td> <td>=IF(ISERROR
(HLOOKUP(M$12,$H$3:$K$14,ROW(A5),FALSE)),"",HLOOKUP
(M$12,$H$3:$K$14,ROW(A5),FALSE))</td></tr> <tr> <td>N14</td> <td>=IF(ISERROR
(HLOOKUP(N$12,$H$3:$K$14,ROW(B5),FALSE)),"",HLOOKUP
(N$12,$H$3:$K$14,ROW(B5),FALSE))</td></tr> <tr> <td>M15</td> <td>=IF(ISERROR
(HLOOKUP(M$12,$H$3:$K$14,ROW(A6),FALSE)),"",HLOOKUP
(M$12,$H$3:$K$14,ROW(A6),FALSE))</td></tr> <tr> <td>N15</td> <td>=IF(ISERROR
(HLOOKUP(N$12,$H$3:$K$14,ROW(B6),FALSE)),"",HLOOKUP
(N$12,$H$3:$K$14,ROW(B6),FALSE))</td></tr> <tr> <td>M16</td> <td>=IF(ISERROR
(HLOOKUP(M$12,$H$3:$K$14,ROW(A7),FALSE)),"",HLOOKUP
(M$12,$H$3:$K$14,ROW(A7),FALSE))</td></tr> <tr> <td>N16</td> <td>=IF(ISERROR
(HLOOKUP(N$12,$H$3:$K$14,ROW(B7),FALSE)),"",HLOOKUP
(N$12,$H$3:$K$14,ROW(B7),FALSE))</td></tr> <tr> <td>M17</td> <td>=IF(ISERROR
(HLOOKUP(M$12,$H$3:$K$14,ROW(A8),FALSE)),"",HLOOKUP
(M$12,$H$3:$K$14,ROW(A8),FALSE))</td></tr> <tr> <td>N17</td> <td>=IF(ISERROR
(HLOOKUP(N$12,$H$3:$K$14,ROW(B8),FALSE)),"",HLOOKUP
(N$12,$H$3:$K$14,ROW(B8),FALSE))</td></tr></tbody></table></td></tr></tbody></table>
Excel tables to the web >> Excel Jeanie HTML 4