Payment Date Calculation Formula

kgray28

New Member
Joined
May 23, 2019
Messages
6
Payment startPayment EndFrequencyPaid DateAmountCurrent Period Payment StartCurrent Period payment end
08/07/1607/07/363 MonthsFDOP250000
01/08/0713/03/201 MonthLDOP77978
01/12/1530/11/2512 MonthFDOP200000

<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?
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,779
Office Version
365
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,100,143
Messages
5,472,756
Members
406,836
Latest member
deeMD

This Week's Hot Topics

Top