Thread: Use of named ranges based on cell content
View Single Post
 
Old 02-24-2019, 07:13 AM
Intruder Intruder is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: Dec 2010
Posts: 59
Intruder is on a distinguished road
Default Use of named ranges based on cell content
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
Reply With Quote