calculate fine with date format

[xymcrush17]

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 126"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]start date[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]due date[/TD]
[TD][/TD]
[TD]last payment date[/TD]
[TD]pinalty
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 126"]
<tbody>[TR]
[TD="class: xl69, width: 63"][/TD]
[TD="class: xl70, width: 63"][TABLE="width: 126"]
<tbody>[TR]
[TD="class: xl69, width: 63"]2015-02-04[/TD]
[TD="class: xl70, width: 63"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]2015-03-12[/TD]
[TD]11
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 126"]
<tbody>[TR]
[TD]2013-08-27[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]2013-08-27[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]2013-09-02[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]2013-11-07[/TD]
[TD]35
[/TD]
[/TR]
[TR]
[TD]2014-02-13[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]2014-03-05[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]2014-02-18[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]2014-03-14[/TD]
[TD]9
[/TD]
[/TR]
</tbody>[/TABLE]

how to calculate pinalty late day please?
:s

sorry my bad english

 

[xymcrush17]

help pls master

thanks in advance

 

[xymcrush17]

help me urgent pls

 

[muhammad susanto]

be patient cause it's free
(harap sabar, mas bro)

 

[jamookdang]

correct date?

 

[pjmorris]

hi xymcrush

Assuming that Start Date is in A1, Due Date in C1 and Last Payment Date in E1 then your penalty is given by: =MAX(E1-DATE(YEAR(A1),MONTH(A1)+1,C1),0)

Hope this helps.

Regards