Calendar Formula Problem

Hi! This looks like a great place for an Excel newbie, like myself!

I'm a dog trainer by avocation. I hold classes on Saturdays and weekday evenings and most of my classes are held once a week. I also hold advanced classes twice a week on weekday evenings. Here's my problem.

Right now I have three worksheets and two of them are involved in this problem. One worksheet provides the starting date of each weekly class. Weekly classes run for 10 weeks each. My class roster worksheet picks up the starting date for each class and runs a +1 addition formula to each day in the 10-week period to display the actual date at the top of each column. At the end of the 10 weeks, I have a formula that calculates how many sessions each student attended. This is pretty straightforward and not part of my problem.

The problem is the twice-weekly classes. There is no ending date for these and some of my students are with me for years. I'd like to set it up so that each twice-weekly class has a starting date and then, on it's own roster worksheet, displays the actual date for 364 days from the starting date. I would then continue any students who take more lessons to the following year. It seems like an awful lot of work to have a starting date and then a plus 1 formula for 364 days and I'm hoping that there is an easier way to do this. As far as the display goes, only the actual class-meeting days are displayed but, of course, the hidden columns must all contain the formula, anyway. There is the usual "Days Attended" sum at the end. Is there an easier way to enter the formula than to do a "sum=+1" for each and every column?

In short:

• Data picked up in starting date.

• Second class lesson is Starting Date plus 2 (approx); third lesson is Starting Date plus 4 (approx) with each intervening date being Starting Date plus 1.

• Data continues for Starting Date plus 364.

• Total Dates Attended at end of year.

I thank you, very much, for any help you can provide.

I should have mentioned that the way the formula now exists (for the 10-week classes only) is if the Start Date (SD) is on a Monday, Tuesday is SD+1, Wednesday is Tuesday+1, Thursday is Wednesday+1 and so forth. The column header is formatted as a Date.

Again, my thanks.

Unless you're using Excel 2007 there are only 256 columns so you won't be able to have 364 dates in separate columns.

Do you have to show all dates? If you have a class that runs on Tuesdays and Thursdays, for instance, and your start date is always a Monday then make your first date [in A1 say] SD+1 next, in B1, is A1+2 then in C1, B1+5.

You can now select both B1 and C1 and copy right across, giving you every Tuesday and Thursday date