I have a dropdown list named “Expiry Period” with options as follow:-
- 2 weeks
- 1 week
- Other options might be added later on
Now I want to create a calculated column named “Expiry Date” which will calculate the expiry date based on the (modified date + the “Expiry Period” selection from the above list). For example if the user edit the page on 1 June 2019 , and the user select “Yearly” from the “Expiry Period” , then the “Expiry date” calculated column will be (1/June/2019 + 365 = 1/June/2020), while if the “Expiry Period” = Monthly then the “Expiry date” calculated column will be (1/June/2019 + 30 = 1/July/2019),and so on . But I am not sure if I can define such a formula inside calculated columns?