Weekdays, I wish!

My spreadsheet is as such:
A1 expects a date (in my case always the first of the month).
A2 is a formula - A1+1 and so forth. When I enter a date e.g. 1-6-08
then obviously it will display 31 days. I have it set so it displays day/date.
Is there a way to grey out weekends or not display themat all?
Or do I have to enter all the dates manually?
PS I am sorry if this is a stupid question but I am new to Excel.

Thanks in advance
Alan

You could "white out" the weekend dates using conditional formatting.

Select A1:A31 and then

Format > conditional formatting > "formula is" from dropdown and in the box....

=WEEKDAY(A1,2)>5

select white font.

Alternatively you can use WORKDAY formula from Analysis ToolPak add-in

Put 1st of month in A1 (format as mmm-yy)

in A2 use this formula

=WORKDAY(A$1-1,ROWS(A$2:A2))

format as date and copy down column

You people are terrific!!!
thankyou so much
Alan

Roy, that is exactly what I wanted! When I opened the example you posted, it automatically translated everything in to Swedish for me! I just copied your hard work into my spreadsheet.
Thankyou so much!
Alan