Dave has given you're a great answer and Don some fine advice.
I have made a template workbook that you can use - just email me (get my
email addy from my website). It is less sophisticated than Dave's but easy
to use and alter to suit your needs.
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"BetaDocuments" wrote in message
...
Hi,

I have reports that I do at work, I need one spreadsheet per month
with one work day, or 5 tabs per week. Is there any non macro way to
have this being done automatically?

So I have 1 tab each for Nov. 2, Nov. 3 .... Nov 6 then next monday,
Nov. 9 ......Nov 13.


Thanks in advance!