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"))
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityHow 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"))
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