|Here is another (Untested) work around:|
Put your Date in cell A1,
Next, Select, highlight, the Range of Cells A1 thru A47
Now at the lower right corner of your selected range,
there is a small box, grab the box and Drag down to Row # 1411.
You should now have a Date every 47 Rows,
IE Cell A1, Cell A48, Cell A95
As it happens, that is the number of rows that
print on a Portrait Orientation, Letter Size paper,
with default margins. (On Excel 2007)
So you should get what your looking for.
If you prefer to use Landscape Orientation, to give you more room,
then use the Range of Cells A1 thru A34
But, if you answer DerbDad03's query, you will get a macro
that will be more suitable and a lot easier to use.