Quote:
Originally Posted by reznor9
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.
|
As long as your pay period selector drop down list populates a cell, you can easily use a VLOOKUP to populate the start date.
Let me know if you need help with this.
EDIT: See attachment. Is this what you mean?
If you're using Excel 2007 or later then the formula can be neatened up but I've done it this way just in case you're using an older version.
Similar Threads
Threaded Mode
