想知道如何運用excel公式來計算應收賬款屬於到期或過期款項 ?
例如 :以今天(10/July/07)來計算 :
Inv date Amount Terms Due Date
5/May/07 $200 30 days 4/Jun/07 $200 (over 30 days)
14/Jun/07 $300 30 days 14/July/07 $300(current period)
05/Apr/07 $200 30 days 5/May/07 $200(over 60 days)
如何運用excel公式來計算應收賬款屬於到期或過期款項?
2007-07-11 2:07 am
回答 (1)
2007-07-11 5:57 am
✔ 最佳答案
假設 Due Date 在 D 行E1=IF(TODAY()-D1 > 60 DAYS," OVER 60 DAYS " , IF(TODAY()-D1 > 30 DAYS , " OVER 30 DAYS " , " CURRENT PERIOD " ))
(公式往下拉)
2007-07-10 22:00:02 補充：
E1=IF(TODAY()-D1 > 60 ," OVER 60 DAYS " , IF(TODAY()-D1 > 30 , " OVER 30 DAYS " , " CURRENT PERIOD " ))
收錄日期: 2021-04-27 15:25:01
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070710000051KK03609