Planner in Excel

[Alexei]

Hi,
Need your help to create a simple planner in Excel.
I found plenty calendars, nice planners, plain and array formula solutions
but they all appeared to be formatted as normal calendar grid (by weeks) or
dates distributed down the column.
I need dates distributed across the single row with week's numbers and days
above.
Let's say following set up (formatting):
1. Columns 1 and 2 are reserved for project number, project name
2. Row 1 - month name
3. Row 2 - week number (formatted centred for 7 weekdays in row 3)
4. Row 3 - day (Monday-Sunday) repeated only for the actual dates in row 4
5. Row 4 - dates. Always starts from 1 in cell C4 and continue to 28...31
whatever actual number of days is in the particular month.
Cell A1 could be used to specify the Year we want this planner/calendar for.
If this could be accomplished for one month period on one sheet then 12 sheets
cover the entire Year. Just enter desired year in A1 and Planner is ready!
I will appreciate for ready solution or any advice in these regards.
Thanks.

 

[BrianB]

The main idea is to set up a single sheet which can be copied as many
times as required, and needing just a single cell changed to show
details of the calendar month required.

I would use the approach of having my "master" cell A1, or whatever,
(as row 1 month name) which would be a date - the first day of a month
formatted as Month/Year.

You then need to set up cells with formulas that directly or indirectly
(via other cells with formulas) refer to this master cell.

Look up 'Date Functions' in Excel Help for more info about what is
available.

 

[Alexei]

Thanks. I did it.