I have 2 equations in name manager
=Trends!$A$3:INDEX(Trends!$A:$A,COUNT(Trends!$A:$A)+2)
column A is noting more than dates 1/1/24 to 8/14/24 and will grow
=Trends!$G$3:INDEX(Trends!$G:$G,COUNT(Trends!$G:$G)+2)
Column g is data points.
What i want to do is modify the equations to accept between dates
so if i put 2/1/24 in T3, i want the graph that references that name to update to start at 2/1/24
and if i put 5/1/24 in T4, i want the graph that references that name to update to end at 5/1/24
If the cells are blank, i just want all data that is in the date column.
thansk
=Trends!$A$3:INDEX(Trends!$A:$A,COUNT(Trends!$A:$A)+2)
column A is noting more than dates 1/1/24 to 8/14/24 and will grow
=Trends!$G$3:INDEX(Trends!$G:$G,COUNT(Trends!$G:$G)+2)
Column g is data points.
What i want to do is modify the equations to accept between dates
so if i put 2/1/24 in T3, i want the graph that references that name to update to start at 2/1/24
and if i put 5/1/24 in T4, i want the graph that references that name to update to end at 5/1/24
If the cells are blank, i just want all data that is in the date column.
thansk
