# Discussions

View Only

## Formula Help; Start Date + Term = End Date

• #### 1.  Formula Help; Start Date + Term = End Date

Posted 10 days ago
Edited by Ryan Parr 10 days ago
I need help with a formula to identify and End Date.  Here are the three fields in play:
1. Start Date (Date)
2. Term (Text Multi Select)
3. End Date (Formula Date)

The Term represents months, not days. And it's a multi select because we want its values locked.

------------------------------
Ryan Parr
------------------------------

• #### 2.  RE: Formula Help; Start Date + Term = End Date

Posted 10 days ago
Edited by Austin K 10 days ago
Your Term field is a Multi-Select field? As in multiple terms can be selected at one time inside the field? Or is it Multiple-Choice?

Is there any other logic that needs to be applied here or are you just looking to find out what the end date is 3, 6 and 12(or whatever) months after the start date?

• #### 3.  RE: Formula Help; Start Date + Term = End Date

Posted 10 days ago
Edited by Ryan Parr 10 days ago
Doh! It's a Text Multiple Choice field. No other logic is needed.

i.e. Start Date 1/1/20 + Term ( Let's say 12) = 1/1/21

------------------------------
Ryan Parr
------------------------------

• #### 4.  RE: Formula Help; Start Date + Term = End Date

Posted 10 days ago
Edited by Austin K 10 days ago
If the terms are always in months you can do this inside the End Date field: