Day and Date - How to Automate

[RJ]

I create a schedule each month. There is a column heading for each day of the
month formatted like this. It is a General format:

Sunday 10-1 Monday 10-2 Tuesday 10-3 ... and so on.

Each month, I manually retype the day and date of each column to correspond
with the current month. Is there a way to automate this so I don't have
manually change 30 column headings each month?

 

[Pete_UK]

Select A1:B1 and click Format | Cells | Number (tab) | Custom and enter
this in the box:

DDDD mm-d

You can then enter your starting date into A1 (eg as 10-1-2006, or
whatever your usual style is) and this should be formatted as you want
it. Then enter this formula into B1:

=A1+1

which should also be formatted in the same style. Then all you have to
do is to copy B1 into C1 onwards, for as many cells on that row as you
like (30?). To change all the dates to the next month, all you need to
do is change the starting date in A1 to 11/1/2006 (or whatever).

Hope this helps.

Pete

 

[RJ]

Absolutely Perfect. Many Thanks !!

Select A1:B1 and click Format | Cells | Number (tab) | Custom and enter
this in the box:

DDDD mm-d

You can then enter your starting date into A1 (eg as 10-1-2006, or
whatever your usual style is) and this should be formatted as you want
it. Then enter this formula into B1:

=A1+1

which should also be formatted in the same style. Then all you have to
do is to copy B1 into C1 onwards, for as many cells on that row as you
like (30?). To change all the dates to the next month, all you need to
do is change the starting date in A1 to 11/1/2006 (or whatever).

Hope this helps.

Pete

 

[Pete_UK]

You're welcome. Thanks for feeding back.

Pete

Absolutely Perfect. Many Thanks !!