Named Ranges

B

Brad

I defined a range of dates in a column as "DynaDate" so that a chart could
expand and contract with different beginning and ending dates and their
accompanying data.

Is there a way to define the first date within this ever-changing named
range, DynaDate, as StartDate and the ending date as EndDate?

My thanks in advance for any help here.

Brad
 
J

JE McGimpsey

One way:

Define StartDate as

=INDEX(DynaData,1)

and EndDate as

=INDEX(DynaDate, COUNTA(DynaDate))
 
Top