HotNumbers
Well-known Member
- Joined
- Feb 14, 2005
- Messages
- 732
This is my current formula
=+'C:\BVPM\SHARE\FORECAST\Forecast Summary\FY07\[Forecast Change Summary 10-04-06.xls]07_Summary'!$M$6
I need to have the ability to change 10-04-06 using a cell reference point. for example 10-04-06 will change to 10-11-06, etc....
How can I change the formula to reference Cell A1 which will have the reference date.
=+'C:\BVPM\SHARE\FORECAST\Forecast Summary\FY07\[Forecast Change Summary 10-04-06.xls]07_Summary'!$M$6
I need to have the ability to change 10-04-06 using a cell reference point. for example 10-04-06 will change to 10-11-06, etc....
How can I change the formula to reference Cell A1 which will have the reference date.