Hi Mike

One way would be as follows.
I happened to use cell B12 to hold the value =TODAY()
Then in B13
=IF(--LEFT(TEXT(B12,"dd/mm/yy"),2)<16,DATE(YEAR(B12),MONTH(B12),16),DATE(YEAR (B12),MONTH(B12)+1,1))
and in cell B14
=IF(--LEFT(TEXT(B12,"dd/mm/yy"),2)=16,DATE(YEAR(B12),MONTH(B12)+1,16),DATE(Y EAR(B12),MONTH(B12)+1,1))

Use B13:B14 as your list range for the drop down.

You can substitute Today() for B12 in the formulae and bypass having
=TODAY() in cell B12, but I used the intermediate cell in order to test out
different dates before inserting =TODAY().

--
Regards
Roger Govier
"Mike R" wrote in message
...
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