엑셀-주간일정표 만들기

<TABLE style="WIDTH: 507pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=675 border=0 x:str> <COLGROUP> <COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 3384" width=119> <COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 3441" width=121> <COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 3356" width=118> <COL style="WIDTH: 144pt; mso-width-source: userset; mso-width-alt: 5461" width=192> <COL style="WIDTH: 94pt; mso-width-source: userset; mso-width-alt: 3555" width=125> <TBODY> <TR style="HEIGHT: 13.5pt" height=18> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; WIDTH: 89pt; BORDER-BOTTOM: #c0c0c0; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=119 height=18>시작일</TD> <TD class=xl29 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; WIDTH: 91pt; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right width=121 x:num="38888"><A name=RANGE!C2>6/20</A></TD> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; WIDTH: 89pt; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" width=118></TD> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; WIDTH: 144pt; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" width=192></TD> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; WIDTH: 94pt; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" width=125></TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18></TD> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"></TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18></TD> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"></TD></TR> <TR style="HEIGHT: 52.5pt; mso-height-source: userset" height=70> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; WIDTH: 507pt; BORDER-BOTTOM: #c0c0c0; HEIGHT: 52.5pt; BACKGROUND-COLOR: transparent" vAlign=top align=left width=675 colSpan=5 height=70><?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t54 coordsize="21600,21600" o:spt="54" adj="5400,18900" path="m0@29l@3@29qx@4@19l@4@10@5@10@5@19qy@6@29l@28@29@26@22@28@23@9@23@9@24qy@8,0l@1,0qx@0@24l@0@23,0@23,2700@22xem@4@19nfqy@3@20l@1@20qx@0@21@1@10l@4@10em@5@19nfqy@6@20l@8@20qx@9@21@8@10l@5@10em@0@21nfl@0@23em@9@21nfl@9@23e"><v:formulas><v:f eqn="val #0"></v:f><v:f eqn="sum @0 675 0"></v:f><v:f eqn="sum @1 675 0"></v:f><v:f eqn="sum @2 675 0"></v:f><v:f eqn="sum @3 675 0"></v:f><v:f eqn="sum width 0 @4"></v:f><v:f eqn="sum width 0 @3"></v:f><v:f eqn="sum width 0 @2"></v:f><v:f eqn="sum width 0 @1"></v:f><v:f eqn="sum width 0 @0"></v:f><v:f eqn="val #1"></v:f><v:f eqn="prod @10 1 4"></v:f><v:f eqn="prod @10 1 2"></v:f><v:f eqn="prod @10 3 4"></v:f><v:f eqn="prod height 3 4"></v:f><v:f eqn="prod height 1 2"></v:f><v:f eqn="prod height 1 4"></v:f><v:f eqn="prod height 3 2"></v:f><v:f eqn="prod height 2 3"></v:f><v:f eqn="sum @11 @14 0"></v:f><v:f eqn="sum @12 @15 0"></v:f><v:f eqn="sum @13 @16 0"></v:f><v:f eqn="sum @17 0 @20"></v:f><v:f eqn="sum height 0 @10"></v:f><v:f eqn="sum height 0 @19"></v:f><v:f eqn="prod width 1 2"></v:f><v:f eqn="sum width 0 2700"></v:f><v:f eqn="sum @25 0 2700"></v:f><v:f eqn="val width"></v:f><v:f eqn="val height"></v:f></v:formulas><v:path o:extrusionok="f" o:connecttype="custom" o:connectlocs="@25,0;2700,@22;@25,@10;@26,@22" o:connectangles="270,180,90,0" textboxrect="@0,0,@9,@10"></v:path><v:handles><v:h position="#0,topLeft" xrange="2700,8100"></v:h><v:h position="center,#1" yrange="14400,21600"></v:h></v:handles><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:complex v:ext="view"></o:complex></v:shapetype><v:shape id=_x0000_s1025 style="MARGIN-TOP: 8.25pt; Z-INDEX: 1; MARGIN-LEFT: 39.75pt; WIDTH: 411pt; POSITION: absolute; HEIGHT: 36.75pt; mso-wrap-style: tight" alt="" fillcolor="yellow [13]" strokecolor="windowText [64]" o:insetmode="auto" type="#_x0000_t54"><v:fill type="gradient" color2="#f60 [53]" focus="100%"></v:fill><v:shadow on="t" offset="6pt,6pt"></v:shadow><v:textbox> <DIV style="TEXT-ALIGN: center">週間日程表</DIV></v:textbox><?xml:namespace prefix = x ns = "urn:schemas-microsoft-com:office:excel" /><x:ClientData ObjectType="Shape"><x:TextHAlign>Center</x:TextHAlign> </x:ClientData></v:shape> <TABLE cellSpacing=0 cellPadding=0> <TBODY> <TR> <TD class=xl39 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; WIDTH: 507pt; BORDER-BOTTOM: #c0c0c0; HEIGHT: 52.5pt; BACKGROUND-COLOR: transparent" width=675 colSpan=5 height=70></TD></TR></TBODY></TABLE></TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD class=xl39 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" colSpan=5 height=18 x:fmla='="("&TEXT($B$1,"yyyy-m-d")&"~"&TEXT($B$1+6,"yyyy-m-d")&")"'>(2006-6-20~2006-6-26)</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19></TD> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"></TD> <TD style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent"></TD></TR> <TR style="HEIGHT: 15pt" height=20> <TD class=xl25 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BORDER-BOTTOM: #c0c0c0; HEIGHT: 15pt; BACKGROUND-COLOR: gray" height=20>날짜</TD> <TD class=xl26 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: gray">요일</TD> <TD class=xl26 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: gray">시간</TD> <TD class=xl27 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: gray">일정</TD> <TD class=xl28 style="BORDER-RIGHT: windowtext 1.5pt solid; BORDER-TOP: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: gray">비고</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl30 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; BORDER-BOTTOM: black 1.5pt solid; HEIGHT: 69pt; BACKGROUND-COLOR: transparent" height=92 rowSpan=5 x:num="38888" x:fmla="=$B$1">6/20</TD> <TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: transparent" rowSpan=5 x:num="38888" x:fmla="=A8">Tuesday</TD> <TD class=xl22 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD> <TD class=xl22 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD> <TD class=xl36 style="BORDER-RIGHT: windowtext 1.5pt solid; BORDER-TOP: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: transparent" rowSpan=5>　</TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>　</TD> <TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl30 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1.5pt solid; BORDER-BOTTOM: black 1.5pt solid; HEIGHT: 69pt; BACKGROUND-COLOR: transparent" height=92 rowSpan=5 x:num="38889" x:fmla="=A8+1">6/21</TD> <TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: transparent" rowSpan=5 x:num="38889" x:fmla="=A13">Wednesday</TD> <TD class=xl22 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD> <TD class=xl22 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD> <TD class=xl36 style="BORDER-RIGHT: windowtext 1.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: transparent" rowSpan=5>　</TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>　</TD> <TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 14.25pt" height=19> <TD class=xl30 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1.5pt solid; BORDER-BOTTOM: black 1.5pt solid; HEIGHT: 54.75pt; BACKGROUND-COLOR: transparent" height=73 rowSpan=5 x:num="38890" x:fmla="=A13+1">6/22</TD> <TD class=xl40 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: transparent" rowSpan=5 x:num="38890" x:fmla="=A18">Thursday</TD> <TD class=xl22 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD> <TD class=xl22 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD> <TD class=xl36 style="BORDER-RIGHT: windowtext 1.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: transparent" rowSpan=5>　</TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 13.5pt" height=18> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="DISPLAY: none; mso-height-source: userset; mso-height-alt: 285" height=0> <TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent">　</TD> <TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25> <TD class=xl30 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1.5pt solid; BORDER-BOTTOM: black 1.5pt solid; HEIGHT: 75.75pt; BACKGROUND-COLOR: transparent" height=101 rowSpan=5 x:num="38891" x:fmla="=A18+1">6/23</TD> <TD class=xl40 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: transparent" rowSpan=5 x:num="38891" x:fmla="=A23">Friday</TD> <TD class=xl22 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD> <TD class=xl22 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD> <TD class=xl36 style="BORDER-RIGHT: windowtext 1.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: transparent" rowSpan=5>　</TD></TR> <TR style="HEIGHT: 14.25pt; mso-height-source: userset" height=19> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 14.25pt; mso-height-source: userset" height=19> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 14.25pt; mso-height-source: userset" height=19> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 14.25pt; mso-height-source: userset" height=19> <TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>　</TD> <TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 14.25pt; mso-height-source: userset" height=19> <TD class=xl30 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1.5pt solid; FONT-WEIGHT: 700; BORDER-LEFT: windowtext 1.5pt solid; COLOR: blue; BORDER-BOTTOM: #c0c0c0 1.5pt; BACKGROUND-COLOR: transparent; mso-ignore: style" height=95 rowSpan=5 x:num="38892" x:fmla="=A23+1">6/24</TD> <TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1.5pt solid; FONT-WEIGHT: 700; BORDER-LEFT: windowtext 1pt solid; COLOR: blue; BORDER-BOTTOM: #c0c0c0 1.5pt; BACKGROUND-COLOR: transparent; mso-ignore: style" rowSpan=5 x:num="38892" x:fmla="=A28">Saturday</TD> <TD class=xl22 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD> <TD class=xl22 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD> <TD class=xl36 style="BORDER-RIGHT: windowtext 1.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: transparent" rowSpan=5>　</TD></TR> <TR style="HEIGHT: 14.25pt; mso-height-source: userset" height=19> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 14.25pt; mso-height-source: userset" height=19> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 14.25pt; mso-height-source: userset" height=19> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 14.25pt; mso-height-source: userset" height=19> <TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>　</TD> <TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27> <TD class=xl30 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1.5pt solid; FONT-WEIGHT: 700; BORDER-LEFT: windowtext 1.5pt solid; COLOR: red; BORDER-BOTTOM: #c0c0c0 1.5pt; BACKGROUND-COLOR: transparent; mso-ignore: style" height=135 rowSpan=5 x:num="38893" x:fmla="=A28+1">6/25</TD> <TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1.5pt solid; FONT-WEIGHT: 700; BORDER-LEFT: windowtext 1pt solid; COLOR: red; BORDER-BOTTOM: #c0c0c0 1.5pt; BACKGROUND-COLOR: transparent; mso-ignore: style" rowSpan=5 x:num="38893" x:fmla="=A33">Sunday</TD> <TD class=xl22 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD> <TD class=xl22 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD> <TD class=xl36 style="BORDER-RIGHT: windowtext 1.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: transparent" rowSpan=5>　</TD></TR> <TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent" height=27>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent" height=27>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent" height=27>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27> <TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent" height=27>　</TD> <TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27> <TD class=xl30 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1.5pt solid; BORDER-BOTTOM: black 1.5pt solid; HEIGHT: 101.25pt; BACKGROUND-COLOR: transparent" height=135 rowSpan=5 x:num="38894" x:fmla="=A33+1">6/26</TD> <TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: transparent" rowSpan=5 x:num="38894" x:fmla="=A38">Monday</TD> <TD class=xl22 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD> <TD class=xl22 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD> <TD class=xl36 style="BORDER-RIGHT: windowtext 1.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: transparent" rowSpan=5>　</TD></TR> <TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent" height=27>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent" height=27>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent" height=27>　</TD> <TD class=xl23 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR> <TR style="HEIGHT: 20.25pt; mso-height-source: userset" height=27> <TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent" height=27>　</TD> <TD class=xl24 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1.5pt solid; BACKGROUND-COLOR: transparent">　</TD></TR></TBODY></TABLE>   *  4~7=주간일정표(제목 입력) * 8=B-날짜-C-요일-D-시간-E-일정-F-비고(입력)...9~13 1. C2셀=날짜[06-06-19](입력)...이름상자▼[시작일](입력){Enter} 2. B6:F6(셀 병함)...[ ="("&text(시작일,"yyyy-m-d")&"~"&text(시작일+6,"yyyy-m-d")&")" ](입력){enter} 3. B9셀 {날짜}[ 시작일 ](입력)-Enter-[37969]표시됨 -마오-셀서식-표시형식-사용자정의(선택)-형식[ M/D ](입력)-[확인](누름) 4. B14셀[ =B9+1 ](입력)--나머지..아래로 채우기 핸들(드래그) 5. C9셀{요일}[ =B9 ](입력)-마오-셀서식-표시형식-사용자정의(선택)-형식[ DDDD ](입력)-[확인] {*DDD는 영문요일 3글자 표시...DDDD는 영문 요일 전체로 표시}-나머지 채우기 핸들(드래그) 6. B9:C43 {날자 첫줄~요일 마지막 간}(범위설정)-서식-조건부 서식= 조건1[수식▼][=WEEKDAY(B9)=1 ](입력)-서식(누름)-적색(선택)--조건2 [[수식▼][=WEEKDAY(B9)=7 ](입력)-서식(누름)-파랑색(선택)-[확인] {*WEEKDAY(날자) 함수는 지정한 날짜의 요일번호를 구하는 것으로 일요일이 1이다) 7. 인쇄영역은=B4:F43 까지 설정