A
A
Alexey Mikhailov2020-08-24 16:27:50
excel
Alexey Mikhailov, 2020-08-24 16:27:50

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

1 answer(s)
G
Grigory Boev, 2020-08-24
@DPhil

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

And set the date format for the entire column

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question