Calculate Future Due Date

[gbensonii]

I would greatly appreciate any suggestions to help solve the problem listed below which uses the table shown below:

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]
[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]TODAY IS:[/TD]
[TD="align: center"]11/06/2019[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]PAYEE[/TD]
[TD="align: center"]FIRST DUE DATE[/TD]
[TD="align: center"]AMOUNT[/TD]
[TD="align: center"]REPEATS[/TD]
[TD="align: center"]EVERY X[/TD]
[TD="align: center"]PERIODS[/TD]
[TD="align: center"]UNTIL[/TD]
[TD="align: center"]NEXT DUE DATE[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]Chase[/TD]
[TD="align: center"]11/01/2018[/TD]
[TD="align: center"]$ 5.00[/TD]
[TD="align: center"]Daily[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Day(s)[/TD]
[TD="align: center"]12/31/2019[/TD]
[TD="align: center"]
[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]Sears[/TD]
[TD="align: center"]11/15/2018[/TD]
[TD="align: center"]$10.00[/TD]
[TD="align: center"]Monthly[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Month(s)[/TD]
[TD="align: center"]12/31/2019[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What I am trying to do is have a formula to calculate what the next due date will be and place that value in date format in cell H4, H5. The values have to be equal to or beyond today (IE: >=B1)

I assume the formula will use the Logical IF function but beyond that I am stumped.

Thank-You in advance for any suggestions!

Sincerely,

George Benson

 

[Steve_R]

From the example date, I presume you simply need to find the next due date based on the number of months/days specified in Columns D & E
=IF(D3="Monthly",DATE(YEAR(B3),MONTH(B3)+E3,DAY(B3)),B3+E3)

What is not clear is what you want if the due date is before today. Hide it???

=IF(B3>TODAY(),"",IF(D3="Monthly",DATE(YEAR(B3),MONTH(B3)+E3,DAY(B3)),B3+E3))

Without knowing spreadsheet background and aims, it is sometimes hard to understand what people are trying to achieve from this end. If the formula doesn't work for you, please describe what you are trying to achieve with more detail.

By the way spelling matters. Daily is the default when it does not find 'Monthly' in column D. If 'Monthly' is misspelled or an abbreviate like 'mth' is entered, the formula assumes 'Daily'.