One way:

In a second sheet, enter

A1: =TODAY()
A2: =A1 + 1

Format A2 as a date, and copy down to A366. Choose Insert/Name/Define
and enter

Name in workbook: DateList
Refers To:
=OFFSET(Sheet2!$A$1,0,0,365+(DAY(Sheet2!$A$1)<DAY (Sheet2!$A$366)),1)

Then in your validation cell, use

Allow: List
Source: =DateList


In article ,
"Jan Buckley" wrote:

I have a drop-down list (Data/Validation) that contains dates from the
beginning of the fiscal year (10-01-2004) to the end of the fiscal year
(09-30-2005). Is there a way to have the drop down start at the current date
instead at the beginning on October 01? Thanks.