I'm using Microsoft Excel 2010 and I am trying to create a title which will be updated every time the spreadsheet is opened. I want it to say "Forecast from (today's date) until end of 2013".
So far I have the following formula:
=CONCATENATE("Forecast From ",K10," until end of 2013")
In cell K10 I have used
=TODAY() so that every time the spreadsheet is opened, it will update that date to be current.
It is not working as I cannot get the ",K10," to be represented as a date within the concatenated string.
Any suggestions on how to fix this or possibly another method I could use to fix this?