Loan Days Calculation

[Acekay]

Hi
Below is the table where i need the number of days to be calculated. Its basically loan days to be calculated. I have given the values manually but requesting all if anyone can give me common formula to put in cell to give me this value (counting of days).

			MONTH END	MONTH END	MONTH END	MONTH END	MONTH END	MONTH END	MONTH END	MONTH END
			31/07/2018	31/08/2018	30/9/2018	31/10/2018	30/11/2018	31/12/2018	31/01/2019	28/02/2019
Loan Date	Payment Date	Due Date
01/06/2018	25/06/2018	30/08/2018	0	0	0	0	0	0	0	0
18/06/2018	18/07/2018	16/09/2018	18	0	0	0	0	0	0	0
01/08/2018	13/09/2018	30/10/2018	0	30	13	0	0	0	0	0
01/08/2018	25/10/2018	30/10/2018	0	30	30	25	0	0	0	0
05/09/2018	22/11/2018	04/12/2018	0	0	25	31	22	0	0	0
08/10/2018	10/01/2019	06/01/2019	0	0	0	23	30	31	10	0
18/10/2018	25/02/2019	16/01/2019	0	0	0	13	30	31	31	25

<tbody>
</tbody>

Thanking you in advance.
****** id="cke_pastebin" style="position: absolute; top: 25px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

MONTH END

<tbody>
</tbody>

</body>

 

[footoo]

Enter in D2 and drag across and down :

=MAX(MIN(D$2,$B4)-MAX(EOMONTH(D$2,-1),$A4),0)

 

[Acekay]

Thanx a lot. Its working perfectly.

 

[Acekay]

Hi,
What if there is no payment date mention in the table? and want to calculate days till now ...eg under first raw if we change the data as;

			MONTH END	MONTH END	MONTH END	MONTH END	MONTH END	MONTH END	MONTH END	MONTH END
			31/07/2018	31/08/2018	30/9/2018	31/10/2018	30/11/2018	31/12/2018	31/01/2019	28/02/2019
Loan Date	Payment Date	Due Date
01/09/2018		30/11/2018	0	0	29	22	0	0	0	0
18/06/2018	18/07/2018	16/09/2018	18	0	0	0	0	0	0	0
01/08/2018	13/09/2018	30/10/2018	0	30	13	0	0	0	0	0
01/08/2018	25/10/2018	30/10/2018	0	30	30	25	0	0	0	0
05/09/2018	22/11/2018	04/12/2018	0	0	25	31	22	0	0	0
08/10/2018	10/01/2019	06/01/2019	0	0	0	23	30	31	10	0
18/10/2018	25/02/2019	16/01/2019	0	0	0	13	30	31	31	25

<tbody>
</tbody>

Thanx in advance.

 

[footoo]

=max(min(d$2,if($b4="",today(),$b4))-max(eomonth(d$2,-1),$a4),0)

 

[Acekay]

Thanx a lot. Its perfectly serving my requirement.