Hi,

I want to make a .xls with my working hours to calculate my wage. I designed
myself a lay out but I can't make it. What I want is 13 identical tabs for my
periodes. Within one tab I want the dates of those periodes "grouped" in
weeks. With this I mean: I want rows 1 and 2 to be empty (for now). The next
7 rows of the first coloms have the 7 dates of the first week. Then again 2
blank rows and the next week begins. Till I have 4 weeks which make up one
periode. Above one tabel which makes up a week I want a one cell telling me
the week number (hence the reserved free rows).
This is the general lay-out. But I want it to be automated. In colom A row 1
I want to type the year (2006 is this case) and I want to write down the date
of the first of the first day of the first week of the year. With this info I
want the file to calculate all dates; weeknumbers etc.

I know I want a lot. And I admit I do not have the full grasp of the scope
of this problem but I think it's possible but I don't know how to build it.
Is there anybody who can assist me with general guide lines and maybe an
other angle of looking at this problem?