how do i automatically change the day and date

C

Caveman

If A1 is blank, A2 is january, B1:AF1 are days of the month, B2:AF2 are
dates(1st-2nd etc) how do i get them to change for the whole month by
just changing the first day or date of the month.
 
W

widemonk

Not sure what you mean.

B1 to AF1 loops monday to sunday over 31 columns (days in a month) ?
B2 to AF2 is 1st, 2nd, 3rd etc.

Which cell do you want to change (B1 or B2) so that the rest ar
automated
 
C

Caveman

if the 1st jan is on a sat (2005) then when 2006 comes round then th
1st jan should show it is on a sunday so if i change B1 (sat) to Su
then the rest of the month will automatically change without have t
replicate along the ro
 
S

swatsp0p

Better yet, just change a cell to show the first of the month (and year
e.g. cell A1 = 01-Jan 05

In B1, enter: =WEEKDAY(A1) and Custom format this cell as 'dddd' (i
will show Saturday)

In C1, enter: =B1+1 it will show Sunday. Copy this to the right a
far as needed... (tip: make sure all cells are wide enough to displa
"Wednesday" else #### will be displayed instead)

Now, simply change A1 to 01-Jan 06 and B1 becomes Sunday and the res
follow suit.

Does that work for you
 
Top