Payment start | Payment End | Frequency | Paid Date | Amount | Current Period Payment Start | Current Period payment end | |||
08/07/16 | 07/07/36 | 3 Months | FDOP | 250000 | |||||
01/08/07 | 13/03/20 | 1 Month | LDOP | 77978 | |||||
01/12/15 | 30/11/25 | 12 Month | FDOP | 200000 |
<tbody>
</tbody>
Hello
IF i have the above information, (3 months, means every 3 months, 12 months annually etc and FDOP = first day of period, LDOP = Last day of period) if there a formula that can show as at the end of Sept, what the current payment start date would be and current payment end date? So just every 3 months from 8th Jul 16 to now, what that date would be?