Calculating Contract Length Based on Number of Months

Marketing & Content Hub Reporting & Analytics
1

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:

  1. If a contract starts on January 1, 2025, and is a 15-month contract, the renewal date would be April 1, 2026.
  2. 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.

2

Hi @CDetlefsen,

This can be achieved with a calculation property: Create calculation and rollup properties

If you choose a date as output, it’s a matter of a simple calculation. Just make sure to pay attention to the disclaimer that HubSpot’s unit is milliseconds, so you’ll have to account for that in your equation.

Have a look, give it a try and let me know if / where you’re getting stuck.

Best regards!