Auto populate Weekdays and Dates in the specific cells

[alipezu]

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.