how do i automatically change the day and date
 

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.


--
Caveman
------------------------------------------------------------------------
Caveman's Profile: http://www.excelforum.com/member.php...o&userid=27546
View this thread: http://www.excelforum.com/showthread...hreadid=475553

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 are
automated ?


--
widemonk


------------------------------------------------------------------------
widemonk's Profile: http://www.excelforum.com/member.php...o&userid=20402
View this thread: http://www.excelforum.com/showthread...hreadid=475553

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


--
Caveman
------------------------------------------------------------------------
Caveman's Profile: http://www.excelforum.com/member.php...o&userid=27546
View this thread: http://www.excelforum.com/showthread...hreadid=475553

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' (it
will show Saturday)

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

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

Does that work for you?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=475553