Answer the question
In order to leave comments, you need to log in
How to display all dates of a month?
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 the question
In order to leave comments, you need to log in
=SEQUENCE(ДАТА(ГОД(A1);МЕСЯЦ(A1)+1;ДЕНЬ(A1)-1)-A1;1;A1+1)
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question