Calculate Number Of Days After Deducting Certain Days and Cap at Certain Days.

[kywenyi]

Hi, i need help on a formula.
We have paid 15 days of interest upfront, hence the input in AT40 and AU40.
For 1st term interest, it is calculated at day 16 to day 90. AV40 should only start at day 16 and cap at 75 as 90 days minus 15 days is 75 days. Please help me with formula in AV40.

 

[jasonb75]

The dates shown cover a period of 91 days, not 90 as you say.

The correct result should be as simple as =AS40-AR40-AT40

 

[kywenyi]

AS date will only key in later on. AT will be fixed at 15 days so I will key in myself. AV should start only on the day 16th and stop at the day i key in AS.

Eg. AR is 14 Nov, AV will only start at 29 Nov showing 1. If I key in 30 Nov at AS, AT will show 15, AV will show 2.

 

[jasonb75]

That doesn't make any more sense than your original question, it doesn't help that you've posted an image with a lot of empty space top and bottom so we can't see your question and the data at the same time, we have to keep scrolling up and down trying to compare the 2 in order to make sense of anything.

Does =AS40-AR40-AT40-1 give you the results you want?