Daily calendar

**davebozy** · 12-12-2010, 01:40 AM

I'm new to excel and working with Amish people who don't use electricity.

The daily calendar has time 8:00 a.m. to 5:30 p.m. with 5 columns with employee names as column headers. They put names of clients who each employee meets with.

They use a paper daily planner and with a pencil write the 5 names and block out 10 a.m. to 11:30 a.m. for every weekday of the year(a lot of writting).

Through this forum I was able to get the calendar copied for one day.

I need to print the entire 2011 but don't know how to get the Day and date to print on the header. I need Monday December 13, 2010 Tuesday December 14, 2010 etc I attached what I have so far. Any help appreciated.

**royUK** · 12-12-2010, 04:51 AM

There is no attachment

**davebozy** · 12-12-2010, 10:39 PM

oops forfot attachment. I can't get the day and I can't get any other month to print except the month we are in.

**jaslake** · 12-25-2010, 08:20 PM

Hi Dave

Try this code

Please Login or Register  to view this content.

The lines of code I changed are underlined. This line

Please Login or Register  to view this content.

I didn't understand what you were trying to do so it's commented out. We can fix it it you tell me what you're trying to accomplish.

Let me know of issues.

John