Hello,
What formula reliably returns a date 2 months before the date in the "6 Month Renewal Reminder" date column? This is the last formula I tried, which I found in another article here in the Smartsheet Community.
=IF(MONTH([Date Column]@row) - [Number of months before]@row <= 0, DATE(YEAR([Date Column]@row) - 1, 12 + (MONTH([Date Column]@row) - [Number of months before]@row), DAY([Date Column]@row)), DATE(YEAR([Date Column]@row), MONTH([Date Column]@row) - [Number of months before]@row, DAY([Date Column]@row)))
Subtracting Days & Months from Specific Dates Using a Separate Day/Date Column. — Smartsheet Community
I would also like to know if I could use the same formula for adding months to the date in a column by changing the minus sign to a plus sign. The formula needs to be useful for dates within the same year and dates going into another year.
