How do I set up a 52 week agenda with day ,date and room to write
 

Please include the question in the text. You don't provide much to work with.
After you figure out the format you want per row.

You can format date to include the day of the week ddd
If you have the starting date in cell A2, you can add 7 days to that date
in A3 either as a constant or as a formula and then select rows 2 and 3
and use the fill handel to fill down the entire row.as far as you want to go.
http://www.mvps.org/dmcritchie/excel/fillhand.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Richard" wrote in message ...