Auto-format Dates and weekends

Hello everyone. I admit it....Excel has beaten me. I need a little help if you can.

I need to set up a checklist for my users that will allow someone to also go behind and double check their work. So, I need two rows for each day of the month. But, I would like to gray out the weekend days since no-one is usually at work on those days. I can do the conditional formatting to get the weekends highlighted if I set the dates up in advance, but I want to have the spreadsheet change with me simply changing the month and year once on the top of the page and then the dates follow suit by calculating the weekends. For example: I would like to change the Sep 16 cell below to Oct 16 and then rows two through four (1st and 2nd of Oct) would automatically grey out. Of course columns B through whatever will be used also and should be highlighted with the weekend dates. Is this possible?

Sep-16
1
1
2
2
3
3


Thanks for any help or guidance you can offer here.

In the attached I've used the below formula to deal with the conditional formatting:

Formula:

Please Login or Register  to view this content.

This checks the dates in column A and if it's a Sat (1) or Sun (7) then it will shade the row.

I've also used a slightly complicated formula from A4 downward that will leave the last few cells in column A blank if the month doesn't have 31 days.

Hopefully somewhere near what you're after.

BSB

Or ...

=WEEKDAY($A3,2)>5

With this in Worksheet_Change

Please Login or Register  to view this content.

and this for conditional formatting

Please Login or Register  to view this content.

Kind regards
Leo