Monthly Activity
Posted: Mon Apr 19, 2010 8:12 pm
Hi, Im trying to make a monthly activity sheet. I attached a file to show the exact way how im trying to make it. I have to generate the dates for every month, and for example, if a month starts with a friday, then the first day to put the activity would be a friday. If you see the excel file you can understand better. Can somebody help me? thanks
Code: Select all
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 12">
<link rel=File-List href="activity_files/filelist.xml">
<style id="activity_12690_Styles">
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
.xl1512690
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl6312690
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl6412690
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
border:.5pt solid windowtext;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl6512690
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:bottom;
border:.5pt solid windowtext;
background:#538ED5;
mso-pattern:black none;
white-space:nowrap;}
-->
</style>
</head>
<body>
<!--[if !excel]> <![endif]-->
<!--The following information was generated by Microsoft Office Excel's Publish
as Web Page wizard.-->
<!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.-->
<!----------------------------->
<!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
<!----------------------------->
<div id="activity_12690" align=center x:publishsource="Excel">
<table border=0 cellpadding=0 cellspacing=0 width=2164 style='border-collapse:
collapse;table-layout:fixed;width:1623pt'>
<col width=116 style='mso-width-source:userset;mso-width-alt:4242;width:87pt'>
<col width=64 span=8 style='width:48pt'>
<col width=64 style='width:48pt'>
<col width=64 span=23 style='width:48pt'>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1512690 width=116 style='height:15.0pt;width:87pt'></td>
<td class=xl1512690 width=64 style='width:48pt'></td>
<td colspan=3 class=xl6512690 width=192 style='width:144pt'>1 WEEK</td>
<td colspan=7 class=xl6512690 width=448 style='border-left:none;width:336pt'>2
WEEK</td>
<td colspan=7 class=xl6512690 width=448 style='border-left:none;width:336pt'>3
WEEK</td>
<td colspan=7 class=xl6512690 width=448 style='border-left:none;width:336pt'>4
WEEK</td>
<td colspan=6 class=xl6512690 width=384 style='border-left:none;width:288pt'>5
WEEK</td>
<td class=xl1512690 width=64 style='width:48pt'></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6312690 style='height:15.0pt'>Full Name</td>
<td class=xl6312690 style='border-left:none'>Time</td>
<td class=xl6312690 style='border-top:none;border-left:none'>T</td>
<td class=xl6312690 style='border-top:none;border-left:none'>F</td>
<td class=xl6312690 style='border-top:none;border-left:none'>S</td>
<td class=xl6312690 style='border-top:none;border-left:none'>S</td>
<td class=xl6312690 style='border-top:none;border-left:none'>M</td>
<td class=xl6312690 style='border-top:none;border-left:none'>T</td>
<td class=xl6312690 style='border-top:none;border-left:none'>W</td>
<td class=xl6312690 style='border-top:none;border-left:none'>T</td>
<td class=xl6312690 style='border-top:none;border-left:none'>F</td>
<td class=xl6312690 style='border-top:none;border-left:none'>S</td>
<td class=xl6312690 style='border-top:none;border-left:none'>S</td>
<td class=xl6312690 style='border-top:none;border-left:none'>M</td>
<td class=xl6312690 style='border-top:none;border-left:none'>T</td>
<td class=xl6312690 style='border-top:none;border-left:none'>W</td>
<td class=xl6312690 style='border-top:none;border-left:none'>T</td>
<td class=xl6312690 style='border-top:none;border-left:none'>F</td>
<td class=xl6312690 style='border-top:none;border-left:none'>S</td>
<td class=xl6312690 style='border-top:none;border-left:none'>S</td>
<td class=xl6312690 style='border-top:none;border-left:none'>M</td>
<td class=xl6312690 style='border-top:none;border-left:none'>T</td>
<td class=xl6312690 style='border-top:none;border-left:none'>W</td>
<td class=xl6312690 style='border-top:none;border-left:none'>T</td>
<td class=xl6312690 style='border-top:none;border-left:none'>F</td>
<td class=xl6312690 style='border-top:none;border-left:none'>S</td>
<td class=xl6312690 style='border-top:none;border-left:none'>S</td>
<td class=xl6312690 style='border-top:none;border-left:none'>M</td>
<td class=xl6312690 style='border-top:none;border-left:none'>T</td>
<td class=xl6312690 style='border-top:none;border-left:none'>W</td>
<td class=xl6312690 style='border-top:none;border-left:none'>T</td>
<td class=xl6312690 style='border-top:none;border-left:none'>F</td>
<td class=xl1512690></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td rowspan=3 height=60 class=xl6412690 style='height:45.0pt;border-top:none'>FIRST
MEMBER</td>
<td class=xl6312690 style='border-top:none;border-left:none'>Mor</td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl1512690></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6312690 style='height:15.0pt;border-top:none;
border-left:none'>Aft</td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl1512690></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6312690 style='height:15.0pt;border-top:none;
border-left:none'>Eve</td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl1512690></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td rowspan=3 height=60 class=xl6412690 style='height:45.0pt;border-top:none'>SECOND
MEMBER</td>
<td class=xl6312690 style='border-top:none;border-left:none'>Mor</td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl1512690></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6312690 style='height:15.0pt;border-top:none;
border-left:none'>Aft</td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl1512690></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6312690 style='height:15.0pt;border-top:none;
border-left:none'>Eve</td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl6312690 style='border-top:none;border-left:none'> </td>
<td class=xl1512690></td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=116 style='width:87pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
</tr>
<![endif]>
</table>
</div>
<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>
</html>