"heino" wrote:

calculate a daily interest charge for outstanding incoices with different
payment days

Tell us how you would solve this problem with pencil, paper, and calculator
if you did not have Excel. There are way too many variables that you have
not given us.

IMHO, this group is about how to use Excel, not how to run an AR operation.

YMMV with respect to other folks who supply answers here.

B+
HALinNY