Calculating a Due date with Different frequency

L

lallens

New Member
Joined
Nov 20, 2018
Messages
7
I need a formula that can tell me the next due date if I have the first due date, the frequency the payment is being paid (Monthly, Weekly, Semi-monthly) and the number of payments that are setup.

Column D is the first Payment date, Column E is the frequency, Column F is the number of payments, Column G is were I would put the next due date.

So if I have a person paying $xx amount first payment is due 11/1/2018 and they are paying weekly for 10 payments. Column G should give me a date of 11/22/2018 since it is greater than today date and still within the 10 payments.

Thanks in advance
Allen
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Sort by date Sort by votes
Can you post some sample data so we can look at a solution?
 
Upvote 0
I sure can and thanks for the assistance..

[TABLE="class: grid, width: 800, align: center"]
<tbody>[TR]
[TD]Account#[/TD]
[TD]Account#[/TD]
[TD]Pmt Amt[/TD]
[TD]Start Date[/TD]
[TD]Frequency[/TD]
[TD]# of Pmts[/TD]
[TD]Current Pmt Date[/TD]
[TD]Pmt plan ends[/TD]
[/TR]
[TR]
[TD]11555226[/TD]
[TD]4001111[/TD]
[TD]$125.00[/TD]
[TD]07/01/2018[/TD]
[TD]MON[/TD]
[TD]7[/TD]
[TD]<<What I need>>[/TD]
[TD]1/1/2019[/TD]
[/TR]
</tbody>[/TABLE]
PMT= payment(s)

So in theory what I should have in Column G (Current Pmt Date) should be 12/01/2018 since we have an arrangement that started on 7/1/2018 paying 7 payments. I can add a TODAY() somewhere if I need to.

Allen
 
Upvote 0
Excel 2016 (Windows) 32 bit
[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[TH][/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]C[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]D[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]E[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]H[/COLOR]​
[/TH]
[TH]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]I[/COLOR]​
[/TH]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]1[/COLOR]​
[/TD]
[TD]Account#[/TD]
[TD]Account#[/TD]
[TD]Pmt Amt[/TD]
[TD]Start Date[/TD]
[TD]Frequency[/TD]
[TD]# of Pmts[/TD]
[TD]Current Pmt Date[/TD]
[TD]Pmt plan ends[/TD]
[TD]long formula
without naamed ranges[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
07/01/2018​
[/TD]
[TD]S[/TD]
[TD][/TD]
[TD]
07/12/2018​
[/TD]
[TD]
01/01/2019​
[/TD]
[TD]
07/12/2018​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
08/01/2018​
[/TD]
[TD]M[/TD]
[TD][/TD]
[TD]
08/12/2018​
[/TD]
[TD]
02/01/2019​
[/TD]
[TD]
08/12/2018​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
09/01/2018​
[/TD]
[TD]W[/TD]
[TD][/TD]
[TD]
27/11/2018​
[/TD]
[TD]
03/01/2019​
[/TD]
[TD]
27/11/2018​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
10/01/2018​
[/TD]
[TD]W[/TD]
[TD][/TD]
[TD]Ended[/TD]
[TD]
30/05/2018​
[/TD]
[TD]Ended[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
11/01/2018​
[/TD]
[TD]S[/TD]
[TD][/TD]
[TD]
26/11/2018​
[/TD]
[TD]
05/01/2019​
[/TD]
[TD]
26/11/2018​
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: Sheet1[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Excel 2016 (Windows) 32 bit
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR]​
=IF(H2<today(),"ended",if(e2="w",weekly,if(e2="m",monthly,if(e2="s",semi,"freq?"))))< div=""></today(),"ended",if(e2="w",weekly,if(e2="m",monthly,if(e2="s",semi,"freq?"))))<>​

<tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​
[/TD]

</tbody>
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: Sheet1[/TD]
[/TR]
</tbody>[/TABLE]

Excel 2016 (Windows) 32 bit
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]I[/COLOR]​
=IF(H2<today(),"ended",if(e2="w",$d2+int((today()+7-$d2) 7)*7,if(e2="M" ,day($d2)+if(day($d2)<day(today()),eomonth(today(),0),eomonth(today(),-1)),if(e2="S" ,if(day($d2)+if(day($d2)<day(today()),eomonth(today(),0),eomonth(today(),-1))-today()="">15,DAY($D2)+IF(DAY($D2)<day(today()),eomonth(today(),0),eomonth(today(),-1))-15,day($d2)+if(day($d2)<day(today()),eomonth(today(),0),eomonth(today(),-1))),"freq?"))))< div=""></day(today()),eomonth(today(),0),eomonth(today(),-1))-15,day($d2)+if(day($d2)<day(today()),eomonth(today(),0),eomonth(today(),-1))),"freq?"))))<></today(),"ended",if(e2="w",$d2+int((today()+7-$d2)>​

<tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​
[/TD]

</tbody>
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: Sheet1[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Ignore that post! posting problems!!! :banghead::banghead::banghead:
 
Last edited:
Upvote 0
Hopefully this posting attempt works
(the problem was caused by forum security rejecting Less Than symbol and removing rest of formula - so I amended formula to use Greater Than instead):banghead::banghead::banghead:

In G2 copy down
=IF(TODAY()>H2,"Ended",IF(E2="W",'Sheet Name'!$D2+INT((TODAY()+7-'Sheet Name'!$D2)/7)*7,IF(E2="M",DAY('Sheet Name'!$D2)+EOMONTH(TODAY(),-(DAY('Sheet Name'!$D2)>=DAY(TODAY()))),IF(E2="S",DAY('Sheet Name'!$D2)+EOMONTH(TODAY(),-(DAY('Sheet Name'!$D2)>=DAY(TODAY())))-(DAY('Sheet Name'!$D2)+EOMONTH(TODAY(),-(DAY('Sheet Name'!$D2)>=DAY(TODAY())))-TODAY()>15)*15,"Freq?"))))

Results I get

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]
A​
[/th][th]
B​
[/th][th]
C​
[/th][th]
D​
[/th][th]
E​
[/th][th]
F​
[/th][th]
G​
[/th][th]
H​
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
1​
[/td][td]Account#[/td][td]Account#[/td][td]Pmt Amt[/td][td]Start Date[/td][td]
Frequency​
[/td][td]# of Pmts[/td][td]
Current Pmt Date​
[/td][td]
Pmt plan ends​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
2​
[/td][td][/td][td][/td][td][/td][td]
07/01/2018​
[/td][td]
M​
[/td][td][/td][td]
07/12/2018​
[/td][td]
01/01/2019​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
3​
[/td][td][/td][td][/td][td][/td][td]
08/01/2018​
[/td][td]
M​
[/td][td][/td][td]
08/12/2018​
[/td][td]
02/01/2019​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
4​
[/td][td][/td][td][/td][td][/td][td]
09/01/2018​
[/td][td]
M​
[/td][td][/td][td]
09/12/2018​
[/td][td]
03/01/2019​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
5​
[/td][td][/td][td][/td][td][/td][td]
10/01/2018​
[/td][td]
S​
[/td][td][/td][td]
Ended​
[/td][td]
30/05/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
6​
[/td][td][/td][td][/td][td][/td][td]
11/01/2018​
[/td][td=bgcolor:#FFFF00]
​
[/td][td][/td][td=bgcolor:#FFFF00]
Freq?​
[/td][td]
05/01/2019​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
7​
[/td][td][/td][td][/td][td][/td][td]
12/01/2018​
[/td][td]
S​
[/td][td][/td][td]
27/11/2018​
[/td][td]
06/01/2019​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
8​
[/td][td][/td][td][/td][td][/td][td]
13/01/2018​
[/td][td]
S​
[/td][td][/td][td]
28/11/2018​
[/td][td]
07/01/2019​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
9​
[/td][td][/td][td][/td][td][/td][td]
14/01/2018​
[/td][td]
W​
[/td][td][/td][td]
25/11/2018​
[/td][td]
08/01/2019​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
10​
[/td][td][/td][td][/td][td][/td][td]
15/01/2018​
[/td][td]
W​
[/td][td][/td][td]
26/11/2018​
[/td][td]
09/01/2019​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
11​
[/td][td][/td][td][/td][td][/td][td]
16/01/2018​
[/td][td]
S​
[/td][td][/td][td]
01/12/2018​
[/td][td]
10/01/2019​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
12​
[/td][td][/td][td][/td][td][/td][td]
17/01/2018​
[/td][td]
S​
[/td][td][/td][td]
02/12/2018​
[/td][td]
11/01/2019​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
13​
[/td][td][/td][td][/td][td][/td][td]
18/01/2018​
[/td][td]
S​
[/td][td][/td][td]
Ended​
[/td][td]
21/11/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
14​
[/td][td][/td][td][/td][td][/td][td]
19/01/2018​
[/td][td]
S​
[/td][td][/td][td]
Ended​
[/td][td]
22/11/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
15​
[/td][td][/td][td][/td][td][/td][td]
20/01/2018​
[/td][td]
S​
[/td][td][/td][td]
05/12/2018​
[/td][td]
23/11/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
16​
[/td][td][/td][td][/td][td][/td][td]
21/01/2018​
[/td][td]
S​
[/td][td][/td][td]
06/12/2018​
[/td][td]
24/11/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
17​
[/td][td][/td][td][/td][td][/td][td]
22/01/2018​
[/td][td]
S​
[/td][td][/td][td]
07/12/2018​
[/td][td]
25/11/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
18​
[/td][td][/td][td][/td][td][/td][td]
23/01/2018​
[/td][td]
S​
[/td][td][/td][td]
23/11/2018​
[/td][td]
26/11/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
19​
[/td][td][/td][td][/td][td][/td][td]
24/01/2018​
[/td][td]
S​
[/td][td][/td][td]
24/11/2018​
[/td][td]
27/11/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
20​
[/td][td][/td][td][/td][td][/td][td]
25/01/2018​
[/td][td]
S​
[/td][td][/td][td]
25/11/2018​
[/td][td]
28/11/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
21​
[/td][td][/td][td][/td][td][/td][td]
26/01/2018​
[/td][td]
M​
[/td][td][/td][td]
26/11/2018​
[/td][td]
29/11/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
22​
[/td][td][/td][td][/td][td][/td][td]
27/01/2018​
[/td][td]
M​
[/td][td][/td][td]
27/11/2018​
[/td][td]
30/11/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
23​
[/td][td][/td][td][/td][td][/td][td]
28/01/2018​
[/td][td]
M​
[/td][td][/td][td]
28/11/2018​
[/td][td]
01/12/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
24​
[/td][td][/td][td][/td][td][/td][td]
29/01/2018​
[/td][td]
S​
[/td][td][/td][td]
29/11/2018​
[/td][td]
02/12/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
25​
[/td][td][/td][td][/td][td][/td][td]
30/01/2018​
[/td][td]
S​
[/td][td][/td][td]
30/11/2018​
[/td][td]
03/12/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
26​
[/td][td][/td][td][/td][td][/td][td]
31/01/2018​
[/td][td]
S​
[/td][td][/td][td]
01/12/2018​
[/td][td]
04/12/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
27​
[/td][td][/td][td][/td][td][/td][td]
01/02/2018​
[/td][td]
W​
[/td][td][/td][td]
29/11/2018​
[/td][td]
05/12/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
28​
[/td][td][/td][td][/td][td][/td][td]
02/02/2018​
[/td][td]
W​
[/td][td][/td][td]
30/11/2018​
[/td][td]
06/12/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
29​
[/td][td][/td][td][/td][td][/td][td]
03/02/2018​
[/td][td]
W​
[/td][td][/td][td]
24/11/2018​
[/td][td]
07/12/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
30​
[/td][td][/td][td][/td][td][/td][td]
04/02/2018​
[/td][td]
S​
[/td][td][/td][td]
04/12/2018​
[/td][td]
08/12/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
31​
[/td][td][/td][td][/td][td][/td][td]
05/02/2018​
[/td][td]
S​
[/td][td][/td][td]
05/12/2018​
[/td][td]
09/12/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
32​
[/td][td][/td][td][/td][td][/td][td]
06/02/2018​
[/td][td]
S​
[/td][td][/td][td]
06/12/2018​
[/td][td]
10/12/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
33​
[/td][td][/td][td][/td][td][/td][td]
07/02/2018​
[/td][td]
S​
[/td][td][/td][td]
07/12/2018​
[/td][td]
11/12/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
34​
[/td][td][/td][td][/td][td][/td][td]
08/02/2018​
[/td][td]
M​
[/td][td][/td][td]
08/12/2018​
[/td][td]
12/12/2018​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
35​
[/td][td][/td][td][/td][td][/td][td]
09/02/2018​
[/td][td]
M​
[/td][td][/td][td]
09/12/2018​
[/td][td]
13/12/2018​
[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet Name[/td][/tr][/table]
 
Last edited:
Upvote 0
The above formula makes use of the Date of Last payment (and ignores No# of payments)
Results are based on today is 23 November 2018

There is a way to achieve this using 3 Named Ranges and the formula is then reduced to
=IF(TODAY()>H2,"Ended",IF(E2="W",Weekly,IF(E2="M",Monthly,IF(E2="S",Semi,"Freq?"))))

If the original formula gives you what you want, I will provide you with the formulas for the 3 Named ranges
- I will need to the name of the worksheet
 
Upvote 0
The sheet name is payments which will hold the formulas and the columns for the reps to fill out. I will lock the cells with the formulas so nothing happens (And of course keep a master copy just in case).
 
Upvote 0
Did the formula return what you wanted?
 
Upvote 0
I think there may be a problem with the weekly.. I have a payment date of 11/2/2018 Weekly Frequency and 3 payments it is showing me the next payment of 11/30/2018 when it should be 11/16/2018 or Ended
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question Question
Create cash flow from list of regular payments due
Replies
7
Views
152
HighAndWilder
H
J
  • Question Question
Calculation based on value in table based on date range
Replies
0
Views
286
jsand
J
C
  • Question Question
Calculate Payment Date - Excel or Power Query
Replies
2
Views
391
KRice
K
E
  • Question Question
Interest Due Log
Replies
7
Views
409
ExcelNew7
E
trishcollins
  • Question Question
Looking for formula/VBA to determine where to best put extra funds
Replies
1
Views
263
trishcollins
trishcollins

Forum statistics

Threads
1,224,823
Messages
6,181,175
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top