Need Help with IF and Switch Formula

Hello,
I am having issues with adding additional advertising week options to the formula below. This formula works well:
IF(AND({Advertising Plan}, {Live Date}),SWITCH( {Advertising Plan},"4 weeks", DATEADD({Live Date}, 27, 'days'),"52 weeks", DATEADD({Live Date}, 364, 'days')))
But as soon as I try to add additional week options (I have already added them to the Advertising Plan single select field), I get the 'formula not valid warning'. This is what I am putting in:
IF(AND({Advertising Plan}, {Live Date}),SWITCH({Advertising Plan},"2 weeks", DATEADD({Live Date}, 13, 'days'){Advertising Plan},"4 weeks", DATEADD({Live Date}, 27, 'days'),"8 weeks"({Live Date}, 27, 'days',"52 weeks", DATEADD({Live Date}, 364, 'days' )))
Please let me know where my formula is mucking me up, I feel I am going cross-eyed after looking at it for so long.
Thanks
P
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.