tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
So I'm trying to work out how many payments are left on a loan?
I have a start Date in D4
End Date in F4
Number of months in B4
So all i want to do is look at the End date, and todays date and work out how many payments are left?
the dates are shown as DD/MM/YY so for example last Payment date = "26/12/21" so it should say i have 4 payments left, but 13/12/21 would be 3
please help if you can
Thanks
Tony
So I'm trying to work out how many payments are left on a loan?
I have a start Date in D4
End Date in F4
Number of months in B4
So all i want to do is look at the End date, and todays date and work out how many payments are left?
the dates are shown as DD/MM/YY so for example last Payment date = "26/12/21" so it should say i have 4 payments left, but 13/12/21 would be 3
please help if you can
Thanks
Tony