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?

How about

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


--

HTH

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


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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_Da
ys,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?
>

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.

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)



(E-Mail Removed) wrote:
>
> 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?

--

Dave Peterson