Hello,

I have got a list of customer accounts in excel with the account opening
date listed.

I want to calculate the number of days interest I should charge each customer.

E.g. for February 2006;

If the account opened on 28th Feb then I would charge 1 days interest.

If the account opened on 1st Jan then I would charge 28 days interest for
February.

How can I calculate the number of days in a column?

Thank you in advance for your help,
Beth