<![CDATA[
<P> </P>
<P>
<TABLE style="BORDER-COLLAPSE: collapse" cellSpacing=1 cellPadding=1 width=600 bgColor=#f6f9de>
<TBODY>
<TR>
<TD style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="33%"> 대여일 </TD>
<TD style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="33%"> 반납일</TD>
<TD style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="33%"> 대여일과 반납일 기간</TD></TR>
<TR>
<TD style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="33%"> 2009-04-10</TD>
<TD style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="33%"> 2009-05-20</TD>
<TD style="BORDER-RIGHT: #dadada 1px solid; BORDER-TOP: #dadada 1px solid; BORDER-LEFT: #dadada 1px solid; BORDER-BOTTOM: #dadada 1px solid" width="33%"> =datedif(반납일셀,대여일셀,"d")</TD></TR></TBODY></TABLE></P>
<P> </P>
<P>결과값으로 대여일과 반납일과의 차이가 약 40일정도 나는데 40 이라는 결과값을 얻으려고 하는데</P>
<P> </P>
<P>datedif(반납일,대여일,"d") </P>
<P> </P>
<P>이렇게 했는데 #NUM! 오류가 뜨네요</P>
<P> </P>
<P>뭐가 잘못된거죠?</P>
<P> </P>
<!-- -->
]]>
첫댓글 =datedif(대여일셀주소,반납입셀주소,"d")
d가아니라 md아닌가요?^^;;