Working withe dates within a date range in XL

  Stratis Telloglou 23:24 11 May 2017
Locked

I need to calculate the interest rates for a period of time I do have couple of years to calculate and thousands of entries, Please see the logic and let me know what function should I use to calculate dayes between a range.

A B C Interest Rate Period A Jan 1st to Feb 10 5% Period B Feb 11 to Feb 14th 8% etc etc

Payment 1> Obligation Paid Date : Jan 1st, Actual Paid Date : Feb 12

What I need to calcluate is the following for Payment 1 I have 31+10 days Overdue in Period A and 2 Days in Period 2.....

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Mi Mix 3 UK Review: Xiaomi's Flagship Slides Into The UK

Ken Sausage's illustrations for Powerade mash-up Where's Wally with Morph

Apple Maps vs Google Maps

Amazon Prime : prix, avantages et offres gratuites