Formula to populate Specific Start Date and End Date based upon Sprint #

I am looking for a formula to Set Specific Start Dates and End Dates based upon a Sprint Number Column Value.
Sprint #1
Update or Populate Start Date 8/2 and End Date 8/15
Change to Sprint #2
Update or Populate Start Date 8/16 and End Date 8/30
and so on