How to insert Date to spreadsheet?

[sezuh]

HI,
i'll be greatful if anyone would help me to insert insert date for the whole year In column "A" and how to format Sat. with green,Sun. with Red colour all across the sheet.Thank you as ever for all help in advance.
Sheet3

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 11pt; FONT-FAMILY: Calibri,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 138px"><COL style="WIDTH: 65px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD></TR><TR style="HEIGHT: 23px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="FONT-SIZE: 14pt">DATES</TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="COLOR: #008080">SAT 01 JAN 2011</TD><TD style="COLOR: #008080"> </TD><TD style="COLOR: #008080"> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="COLOR: #ff0000">SUN 02 JAN 2011</TD><TD style="COLOR: #ff0000"> </TD><TD style="COLOR: #ff0000"> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD>MON 03 JAN 2011</TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD>TUE 04 JAN 2011</TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD>WED 05 JAN 2011</TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD>THU 06 JAN 2011</TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD>FRI 07 JAN 2011</TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="COLOR: #008080">SAT 08 JAN 2011</TD><TD style="COLOR: #008080"> </TD><TD style="COLOR: #008080"> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="COLOR: #ff0000">SUN 09 JAN 2011 </TD><TD style="COLOR: #ff0000"> </TD><TD style="COLOR: #ff0000"> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD>MON 10 JAN 2011</TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD>^</TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD>^</TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD>^</TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD>up to</TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="COLOR: #008080">SAT 31 DEC 2011</TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>


KIND REGARDS
SEZUH

 

[GK039]

Hi Sezuh,

Try Jeff's proposal in post #7. It's simple and works great. But If you want to go to any specific date earlier than today to start from, change the arguments within MONTH and DAY parentesis to:

MONTH(TODAY())-any number.
MONTH(TODAY()) gives you 5, that is May. Subtract one for April, two for March etc.

DAY(any number that repsresents a day from 1 to 31)

To make it more dynamic you can set some cells anywhere in your sheet to be used as variables values where you can house the numbers that you subtract each time

George

Hi Mrbill11 and George, thanks for your response its amazing when several people offer thier help ,thats what i like about this forum.Your help much appreciated......
George if i do not want to start from today but from any earlier date what change to be done to excel formula?
sezuh

 

[sezuh]

Thank you, thank you Jeff, your excel formula and conditional formatting even better... Thanks a Mill.Wonderful solution..
And thank you George for the feed back with the answer,much obliged.
Regards
sezuh

 

[jeffreybrown]

Glad you found something that works...you're welcome