![]() |
|
#1
|
|||
|
|||
|
I have defined a few date named ranges (sub_1, sub_2,...) to be used in a formula to recalculate dates. How can I use a particular cell value, e.g. value of cell A1=1,in the formula based and construct the formula with correct sub? Formula, that does not do the job, would be something like '="sub_"&A1 +5' meaning the date calculated should be the date of sub_1 + 5 days thanx |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| accessing individual row data in named ranges | MimiCush | Excel | 25 | 09-27-2018 01:01 PM |
Named Ranges Help
|
SavGDK | Excel | 5 | 05-01-2017 09:41 AM |
Data Validation List based on Two Named Ranges
|
Rich18144 | Excel | 4 | 01-14-2016 04:37 AM |
| How to use named ranges in excel vba? | bosve73 | Excel Programming | 4 | 01-25-2012 09:26 AM |
| Dynamic Named Ranges using text | hannu | Excel | 0 | 06-22-2010 04:42 PM |