Converting "sprint number" to a specific date

[Jacobs87]

I am currently working on a planning sheet that uses "sprints" instead of weeks or dates. However, for presentation purposes I do need to show the date in which a particular sprint is in.
A sprint consists of a two-week period. E.g.: sprint number 40 starts on wednesday the 6th (6-6-2018) and ends on (19-6-2018).
Does anyone know an efficient formula for calculating the start date based on the sprint number?

My Excel looks the following:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sprint[/TD]
[TD]Date start[/TD]
[TD]Date end[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD]6-6[/TD]
[TD]19-6[/TD]
[/TR]
[TR]
[TD]41[/TD]
[TD]20-6[/TD]
[TD]3-7[/TD]
[/TR]
</tbody>[/TABLE]

 

[magpie2000k]

I couldnt find anything but just drag formulas down
Start date is previous end date +1 and end date is start date +13

Or am i missing something

 

[Jacobs87]

Sorry, I wasn't specific enough. Your method would work, if the sprints I mentioned are followed up by each other.

It could be that row 3 would be sprint 44, row 4 could be sprint 30 (depending on the task - which I did not mention as a column in my post).

 

[magpie2000k]

Yes but you could create a table of dats from sprint codes then use vlookup or similar to pull in the start date based on the sprint code in colum a as above..