Renaming Tabs With Dates

I´d like to have a single workbook for each calendar year, with a tab for each date Monday through Friday (like 11-Jun, 12-Jun, etc.). I could then type the patients` names and times of arrival, among the other information I track. Alternatively, I could have a workbook for each month of each year (titled for example 2007 June or 2008 August), with the tabs titled by the date of the month (like 1, 4, 10, etc).

Is there an easy way to do this without manually renaming each tab for each day of the year?

If it´s too hard to limit the macro to create tabs for only the days of the workweek, it wouldn´t bother me if the workbook had to include every day of the week (Sunday-Saturday). I can always go back and delete the unnecessary ones.