Auto populate Weekdays and Dates in the specific cells

Hi All,
I have two sheets and I create the monthly report each month where I manually put dates and weekdays in A8:A38 and B8:B38 respectively.
and Current month in A1 each month. What would I do to do all this Automatically in both the sheets.
I would like weekdays in my language and not in English. Here A stands for Saturday B for Sunday and so on.
And I would also like to format the cell colour yellow where it contains A or B.

Thanks in advance.

Done. Hopefully this is what you are looking for.

Try:

A1 =1/10/2016 -> FormatCells -> "Month: "mmmm yyyy

A8 = A1

A9 =IF(MONTH($A$1+ROWS($A$8:A8))=MONTH($A$1),$A$1+ROWS($A$8:A8),"")

A8:A38 -> FormatCells -> d

B8 =IF(A8="","",CHOOSE(WEEKDAY(A8),"B","C","D","E","F","G","A"))

Formula for CF:

=WEEKDAY(A8,2)>5

See this...

Thank to all and special thanks to 'Phuocam' which gave me the exact thing I needed.

You are welcome!

In A8:

=IF(MONTH(WORKDAY($A$1-1,ROWS($A$8:A8)))=MONTH($A$1),WORKDAY($A$1-1,ROWS($A$8:A8)),"")

Copy down.

Thank you Phuocam,
That worked.
In some scenarios I need to exclude Fridays and Saturdays instead of Saturdays and Sundays. So what would my formula in those scenarios?