Thanks for the post back, I do appreciate it.
What I am trying to set up: the user selects a date from a drop down for
the begin date of the pay period, ie jan.1, 2005. then after the end of this
pay period (15th of the month) they would be able to select the next pay
period that begins on the 16th. I would like to have this available for each
subsequent pay period. Another way of putting it: To have a selection of
only two possible date, the first of each month and the 16th of each month,
that would progress through the year. Kind of rolling from one month to the
next. Kind of like a ()NOW function that would only show the first and the
16th. Hope this helps, and thank you again for the help!!

Mike R.
"Ron Rosenfeld" wrote:

On Sat, 19 Feb 2005 15:17:06 -0800, Mike R
wrote:

Thanks for the responses, got that part working. One other question. I
would like to put a drop down with only those two date options for input.
How do I do that so the date options within the dropdown automatically update
after each selection. I can enter all the dates in a list and do data
validation but was hoping there was something not so ugly!!

Thanks again

I'm not sure exactly what you want for valid dates to be allowed under what
circumstances. Examples might make it more clear to me.

However, you could certainly have a list with two dates, and have those dates
be calculated by formulas depending on the contents of H6. So each time you
made an entry into C6, the subsequent allowable entries, which are based on the
calculated value in H6, would change.



--ron