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