Any ideas how I can setup a formula in excel to create a 'last payment date' from a start date. I have eg customer making payments to a client on a lease agreement for 24 months, so need to set up recurring payments, all have differing direct debit payment dates
So far I have
Col a Col b Col c
Start date months last date
11/06/19 24 =edate(A1,b1) = answer 11/05/21
But is there a way without including column 'b'?
Hope Im making sense
TIA
-- Edited by Cheshire on Monday 29th of July 2019 01:31:25 PM
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
Actually that isnt going to work due to earlie mess ups!
1st date of payments for some have been late, so doubled up in first month, with date of first payment being eg 9 May, another on 15 May, D/D now set up for 15th monthly, so the formula above aint going to work.
Back to the drawing board!
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
As a matter of curiosity, why do you want to avoid putting the number of months in a separate cell? I would have thought that more useful, because the formula then has the flexibility of the number of months being variable rather than hard-coded.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
Just cos I don't like extra columns! Bonkers probably, but then I am.
In this case, all leases are 24 months.
Problem being in this case, they haven't set up a pile of payments when they should, so some clients paying twice in first month to catch up, hence the minus 1 in some cases for ease.
I'm hoping the whole thing will be redundant in a month or two when I've sorted it out and got it running automatically via the software and recurring invoicing set up to match everything.
-- Edited by Cheshire on Wednesday 31st of July 2019 08:28:28 AM
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
