Excel Date Chaging

[Aaronvlo]

Ok I print what we call lot code sheet for the week there all the same a the only thing that changes is the date for each day. The date we have placed in a cell close to the bottom of the page and the header footer won't work for what I need. so in one cell I have 10/18/2014 I want to be able to hit print 5 pages and the date change on each new page. I figure I will have to use macros but still in a beginner faze at this. I'm use office 365 pro plus.

 

any thoughts thanks