0

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"))

0

0

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)

create a sequence of dates using starting and end dates from cells


Please use the following formula:

=SEQUENCE(1,18,"2018-4-13",1)

enter image description here

More about SEQUENCE

| improve this answer | |
  • 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 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 at 15:34
  • I think you over-complicate things. Please check the updated answer. – marikamitsos Jun 19 at 18:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.