Hi,

this is a very basic question but i cannot seem to find the answer i am looking for:

I have a daily report excel sheet that i need to print for each weekday for the upcoming 12 months and also the past 12 months. my question is this: Is there a way that excel can automatically change the date on each individual report for the time period? or do i have to manually change the date on every single report?

any feedback whatsoever would be greatly appreciated

thanks!