The Idea Dude
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 591
- Office Version
- 2016
- Platform
- Windows
Row 4, colC to ColJ
the have numbers in them ranging from .5 to 36 (they represent months).
The 15 rows benath row 4 contain dates in them.
How do i make it so that if a value in row 4 changes then the dates in the relevant column and in rows 5-19 adjust.
EG Row 4 ColD has 12 in it
ColD in row 5, 6, 7 and 8 respectively have the dates 12/12/05, 13/12/05, 24/12/05, 2/1/06.
If I change D4 to 24 then all the dates above would increase 12 months. ie 12/12/06, 13/12/06, 24/12/06, 2/1/07.
If i entered 3 in D4 then all dates above would decrease 8 months (or show 8 months earlier). ie 12/4/05, 13/4/05, 24/4/05, 2/5/05.
Thanks
the have numbers in them ranging from .5 to 36 (they represent months).
The 15 rows benath row 4 contain dates in them.
How do i make it so that if a value in row 4 changes then the dates in the relevant column and in rows 5-19 adjust.
EG Row 4 ColD has 12 in it
ColD in row 5, 6, 7 and 8 respectively have the dates 12/12/05, 13/12/05, 24/12/05, 2/1/06.
If I change D4 to 24 then all the dates above would increase 12 months. ie 12/12/06, 13/12/06, 24/12/06, 2/1/07.
If i entered 3 in D4 then all dates above would decrease 8 months (or show 8 months earlier). ie 12/4/05, 13/4/05, 24/4/05, 2/5/05.
Thanks