We are trying to calculate the duration of a contract based on its start date and a “Contract Length” field (number - (months)).
Is there a straightforward and accurate way to achieve this?
For example:
- If a contract starts on January 1, 2025, and is a 15-month contract, the renewal date would be April 1, 2026.
- If a contract starts on January 1, 2025, and is a 12-month contract, the renewal date would be January 1, 2026.
Any advice or suggestions would be greatly appreciated.