Right now the title of the Valuation Box on the Control Panel worksheet reads: Valuation as of:
Question:
Right now the title of the Valuation Box on the Control Panel worksheet reads: "Valuation as of: 12/30/2023". It is hard coded (i.e. it won't update if we change the valuation date in cell C6 on the FCFF-Valuation worksheet. I would like to make it dynamic so that it reads as follows: "Valuation as of: March 30, 2022". If you change the valuation date in cell C6, the title of the Valuation Box should update automatically. Which of the following formulas would accomplish this task? Question 48 options: ="Valuation as of: " & 'FCFF-Valuation'!C6 =Valuation as of: & TEXT('FCFF-Valuation'!C6, "mmmm dd, yyy") ="Valuation as of: " & ('FCFF-Valuation'!C6, "mmm dd, yyy") ="Valuation as of: " &TEXT('FCFF-Valuation'!C6,"mmmm dd, yyy")
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill