<![CDATA[
<P> </P>
<P><a href='javascript:fileFilterViewer("http://cfile276.uf.daum.net/attach/276FDD3F52DF6CFC2F4A2D", "/cfile276/27/6FDD3F52DF6CFC2F4A2D", "영업소 현장 정리.xlsx", "grpid%3D1GIVp%26fldid%3DNq2u%26dataid%3D541%26fileid%3D1%26regdt%3D20140122160403&url=http%3A%2F%2Fcfile276.uf.daum.net%2Fattach%2F276FDD3F52DF6CFC2F4A2D")'><img src="https://t1.daumcdn.net/daumtop_deco/icon/icon.hanmail.net/editor/p_xls_s.gif?rv=1.0.1" border="0" alt="첨부파일" class="vam"/> 영업소 현장 정리.xlsx</a></P>
<P>
<TABLE style="WIDTH: 787pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1047>
<COLGROUP>
<COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117>
<COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77>
<COL style="WIDTH: 97pt; mso-width-source: userset; mso-width-alt: 4717" span=2 width=129>
<COL style="WIDTH: 87pt; mso-width-source: userset; mso-width-alt: 4242" width=116>
<COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 4461" width=122>
<COL style="WIDTH: 94pt; mso-width-source: userset; mso-width-alt: 4571" width=125>
<COL style="WIDTH: 87pt; mso-width-source: userset; mso-width-alt: 4242" span=2 width=116>
<TBODY>
<TR style="HEIGHT: 37.5pt; mso-height-source: userset" height=50>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d9d9d9; WIDTH: 88pt; HEIGHT: 37.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=50 width=117><FONT color=#000000 size=2 face="맑은 고딕"><STRONG>공사시작</STRONG></FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; WIDTH: 58pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=77><FONT color=#000000 size=2 face="맑은 고딕"><STRONG>공사종료</STRONG></FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; WIDTH: 97pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=129><FONT color=#000000 size=2 face="맑은 고딕"><STRONG>총 공사기간</STRONG></FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; WIDTH: 97pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=129><FONT color=#000000 size=2 face="맑은 고딕"><STRONG>2014년 현재 연차</STRONG></FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; WIDTH: 87pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 width=116><FONT size=2><STRONG><FONT face="맑은 고딕"><FONT color=#000000><SPAN style="mso-spacerun: yes"> </SPAN>총공사금액<BR>(MKRW)</FONT><SPAN style="mso-spacerun: yes"><FONT color=#000000> </FONT></SPAN></FONT></STRONG></FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a6a6a6; WIDTH: 92pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=122><FONT color=#000000 size=2 face="맑은 고딕"><STRONG>순공사금액/건축비 (MKRW)</STRONG></FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: gray; WIDTH: 94pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 width=125><FONT size=2><FONT color=#ffffff><STRONG><FONT face="맑은 고딕"><SPAN style="mso-spacerun: yes"> </SPAN>Total HRP (KRW)<SPAN style="mso-spacerun: yes"> </SPAN></FONT></STRONG></FONT></FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: gray; WIDTH: 87pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=116><FONT size=2><FONT color=#ffffff><STRONG><FONT face="맑은 고딕"><SPAN style="mso-spacerun: yes"> </SPAN>2014 HRP (KRW)<SPAN style="mso-spacerun: yes"> </SPAN></FONT></STRONG></FONT></FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: black; WIDTH: 87pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70 width=116><STRONG><FONT color=#ffffff size=2 face="맑은 고딕">2014 SOW<BR>(KRW)</FONT></STRONG></TD></TR>
<TR style="HEIGHT: 18pt; mso-height-source: userset" height=24>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow; HEIGHT: 18pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl80 height=24><FONT color=#000000 size=2 face="맑은 고딕">2012-3-14</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl81><FONT color=#000000 size=2 face="맑은 고딕">2014-03-13</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl81><FONT color=#000000 size=2 face="맑은 고딕">2년</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75><FONT color=#000000 size=2 face="맑은 고딕">2년차</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76><FONT size=2><FONT color=#000000><FONT face="맑은 고딕"><SPAN style="mso-spacerun: yes"> </SPAN>150,000 </FONT></FONT></FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78><FONT color=#000000 size=2 face="맑은 고딕">64,500</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79><FONT color=#000000 size=2 face="맑은 고딕">154,800,000</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76><FONT size=2><FONT color=#000000><FONT face="맑은 고딕"><SPAN style="mso-spacerun: yes"> </SPAN>92,880,000 </FONT></FONT></FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79><FONT color=#000000 size=2 face="맑은 고딕">55,728,000</FONT></TD></TR>
<TR style="HEIGHT: 13.5pt" height=18>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl82 height=18><FONT color=#000000 size=2 face="맑은 고딕">2012-3</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl82><FONT color=#000000 size=2 face="맑은 고딕">2015-3</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72><FONT color=#000000 size=2 face="맑은 고딕">3년</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72><FONT color=#000000 size=2 face="맑은 고딕">2년차</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76><FONT size=2><FONT color=#000000><FONT face="맑은 고딕"><SPAN style="mso-spacerun: yes"> </SPAN>150,000 </FONT></FONT></FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78><FONT color=#000000 size=2 face="맑은 고딕">109,500</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79><FONT color=#000000 size=2 face="맑은 고딕">262,800,000</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl76><FONT size=2><FONT color=#000000><FONT face="맑은 고딕"><SPAN style="mso-spacerun: yes"> </SPAN>105,120,000 </FONT></FONT></FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl79><FONT color=#000000 size=2 face="맑은 고딕">42,048,000</FONT></TD></TR></TBODY></TABLE></P>
<P>첨부 파일의 O열과 P열은 INDEX,MATCH함수를 이용하여 계산식을 만들었는데. J열과K열을 자동으로 계산할 수 있는 함수식이 </P>
<P>무엇이 있을 까요? 조언 부탁드립니다.</P>
<!-- -->
]]>
카페 게시글
묻고 답하기
날짜 계산
언론인
추천 0
조회 84
14.01.22 16:04
댓글 2
다음검색
첫댓글 안녕하세요? [언론인]님...
[J4]셀에...
=CHOOSE(TYPE(I4),DATEDIF(H4,I4+1,"y")&"년",LEFT(I4,4)-LEFT(H4,4)&"년")
로 입력하고 아래로 드래그 해 보세요...
한가지 조언드리자면 H열과 I열의 데이터는 숫자속성, 문자속성 데이터가 혼재되어 있는데 한가지로 사용하시는게 좋습니다.
아울러 예제를 포함해서 질문하실땐 묻고답하기(파일첨부) 게시판을 이용해 주시면 제가 게시판 관리하기가 조금은 더 쉬울듯 합니다.
그럼 잘 해결되시길... ^^*
네 윤슬님 감사합니다. 근데 Choose 함수는... 잘 안됩니다. 많은 도움되었습니다.