| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to use date in file name link reference
I am stuck with this one and was hoping someone could help. I am
trying to figure out a formula that uses the date from a cell in the file reference. D2 contains: 02/01/09 (date format) D7 contains the current formula:=SUM('G:\PATH HERE\Poker\[020109.xls] POKER'!$H$16:$H$21) I want the date portion of the formula "020109" to be replaced with the date in D2. Each column has a different date. Any help anyone can provide is greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove the file link from the formula? | Excel Worksheet Functions | |||
| How to link an Excel file due date to Outlook calendar date? | New Users to Excel | |||
| Add reference to DDE Link formula | Excel Worksheet Functions | |||
| formula link to a file | Excel Worksheet Functions | |||
| Q: Can a formula reference a cell to get the file name to link to for data? | Excel Discussion (Misc queries) | |||
![DFruge[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
