应收帐款的帐龄分析

森林一族

头痛,请教如何设置公式？谢谢
要求1、计算所有客户信用期内货款金额和批次
2、计算超出信用期30天的货款金额和批次
3、计算超出信用期30~60天的货款金额和批次
如此类推计算60~90、90~150、150天~360天、360~720天、720天以上的货款金额和批次

[此贴子已经被作者于2006-5-25 23:44:54编辑过]

徒然客

见到表格才好说话

森林一族

<P>不好意思，怎么上传？</P>[em06] EyOUhcQr.rar (1.8 KB, 下载次数: 40)

2006-5-25 23:47 上传

点击文件名下载附件

[此贴子已经被作者于2006-5-25 23:47:27编辑过]

森林一族

<P>谁能帮我吗?谢谢先了</P>

renke21

<P>不知所云。</P>
<P>你的EXCLE这么“简明扼要”！给的信息太少了</P>
<P>怎么做的出来！！！？？</P>

森林一族

以下是引用[I]renke21[/I]在2006-5-31 13:02:32的发言：[BR]<P>不知所云。</P><P>你的EXCLE这么“简明扼要”！给的信息太少了</P><P>怎么做的出来！！！？？</P>

呵,重新上传一份,请指教.
Jkf4m0OF.rar (3.1 KB, 下载次数: 44)

2006-5-31 13:23 上传

点击文件名下载附件
应收帐款的帐龄分析

xieyidh

应改变表格的格式，不然发生的笔数多了，你会觉得很乱。

pigeons

<P>如果业务少还好说，要是多了就是会很乱的。</P>

anderlue

<P>你用的是什么财务软件啊，这种格式很麻烦，我是小菜，行不了</P>

zmb0627

<P>格式统一后，再透视表解决。ok</P>
<P>
<TABLE 216pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=288 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 54pt" span=4 width=72>

<TR 14.25pt" height=19>
<TD class=xl22 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" width=72 height=19><STRONG>客户名称</STRONG></TD>
<TD class=xl23 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=72><FONT size=2><STRONG>核定天数</STRONG></FONT></TD>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=72><STRONG>日期</STRONG></TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=72><STRONG>金额</STRONG></TD></TR>
<TR 15.75pt" height=21>
<TD class=xl28 windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>开平</TD>
<TD class=xl29 windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"><FONT size=2>　</FONT></TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="38828"><FONT face="Times New Roman">06-4-21</FONT></TD>
<TD class=xl27 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num><FONT face="Times New Roman">17700</FONT></TD></TR>
<TR 15.75pt" height=21>
<TD class=xl30 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>恩平元</TD>
<TD class=xl31 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num><FONT size=2>60</FONT></TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="38756"><FONT face="Times New Roman">06-2-8</FONT></TD>
<TD class=xl27 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num><FONT face="Times New Roman">36480</FONT></TD></TR></TABLE></P>
<TABLE 216pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=288 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 54pt" span=4 width=72>

<TR 15.75pt" height=21>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" width=72 height=21>韶关</TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=72 x:num><FONT size=2>30</FONT></TD>
<TD class=xl27 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=72 x:num="38793"><FONT face="Times New Roman" size=2>06-3-17</FONT></TD>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=72 x:num><FONT face="Times New Roman">2480</FONT></TD></TR>
<TR 15.75pt" height=21>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" height=21>乐昌</TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num><FONT size=2>30</FONT></TD>
<TD class=xl27 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="38808"><FONT face="Times New Roman" size=2>06-4-1</FONT></TD>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num><FONT face="Times New Roman">26750</FONT></TD></TR></TABLE>