Named Ranges

  • Thread starter Thread starter Brad
  • Start date Start date
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
 
One way:

Define StartDate as

=INDEX(DynaData,1)

and EndDate as

=INDEX(DynaDate, COUNTA(DynaDate))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro does not finish 17
SUMIF using date ranges & referencing account numbers 1
not your typical Pivot Table Named Range question 7
Last Day of the Latest Month Syntax problem 5
formula to count matching days between two date ranges (for largelist of names) 2
calculate total hours based on dates 5
need help connecting the code, Dave Help!!!! 2
Macro Stoped Working 2

Back
Top