Forum Discussion
A lookup field within a line of text
You may replace all the Strings which contains the date or year info in them with the formulas and once it is set up, they will adopt the change in the year entered in cell A1.
e.g. you may enter the following formulas in the worksheet and they will reflect the year entered in cell A1.
="Cost of Goods - For Period "&TEXT(DATE($A$1,7,1),"yyyy-mm-dd")&" to "&TEXT(DATE($A$1,9,30),"yyyy-mm-dd")="Total COG's for the period "&TEXT(DATE($A$1,7,1),"yyyy-mm-dd")&" to "&TEXT(DATE($A$1,9,30),"yyyy-mm-dd")=$A$1&"-Q1 Reports"Similarly, you can construct other formulas.
You may replace all the Strings which contains the date or year info in them with the formulas and once it is set up, they will adopt the change in the year entered in cell A1.
e.g. you may enter the following formulas in the worksheet and they will reflect the year entered in cell A1.
="Cost of Goods - For Period "&TEXT(DATE($A$1,7,1),"yyyy-mm-dd")&" to "&TEXT(DATE($A$1,9,30),"yyyy-mm-dd")="Total COG's for the period "&TEXT(DATE($A$1,7,1),"yyyy-mm-dd")&" to "&TEXT(DATE($A$1,9,30),"yyyy-mm-dd")=$A$1&"-Q1 Reports"Similarly, you can construct other formulas.
Thank you so much....you are a champ. This works exactly as I had hoped and I've put it to use already. You, my friend, have saved me countless hours of future work and the accuracy of my specialized worksheets. Thanks again...I truly appreciate your reply.
Dale
You're welcome Dale_Rivers@! Glad it worked as desired.
Please take a minute to accept the post with the proposed answer as a Best Response to mark your question as Solved.
