footers on charts with tomorrows date?

Hi all i have just started using excel and have been trying to update 2 footers on two different charts that i have to print every day i always forget to update them so was wondering how to write a macro that will do it all for me this is what i have so far

Prepared by Kevin Babb on &[Date]
Removal Date (NEED TO ADD TOMORROWS DATE HERE)
its written in the left footer box and needs to be on both charts
can anyone help thank you inadvance