Dropdown - option is picked it will return a date

ok,
All i need is say cell F8 to have a drop down box with the options plus 1, plus 2, plus 3
where when the option is picked it will return a date plus whatever.
I can already do a list linking to cells with the dates in but I don't want the drop down to show the actual dates, just whatever name i want.

Another option is seperate buttons within the sheet which will change cell F8 to any given value.

Thanks

It is unclear what you are asking.

You need to explain in more detail what you want and provide examples.

To create the drop down list... go to Data|Validation and select List from the Allow dropdown menu.

In the Source field enter the 3 choices separated by commas (do not put quotes around them).

e.g.

Date plus 1 day,Date plus 2 day,Date plus 3 day

Click oK.

Now say you put that drop down in B1 and your original date is in F1, then this formula in F8 should give you the result you want:

=MID(B1,11,1)+F1

Note: The 11 in this formula is the position your digit occurs in each option... if you alter the text in the options you gave you will have to change the number 11 to correspond to where in the text the digit is located.

Change also the cell references to match where your actual references are.