Dates in rows for planner

[bjcdude]

Hi

I have recently working on a couple of weekly planners over 3 to 4 months and I have had the change the month and the day manually. I was wondering if there is an easier way to do this. The planner goes from monday to friday with saturday and sunday in the same column and the month and date are above the days of the week

Any help would be great

Thanks
Brian

 

[Derek Brown]

Excel holds dates as numbers (the number of days since 00/01/1900).
So you only have to enter one date with the others calculated.
For example:
In A1, enter a date.
B1 would then have the formula =A1+1
C1 would have then formula B1+1
etc.
If you want to show the month, date and day separately then you need to repeat the date.
For example:
In A1, enter a date.
A2 would be =A1
A3 would be =A1
All you then have to do is format the cells with a Custom Format.
A1 could be formatted as "mmmm" (without the quotes)
A2 could be "dd mmm yyyy" (without the quotes)
A3 could be "dddd" (without the quotes) or "ddd" if you want the 'short' format.