I am having trouble defining a range name that uses the offset function
to define a range from a specified starting date within a list of dates
to the last date in the list. The formula I am working with is as
follows:

=OFFSET(First_Date_In_List,MATCH(Starting_Date,Date_List,0)-1,0,Number_of_Days,1)

This formula defines the range from the specified starting date down
the specified number of days. I would rather not specify a number of
days but just define the range to include all subsequent dates. The
list is dynamic with new data added daily so the last date is always
increasing. In VB it would just be End(xlDown) but I cannot figure out
the syntax for a formula.

Anybody know?