text: SOLVED
  
  # what formula to use ?
  
  Copper Contributor
  
  # what formula to use ?
  
  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 Replies
  best response confirmed by AhmetHa (Copper Contributor)
  Solution
  
  # Re: what formula to use ?
  
  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.
  
  # Re: what formula to use ?
  
  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.
  1 best response
  
  Accepted Solutions
  best response confirmed by AhmetHa (Copper Contributor)
  Solution
  
  # Re: what formula to use ?
  
  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.
explanation: The document is a forum thread where a user asks for help with a formula in a spreadsheet. The user wants a formula that adds a specific number of days to a date based on the value in another cell. The thread includes a question, a solution provided by another user, and a confirmation from the original poster that the solution worked with a minor adjustment.
distilabel_metadata.content: Evaluate the user given text extract and determine if it contains a math question and optionally and answer to this question.
  
  Output rules:
  
  1. Briefly describe the document and mention if it contains a question or a question and answer.
  2. Finalize the output with: Label: no-question,question,question-and-answer,multiple-question,multiple-question-and-answer
distilabel_metadata.role: system
distilabel_metadata.content: SOLVED
  
  # what formula to use ?
  
  Copper Contributor
  
  # what formula to use ?
  
  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 Replies
  best response confirmed by AhmetHa (Copper Contributor)
  Solution
  
  # Re: what formula to use ?
  
  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.
  
  # Re: what formula to use ?
  
  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.
  1 best response
  
  Accepted Solutions
  best response confirmed by AhmetHa (Copper Contributor)
  Solution
  
  # Re: what formula to use ?
  
  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.
distilabel_metadata.role: user
distilabel_metadata.raw_output_q_a_detector_0: The document is a forum thread where a user asks for help with a formula in a spreadsheet. The user wants a formula that adds a specific number of days to a date based on the value in another cell. The thread includes a question, a solution provided by another user, and a confirmation from the original poster that the solution worked with a minor adjustment.
  
  Label: question-and-answer