You could provide a dedicated macro that adjusts the dates and does the
printing.
Option Explicit
Sub testme()
Dim StartDate As Date
Dim HowMany As Long
Dim dCtr As Long
StartDate = DateSerial(2008, 9, 25)
HowMany = 12
With Worksheets("sheet1")
For dCtr = StartDate To (StartDate + HowMany)
With .Range("A1")
.NumberFormat = "dddd mmmm dd, yyyy"
.Value = dCtr
.EntireColumn.AutoFit
End With
.PrintOut preview:=True
Next dCtr
End With
End Sub
If you're new to macros:
Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html
David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm
(General, Regular and Standard modules all describe the same thing.)
