I have a nifty little time sheet for 3 employees to use. Unfortunatly this
thing needs to be dummy proof because now I am responsible of making sure
they enter the right dates. All they need to do is enter every other weeks
start date.
For instance:
John's pay period starts on 12/4/05 (a sunday). All he has to do is type in
12/4/05 in one cell and the spreadsheet fills in the end date, the weekday
dates, etc..
He won't have to do it again until 2 weeks (12/18/05).
John can't seem to enter the right date and then payroll gets mad and they
yell at me...blah blah.
So I tried doing a data validation for a range of cells (I have all the
valid Sundays in a column on the same sheet). What am I doing wrong??
Is this even possible?