Create monthly spreadsheets with the days of the month
 

I'm using Excel 2003 on windows XP to create monthly schedules for my
co-workers. Is there a simple way to create sheets that have one or two rows
be the days/dates of the month? Right now I'm doing it manually:

Su Mo Tu We Th etc
1 2 3 4 5 ...

Thanks,

pjs

Create monthly spreadsheets with the days of the month
 

Place Wed in A1, Thu in B1, 1 in A2 and 2 in B2. Now select all four cells
and then drag the fill handle to the right for a total of 31 columns. This
will fill the necessary series for all 31 days in August.

Another solution:

In A1, enter 08/01/07. In B1 enter =A1+1 and then copy across for a total of
31 columns. Format this row as "ddd" to display the day of the week.

In A2, enter =Day(A1) and copy across for 31 columns.




--

Damon Longworth

2007 Excel / Access User Conference
London, England - Currently rescheduled
St. Louis, Missouri - Oct 24-26, 2007
www.ExcelUserConference.com/


"pjs" wrote in message
...
I'm using Excel 2003 on windows XP to create monthly schedules for my
co-workers. Is there a simple way to create sheets that have one or two rows
be the days/dates of the month? Right now I'm doing it manually:

Su Mo Tu We Th etc
1 2 3 4 5 ...

Thanks,

pjs

Create monthly spreadsheets with the days of the month
 

Damon --

Many thanks. The dates line worked like a charm. I modified the "days of
the week" instruction a bit. What worked better for me was =TEXT (A1,"ddd").

I appreciate your help. Now if I can figure out a macro to do this, I'll
really be set!

pjs

"Damon Longworth" wrote:

Place Wed in A1, Thu in B1, 1 in A2 and 2 in B2. Now select all four cells
and then drag the fill handle to the right for a total of 31 columns. This
will fill the necessary series for all 31 days in August.

Another solution:

In A1, enter 08/01/07. In B1 enter =A1+1 and then copy across for a total of
31 columns. Format this row as "ddd" to display the day of the week.

In A2, enter =Day(A1) and copy across for 31 columns.




--

Damon Longworth

2007 Excel / Access User Conference
London, England - Currently rescheduled
St. Louis, Missouri - Oct 24-26, 2007
www.ExcelUserConference.com/


"pjs" wrote in message
...
I'm using Excel 2003 on windows XP to create monthly schedules for my
co-workers. Is there a simple way to create sheets that have one or two rows
be the days/dates of the month? Right now I'm doing it manually:

Su Mo Tu We Th etc
1 2 3 4 5 ...

Thanks,

pjs