Print Day and date on selecting a month

[vij]

Hi,

I am looking for help as under:

In cell A1 if i input month as Jan 2020 my output in cell B2 to AL2 should 1 to 31 and B3 to AL3 should be the corresponding days of the month.

Like wise if I input any other month in A1 then I should be able to get the new month (Input) date and day.

Would appreciate guidance on this.

Thanks,
Vij

 

[steve the fish]

Do you mean this?

=IF(MONTH($A$1)=MONTH(EOMONTH($A$1,-1)+COLUMNS($A$1:A1)),EOMONTH($A$1,-1)+COLUMNS($A$1:A1),"")
=TEXT(B2,"dddd")

 

[vij]

Do you mean this?

=IF(MONTH($A$1)=MONTH(EOMONTH($A$1,-1)+COLUMNS($A$1:A1)),EOMONTH($A$1,-1)+COLUMNS($A$1:A1),"")
=TEXT(B2,"dddd")

Thanks a ton Steve. Works perfectly.