Calculating Days a Sale Is In Effect
You can use a formula to calculate the days a sale is in effect up to the date it is canceled, like a contract age. If there is no cancellation date, substitute today's date. Select Formula(Numeric) and enter the following formula:
ABS({custom_field_startdate}-nvl({custom_field_cxldate},{today}))
You can use a similar formula to calculate the days remaining on a contract based on the end date field.