Formula Help; Start Date + Term = End Date
I need help with a formula to identify and End Date. Here are the three fields in play:
Start Date (Date)
Term (Text Multi Select)
End Date (Formula Date)
The Term represents months, n...
Forum Discussion
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?
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?
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
------------------------------
i.e. Start Date 1/1/20 + Term ( Let's say 12) = 1/1/21
------------------------------
Ryan Parr
------------------------------
- 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.
- Thanks, Austin!
------------------------------
Ryan Parr
------------------------------