what formula to use ?

[AhmetHa]

so I'm trying to achieve a formula which if it read S it adds one day from the raised date and if 1 adds 7 days if 2 adds 15 and so on ? what formula do I use?

so In H9 if G9=S+1 to F9 or if G9=1+7 to f9 and so on ?

[#2 · Accepted solution]

@AhmetHa 

For example

=F9+SWITCH(G9, "S", 1, 1, 7, 2, 15, 3, 31, 0)

Change 31 to the value you want to use if G9=3, and add more values as needed.

[#3]

awesome worked for me thank you I had to put parenthesise "" for the 1 that equals 7 and 2 that's equals 15 and os on.