On a monthly basis we keep track of interest expenses. We have a file with Settlement Date and Maturity date and need to calculate how many days interest will be paid for the given month. ExAMPLE- Calculate days of interest in May
Settle Date Maturity Date Number of Days In May
3/4/2016 5/05/2016 May 1-May 5 is 4 days
Is there a formula that can be used instead of manually counting days. Interest is calculated on a monthly basis. Thanks for your help in advance.
Bookmarks