weekday and date series fill

  • Thread starter Thread starter Teacher_Becky
  • Start date Start date
T

Teacher_Becky

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.
 
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
 
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.
 
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
 
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
 
Back
Top