Dear all,

I have an issue for index the closest date's data(cash flow). There is
my table below,

A B
C D
1 Valuation Day 5/31/2007 Principal $
Interest $
2
3 Purchase 1/29/2007 (100000)
(3000)
4 Payment 1 2/20/2007 1500
500
5 Payment 2 3/25/2007 1625
526
6 Payment 3 4/21/2007 1738
610
7 Payment 4 5/26/2007 1866
690
8 Payment 5 6/15/2007 1945
750
9 Payment 6 7/23/2007 2053
840


I wish I can index the closest Principal and Interest amount by
changing my valuation day setting. For example, if valuation day is
5/31/2007, than my principal should be 1866(C7) and my interest should
be 690(D7). If I change my valuation day to 3/24/2007, then my
principal should be 1500(C4) and Interest should be 500(D4).

Has any could give me a favor, tell me how to get the formula by this
criteria?

Thanks a lot

Vincent
please email to: