Define a dynamic range from a specific starting point in a list

[gwh_lbh]

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?

 

[Bob Phillips]

How about

=OFFSET(First_Date_In_List,,,COUNTA(Date_List),1)


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[gwh_lbh]

I believe that simply returns all items in the list. I'm looking to
return only those items subsequent to the specified starting date which
is not the first date in the list.

 

[Dave Peterson]

How about:

=OFFSET(First_Date_In_List,MATCH(starting_date,date_list,0)-1,0,
COUNTA(date_list)-MATCH(starting_date,date_list,0)+1,1)