Hi, how would i convert =INT(((364*A2-(DAYS(TODAY(),B2))))/30) to work in smartsheets

Anthony108171

Werner Gerstacker

@Anthony108171

How about this?

=INT((364 * A2 - (TODAY() - B2)) / 30)

Or you replace the column names with the headers of your table in the sheet as well as the formula, i.e.

=INT((364 * [Initial Years Warranty]@row - (TODAY() - [Warranty Start date]@row)) / 30)