How to display all dates of a month?

Question

excel

How to display all the dates of a given month in a column in Google Sheets (or Excel, but Google is better)?
I enter 01.2020 in the cell (It is possible from the drop-down list), and under it 31 cells should be filled with the following row:
01/01/2020
01/02/2020
...
01/31/2020

In the case of February, the last date should, of course, be 02/29/2020

Answer 1

=SEQUENCE(ДАТА(ГОД(A1);МЕСЯЦ(A1)+1;ДЕНЬ(A1)-1)-A1;1;A1+1)

And set the date format for the entire column