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