What I want to do is have a drop down list which allows the user to select from 1-26 Payperiods in the year. Now that I know how to do already using a drop down menu, no problem.

What I envison happening upon selecting the Payperiod is that another cell will populate with a designated Start date for that payperiod so that the calendar I have within the spreadsheet will refect the dates within that payperiod.

So for example if Payperiod 1 is selected from the dropdown I want the start date to populate as Jan 1, 2013
if Payperiod 2 is selected I want the start date to populate as Jan 15, 2013... and so on and so forth.

Can anyone assist me on how to do this?

*to be clear I dont need assitance with the calendar, I just want to know how to get the start date to auto populate based on data from the payperiod drop down list...Now Im pretty sure I would have to make another list which had the 26 start dates, but Im puzzled on how to connect the dots and get the data from the pay period list to populate the other cell which houses the start date.