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

3
  • 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. 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. Jun 19 '20 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.