It shows items in the order they appear in the cells you reference (assume
you don't hard code them in the dialog).

If you don't want to show earlier dates, you can do this with a dynamic
defined name formula. (insert=Name=Define)

Name: List1
Refers to:
=Offset(Sheet1!$A$1,Match(Today(),Sheet1!$A$1:$A$3 66,0)-1,0,367-Match(Today(
),Sheet1!$A$1:$A$366,0),1)

Then in the data validation dialog, for source put in: =List1

(include the equal sign)

--
Regards,
Tom Ogilvy


"Hoshyar" wrote in message
...
I have a drop down list for the days of the year, form 1 jan 05 to 31 dec
05.
when I click on the drop down list, it always shows me 1 jan on the top of
the list, then I have to scrol down and look for "today" date. is there
any
possibility that when I click an empty cell where the drop down list is
activated and see the "today" date? I mean when use it today I want to see
the date 16 Oct 05 on the top of the list, and if I use it tomorrow I want
to
see 17 october 05 and so on.

Your help is appreciated.
Hoshyar