Excel to ad a number of weeks to an existing date

[caravanpark]

I'm helping a friend with a spread sheet for her caravan park, She wants to input the number of weeks someone wants to stay as an integer say 2 for 2 weeks after having already input a start date for their stay and have excel calculate and display an end date.


Start Date NUMBER OF WEEKS End Date
01/01/2015 2 14/01/2015 Example
28/01/2015 1 03/021/2014 Example

I have searched for this but due to the ambiguity of the search terms I'm going around in circles, sorry if someone has already posted similar.

Any help is greatly appreciated I'll donate a few bucks to www.strength.org.

Thanks Guys

 

[gaz_chops]

Try
=start date + (no of wks * 7)

 

[caravanpark]

Seems to do the job. How rusty am I !
Cheers Gaz

Since you are a Pom I'll donate a fiver to BBC Children in Need.

Thanks for helping out.

 

[gaz_chops]

LOL you're welcome, note though in your 1st post you said 14/1/15, this will give 15/1/15 which is 14 days after?