Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculated Formula
I'd like to calculate a formula based on date values in
column A. My final formula should read something like this ='c:\02-05-04\[test.xls]sheet1'!b7 (02-05-04 is in cell a1) And it should link to a value referenced by the formula. Can this be done? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table, IF function, calculated item versus calculated field | Excel Discussion (Misc queries) | |||
I want to create a calculated item based on a calculated field | Excel Discussion (Misc queries) | |||
Problem with Calculated Items on Calculated Fields. | Excel Worksheet Functions | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) |