Does anyone know if excel is able to calculate interest earned? basically I
want it to look like the formula I have listed below

Dollar amt * APR / Days in a year * days in a month = Interest Earned