Start Date Column (plus 6 months) Renewal Date Column

Platform discussions
,
1

Looking to create the formula Start Date plus six month to populate Renewal Date Column.
would be a calendar 6 months and not reflective of business days, etc…
Example Start Date 1/1/24 = Renewal Date 7/1/24
what would be the formula ??

2

Hi Michelle,

Try

DATE(YEAR({Date}),SUM(MONTH({Date}),6),DAY({Date}))

If you want the date formatted YYYY-MM-DD:

FORMAT_DATE(DATE(YEAR({Date}),SUM(MONTH({Date}),6),DAY({Date})),"YYYY-MM-DD")

Want to get rid of the formula column? and write formulas that support multiple lines, variables and can update various columns at once? Take a look at the Advanced Formula Booster at https://mdboosters.com*