CALCULATE FUTURE DATE

[FERG NATION]

I AM TRYING TO FIGURE OUT WHEN A CONTRACT WOULD EXPIRE, IT CHANGES EVERY TIME ... END DATE (JUST THE LAST DATE NOT ALL THE PAYMENTS IN BETWEEN)
SO I CAN EASILY FILL IT OUT ON DOCS VERSUS COUNTING ON MY CALENDAR

I WANT TO INPUT START DAT
I WANT TO ENTER NUMBER OF PAYMENTS
I WANT TO CHOOSE FREQUENCY, -- BI WEEKLY OR MONTHLY

FOR EXAMPLE 4/20/2022 .... MONTHLY .... 48 PAYMENTS = WHAT IS THE DATE THIS CONTRACT WOULD BE OVER

--FERG

 

[Joe4]

Welcome to the Board!

If you set up you sheet like this:

You can place this formula in cell D2:

=IF(C2="Monthly",EDATE(A2,B2),IF(C2="Bi-Weekly",A2+(B2*14),""))

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D
1
2	20/04/2022	Monthly	48	20/04/2026
3	20/04/2022	Bi weekly	10	07/09/2022
Lists

Cell Formulas
Range	Formula
D2:D3	D2	=IF(B2="Monthly",EDATE(A2,C2),A2+C2*14)

Ps, please do not post everyting in caps, as it is considered to be shouting.

 

[etaf]

Just FYI
All capitals is like shouting in forum world

=DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1))
Where A1 is the start date and B1 is number of months

for weeks
=A1+7*B1

Bi-Weeks
=A1+14*B1

then that can be combined in an IF based on the frequency

However, an example sample and expected results would help

Book3
	A	B	C	D
1		Start	Frequency	Type
2		4/1/22	4	Monthly
3
4		8/1/22
Sheet2

Cell Formulas
Range	Formula
B4	B4	=IF(D2="Bi-weekly", B2+14*C2, IF(D2="weekly", B2+7*C2, IF(D2="monthly",DATE(YEAR(B2),MONTH(B2)+C2,DAY(B2)),"")))

Note: Images are difficult to see , and also requires that I input all the data myself, which is very time consuming.

A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.

MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

You can also test to see if it works ok, in the "Test Here" forum.

Test Here

Use this forum to test your signature, learn bbcode, smilies, XL2BB, etc. Threads in this forum are automatically deleted after no replies for seven (7) days

www.mrexcel.com

OR if you cannot get XL2BB to work, or have restrictions on your PC , then put the sample spreadsheet onto a share
I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.

 

[FERG NATION]

I AM TRYING TO FIGURE OUT WHEN A CONTRACT WOULD EXPIRE, IT CHANGES EVERY TIME ... END DATE (JUST THE LAST DATE NOT ALL THE PAYMENTS IN BETWEEN)
SO I CAN EASILY FILL IT OUT ON DOCS VERSUS COUNTING ON MY CALENDAR

I WANT TO INPUT START DAT
I WANT TO ENTER NUMBER OF PAYMENTS
I WANT TO CHOOSE FREQUENCY, -- BI WEEKLY OR MONTHLY

FOR EXAMPLE 4/20/2022 .... MONTHLY .... 48 PAYMENTS = WHAT IS THE DATE THIS CONTRACT WOULD BE OVER

--FERG

Thank you everyone

Last question .... is there a way so it will count the start date as payment 1?

--ferg

 

[Joe4]

Thank you everyone

Last question .... is there a way so it will count the start date as payment 1?

--ferg

Just subtract one from the number of payments, i.e.

=IF(C2="Monthly",EDATE(A2,B2-1),IF(C2="Bi-Weekly",A2+((B2-1)*14),""))

(for my original structure/formula)