Need help in Last Deduction Date calculation Formula

[Mohammad Younous]

Amount 1,25,000.00
Monthly Deduction 800.00
Deduction from Apr-2016


Result = When 1,25,000.00 fully Deduction or Which Month 1,25,000.00 fully deduction. Last deduction month name.

 

[vletm]

Mohammad Younous
Please, reread https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/
and after that do needed actions.
... after those test for cell D2 =EOMONTH(A2,ROUNDUP(B2/C2,0))