View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SSADA SSADA is offline
external usenet poster
 
Posts: 3
Default Printing Dates on One Sheet

I have one template that i print for our production floor. Each sheet has
seven dates printed; Monday thru Sunday. I need to print this one template
52 times for each week of the year. Is there a formula that i could enter
one day (i.e. the first date for the first monday) and automtically print the
rest of the weeks. in essence, press the print button one time, but the same
template will print 52 times with each week on the sheet?