Print view by date

J

jsrowe

I am a teacher and am required to keep handwritten attendance and grad
registers for each of my classes so to save time I use excel t
generate a table with names and dates that I can print out and writ
on.

I have a worksheet with names down the side and dates across the to
for each class and on one piece of paper I can manage to fit about 2
columns (and so this sheet is useful for about 20 lessons). After
have filled the sheet I have to go back to excel, hide some columns
re-set the print area and print off a new copy.

Would it be possible to automate this process so that I can print off
set of register sheets at the start of the year (giving me about 2
dates per sheet) or even better detect the date and print off a shee
to last me the next 20 lessons
 
D

David McRitchie

Wouldn't that requirement require handwritten names, and
bound in a book.

across the top
B1: any Monday starting date format as yyyy-mm-dd
B2: =B1 format as ddd
C1: =IF(WEEKDAY(B1)=6,B1+3,B1+1) format as yyyy-mm-dd
C2: =C1 format as ddd

You probably want to use a shorter date format.

Use the fill handle to propagate across the top

File, Page set, sheet, Rows to repeat at top: $1:$2
Columns to repeat at left: $A:$A
this affects printing only.

For display if you were to type in the names you might want to
freeze to top 2 rows and left column by selecting cell B3 then
Window, Freeze, panes
http://www.mvps.org/dmcritchie/excel/freeze.htm

You can adjust your margins file, page setup, ...

If you want to print more than 20 then continue on past col V then
You can place manual page breaks
select column W then insert, page break
Date and Time
http://www.mvps.org/dmcritchie/excel/datetime.htm
 
Top