Quote Originally Posted by kvsrinivasamurthy View Post
In E2 then drag down.

=IF(D2<=C2,A2*0.75,IF(D2<=EDATE(B2,1),A2,A2*(1+(0.05*(MONTH(D2)-MONTH(B2)-IF(D2<=EDATE(B2,MONTH(D2)-MONTH(B2)),1,0))))))
This works unless the payment date is in another year. I love the logic in this formula, but I see it only considers the months of the dates. I tried something on my own, but couldn't quite figure it out.. Can you think of a way to overcome the year issue?