I have 2 separate needs:

1. I would like to create a drop down list for choices of various dates
(beginning of pay periods). I can't figure out how to do this.

2. I would like to set something up so that if a specific date is chosen -
one of my fields on the timesheet will autopopulate with 8 hours for the
holiday that falls within that pay period.

If you chose 1-9-2005 - the 2 weeks of dates within that payperiod will be
calculated. I want the drop down to be I3 and when the date of 1/8/2005 is
chosen - 1/17/2005 (B22) - would have the Holiday cell (T22) autopopulated
with an 8. An automatic fill of that cell would be nice as well.