Creating a date box

[Philip290]

Hi, I'm trying to make a Excel sheet that will take data 'days' from one box, and add it to another..



for example:

Days on vacation: x
Date leave: October-20th-2011
Date return: above date + 'days on vacation' so if 7 was entered, it would return the date as October-27th-2011

Short/long form date doesn't matter. Also, how can I use the data on one sheet on another? I want a chart on the second sheet.

Thanks.