Payment Date Calculation Formula

[kgray28]

[TABLE="width: 50"]
<tbody>[TR]
[TD]Payment start[/TD]
[TD]Payment End[/TD]
[TD]Frequency[/TD]
[TD]Paid Date[/TD]
[TD]Amount[/TD]
[TD][/TD]
[TD][/TD]
[TD]Current Period Payment Start[/TD]
[TD]Current Period payment end[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/07/16[/TD]
[TD]07/07/36[/TD]
[TD]3 Months[/TD]
[TD]FDOP[/TD]
[TD]250000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01/08/07[/TD]
[TD]13/03/20[/TD]
[TD]1 Month[/TD]
[TD]LDOP[/TD]
[TD]77978[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]01/12/15[/TD]
[TD]30/11/25[/TD]
[TD]12 Month[/TD]
[TD]FDOP[/TD]
[TD]200000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.