Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

How to calculate simple interest on a loan Simple interest is most commonly used for short-term loans – like payday loans, or some types of personal or auto loans.