How to automate dates 1

[Salubriouscreature]

I have a situation where I want to enter a date in A1. From this I want Excel to autocalculate and fill in rest of the months across the columns...that's the easy bit which I can do.

I also want excel to autocalculate the weekday from this date and place it into cell A2 and likewise accross the rest of the columns.

Eg

A B C D E
1 01/01/03 02/01/03 03/01/03 04/01/03 05/01/03
2 Mon Tues Wed Thurs Fri

Of the above, all that I want to enter is 01/01/03 in cell A1.

Any ideas?

Thanks

 

[xlhelp]

All you need to do is put =A1 in cell A2 then go to Format, Cells, Number tab, Custom and in the Type: box type in mmm -Radix lecti

 

[Salubriouscreature]

Ahh. Thanks..although it was actually dddd that I needed to type.

The next thing is how do I conditionally format just the Saturdays and Sundays as shaded grey?

Thanks

 

[xlbo]

Select all cells which need the conditional formatting in row 1 then
Format>Conditional format

For row 1 (Dates)
FORMULA IS

=if(or(weekDay(A1)=6,weekday(A1)=7),TRUE,FALSE)

Repeat for row 2 (days)
FORMULA IS

=if(or(A2="Saturday",A2="sunday&quot,TRUE,FALSE)

Rgds
~Geoff~

 

[Salubriouscreature]

Guys....what can I say. A swift accurate response.

Many Thanks & Happy New Year