| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using a formula to create named range reference
Is it possible to use a formula to create a reference to a variable
named range? For example, I want a given cell to refer to a named range. However, the specific named range it would reference is dependent on today's date. I have named ranges for each weekday, i.e. Data2, Data3, Data4, Data5, Data6. In the cell which will reference these ranges, I want to create the reference to the range as "Data"+ WEEKDAY(TODAY()). I can't find any docs to describe how to accomplish this. TIA, Rose |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formula, noncontigous range | Excel Worksheet Functions | |||
| Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
| Identifying single column within named range | Excel Discussion (Misc queries) | |||
| use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
