changing data

[red95]

changing data

d4= ='H:\indy sales\[circulation.xlsx]Star'!$B$4
t2 is a data validation box of dates
example
12/26/2010
12/27/2011
12/27/2012
12/28/2013
12/29/2014
12/30/2015
12/30/2016
12/31/2017
1/1/2019
1/2/2020
1/2/2021
1/3/2022
1/4/2023
1/5/2024
1/5/2025
1/6/2026
1/7/2027
1/8/2028
1/8/2029
1/9/2030
1/10/2031
1/11/2032
1/11/2033
1/12/2034
1/13/2035


when t2= 12/26/2010 d4 would be 756 and when t2 is 1/2/2011 it should be 500 and d4 should be ='H:\indy sales\[circulation.xlsx]Star'!$j$4




how would i go about this


i am using win7 excel 2007

 

[Bieli]

Can you explain in other words what you want to do?

 

[red95]

d4 is a day with a number and t2 is that day when i change t2 to a day 7 days later i want that data stored in d4 for that day