How do you do this with columns instead of rows?
=ARRAYFORMULA(TEXT(ROW(INDIRECT("A"&DATEVALUE("2018-4-13")&
":A"&DATEVALUE("2018-4-30"))), "dd/mm/yyyy"))
Add a comment
|
EDIT:
(following OP's comment)
...to include a custom start and end date which I know I didn't ask for based on your reply
=SEQUENCE(1,B2-A2,A2,1)
Please use the following formula:
=SEQUENCE(1,18,"2018-4-13",1)
More about SEQUENCE
answered Jun 18 '20 at 0:08
-
Welcome. Please remember. As per site guidelines when an answer addresses your question, you should accept it and maybe upvote it so others can benefit as well. – marikamitsos Jun 18 '20 at 0:10
-
Thank you! I modified the sequence to include a custom start and end date which I know I didn't ask for based on your reply. =arrayformula(text(sequence(1,cell_with_end _date - cell_with_start_date,cell_with_start_date,1),"mm/dd/yyyy")) – Jeff Jun 18 '20 at 15:34
-
I think you over-complicate things. Please check the updated answer. – marikamitsos Jun 19 '20 at 18:44
