| 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculated Formula
Assuming the entry in A1 is a date perhaps:
Range("A2").Formula = "='c:\" & Format(Range("A1").Value, "m-d-yy") & "\[test.xls]sheet1'!b7" -- Jim Rech Excel MVP "Al" wrote in message ... | 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. |
| Reply |
| 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) | |||
Linear Mode
