更新1:
急用 ~請給sample thx!
Aging Report formula
回答 (1)
2010-06-27 5:24 pm
✔ 最佳答案
A
B
C
D
E
F
1
A/R
0-30DAYS
31-60DAYS
61-90DAYS
OVER 90DAYS
DUE DATE
2
10,000
*
**
***
****
JAN 1, 11
3
*=IF((F2-NOW())>31,"",A2)
**=IF((F2-NOW())<=60,A2,"")
***=IF((F2-NOW())<=90,A2,"")
****=IF((F2-NOW())>90,A2,"")
參考: 月光光
收錄日期: 2021-04-19 22:33:20
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20100619000051KK00843