I would like to create a General Caster formula to calculate the expected “Renewal Date” of a subscription based on a “Commencement Date” incremented by a specific number of years in the “Duration” Column. The results should be cast into a date column. I have compiled the following formula which does not seem to produce the desired results. Can anyone advise of where my error may be:
FORMAT_DATE(DATE(YEAR({item’s Completion Date})+({item’s Duration}),MONTH({item’s Completion Date}),DAY({item’s Completion Date})),“YYYY-MM-DD”)