Formula Help; Start Date + Term = End Date

Question

I need help with a formula to identify and End Date.&nbsp; Here are the three fields in play:&nbsp;

Start Date (Date)
Term (Text Multi Select)
End Date (Formula Date)

The Term represents months, not days. And it's a multi select because we want its values locked.&nbsp;------------------------------Ryan Parr------------------------------

austink · Answer

If the terms are always in months you can do this inside the End Date field:

AdjustMonth([Start Date], ToNumber([Term]))

This will be blank until there is a Date and a Term selected. The above is also with the assumption that your multiple choice field is only numbers in there. If it is numbers and text like "6 months" this will need a different solution.

austink · Answer

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?

ryanparr · Answer

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

ryanparr · Answer

Thanks, Austin!------------------------------Ryan Parr------------------------------

Forum Discussion

Formula Help; Start Date + Term = End Date

4 Replies

Related Content

Percent Formula Help

formula help

Year Formula help

API Button Help

The Admin Getting Started Hub