Payment Date Calculation Formula

[kgray28]

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?

 

[Peter_SSs]

I'm not sure I can help anyway, but I think that any potential helpers would appreciate knowing what the expected results are for that sample data and how you would get those results manually.