You can do this, but you will need to use indirect, which would also prevent the link to a closed workbook. i think your best bet would be to manualy change the date. if you have more that 10 or so, you could create a macro to automaticaly change the date for you.