weekday and date series fill
 

I'd like to create an academic lesson plan book with weekday and date as the
column heading. Is there a simple way to combine the weekday plus the date
(for example, Tuesday, July 29) and have it generate 36 weeks of dates? I
know how to do this seperately (weekday or date), and have tried a few
different simple things, but nothing seems to be working for me. Thanks for
your help.

weekday and date series fill
 

Teacher_Becky,
Here is what I did to get "Wednesday Jul 30" in a cell.
Select the start cell, say A1.
Select Format,Cells and "Custom"
In the widow on the right side under "Type:"
Type the following: dddd mmm dd
Once this is done. Copy the cell, and Special Paste, Format across for six
days (so a total of seven days). You may have to resize the columns.
Then copy the seven days to another row, Paste Special, Format.
Repeat as necessary, for 36 weeks.
hth

"Teacher_Becky" wrote:

I'd like to create an academic lesson plan book with weekday and date as the
column heading. Is there a simple way to combine the weekday plus the date
(for example, Tuesday, July 29) and have it generate 36 weeks of dates? I
know how to do this seperately (weekday or date), and have tried a few
different simple things, but nothing seems to be working for me. Thanks for
your help.

weekday and date series fill
 

Thanks. That worked great! I was even able to have a comma after the weekday.
New possibilities for me...

BTW, I am using 2007. Now for some fine tuning. Is there a way to only do a
series of Monday-Friday, and not Saturday-Sunday, and still have the correct
dates fill in? If not, I can just delete the Sat/Sun columns. I just want to
use the ability of excel as much as possible. Thanks again.

"FloMM2" wrote:

Teacher_Becky,
Here is what I did to get "Wednesday Jul 30" in a cell.
Select the start cell, say A1.
Select Format,Cells and "Custom"
In the widow on the right side under "Type:"
Type the following: dddd mmm dd
Once this is done. Copy the cell, and Special Paste, Format across for six
days (so a total of seven days). You may have to resize the columns.
Then copy the seven days to another row, Paste Special, Format.
Repeat as necessary, for 36 weeks.
hth

"Teacher_Becky" wrote:

I'd like to create an academic lesson plan book with weekday and date as the
column heading. Is there a simple way to combine the weekday plus the date
(for example, Tuesday, July 29) and have it generate 36 weeks of dates? I
know how to do this seperately (weekday or date), and have tried a few
different simple things, but nothing seems to be working for me. Thanks for
your help.

weekday and date series fill
 

Hi Becky

Are you saying you want the 36 weeks going across the page i.e 180 columns?
If so, enter your start date in A1
Format in the way you wish
In B1 enter
=WORKDAY(A1,1)
Copy across through 179 columns.

If you want the weeks going down the page, i.e only using 5 columns but with
several rows between each set of headings, then
Repeat step above, but only copy through B1:E1

In say A11, enter
=Workday(A1,5)
Copy across through B11:E11
Mark A11:E11
Control+C to copy
Move to A21 Control+V to Paste
Repeat Paste until you have your 36 weeks
--
Regards
Roger Govier

"Teacher_Becky" wrote in message
...
Thanks. That worked great! I was even able to have a comma after the
weekday.
New possibilities for me...

BTW, I am using 2007. Now for some fine tuning. Is there a way to only do
a
series of Monday-Friday, and not Saturday-Sunday, and still have the
correct
dates fill in? If not, I can just delete the Sat/Sun columns. I just want
to
use the ability of excel as much as possible. Thanks again.

"FloMM2" wrote:

Teacher_Becky,
Here is what I did to get "Wednesday Jul 30" in a cell.
Select the start cell, say A1.
Select Format,Cells and "Custom"
In the widow on the right side under "Type:"
Type the following: dddd mmm dd
Once this is done. Copy the cell, and Special Paste, Format across for
six
days (so a total of seven days). You may have to resize the columns.
Then copy the seven days to another row, Paste Special, Format.
Repeat as necessary, for 36 weeks.
hth

"Teacher_Becky" wrote:

I'd like to create an academic lesson plan book with weekday and date
as the
column heading. Is there a simple way to combine the weekday plus the
date
(for example, Tuesday, July 29) and have it generate 36 weeks of dates?
I
know how to do this seperately (weekday or date), and have tried a few
different simple things, but nothing seems to be working for me. Thanks
for
your help.

weekday and date series fill
 

AWESOME! You read my mind! Not only do I have to create one version of my
planner with columns, but I need to do it in rows also. So, thanks for
thinking ahead for me! AND thank you for the clear and simple instructions
Roger. I just love this place. I learn so much. -becky

"Roger Govier" wrote:

Hi Becky

Are you saying you want the 36 weeks going across the page i.e 180 columns?
If so, enter your start date in A1
Format in the way you wish
In B1 enter
=WORKDAY(A1,1)
Copy across through 179 columns.

If you want the weeks going down the page, i.e only using 5 columns but with
several rows between each set of headings, then
Repeat step above, but only copy through B1:E1

In say A11, enter
=Workday(A1,5)
Copy across through B11:E11
Mark A11:E11
Control+C to copy
Move to A21 Control+V to Paste
Repeat Paste until you have your 36 weeks
--
Regards
Roger Govier

"Teacher_Becky" wrote in message
...
Thanks. That worked great! I was even able to have a comma after the
weekday.
New possibilities for me...

BTW, I am using 2007. Now for some fine tuning. Is there a way to only do
a
series of Monday-Friday, and not Saturday-Sunday, and still have the
correct
dates fill in? If not, I can just delete the Sat/Sun columns. I just want
to
use the ability of excel as much as possible. Thanks again.

"FloMM2" wrote:

Teacher_Becky,
Here is what I did to get "Wednesday Jul 30" in a cell.
Select the start cell, say A1.
Select Format,Cells and "Custom"
In the widow on the right side under "Type:"
Type the following: dddd mmm dd
Once this is done. Copy the cell, and Special Paste, Format across for
six
days (so a total of seven days). You may have to resize the columns.
Then copy the seven days to another row, Paste Special, Format.
Repeat as necessary, for 36 weeks.
hth

"Teacher_Becky" wrote:

I'd like to create an academic lesson plan book with weekday and date
as the
column heading. Is there a simple way to combine the weekday plus the
date
(for example, Tuesday, July 29) and have it generate 36 weeks of dates?
I
know how to do this seperately (weekday or date), and have tried a few
different simple things, but nothing seems to be working for me. Thanks
for
your help.