This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I assumed there could be only two options. you can also use the SWITCH formula like thisSWITCH(
subscription,
'yearly',DATEADD(NOW(),1,'year'),
'monthly',DATEADD(NOW(),1,'month')
)