I have one cell where I input month/year, and would like that Excel
automatically fill all fields in row as:

from 1 2 3 4 ..... to 28 (if it is input date: 02/2003)

and below of this each cell to put weekday.

It will be great if each column on Sunday have background
automatically colored with some color (red) and few cell below Sunday
also red background.

Thanks.