av8tordude
04-09-2010, 12:37 PM
In cell B11 is a date. I would like label1 to display cell B11 (year only) and Expense Summary Report.
Example: cell B11: 4/11/2010
Label1 Display: 2010 Expense Report
Any suggestion is greatly appreciated.
Example: cell B11: 4/11/2010
Label1 Display: 2010 Expense Report
Any suggestion is greatly appreciated.