•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Use of text sequence formula vertically
Our take
If you're looking to generate a vertical sequence of weekly dates in your spreadsheet, you're on the right track with using the text sequence formula. While it may be straightforward to create a horizontal list, achieving a vertical arrangement can be a bit tricky. The formula you currently have, `TEXT(SEQUENCE(,52,46023,7), "dd/mm/yyyy")`, is a solid foundation. Let’s explore how you can modify it to achieve your desired vertical output effectively. Your quest for streamlined data management is commendable, and this solution could enhance your productivity.
Hi
I am trying to use a text sequence that will give me a weekly date and will run down vertically. I am able to do this horizontally. I have tried google but can't see anything. Can this be done?
This is the formula that I currently use
Text(sequence(,52,46023,7), "dd/mm/yyyy")
Thanks
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#AI formula generation techniques#rows.com#formula generator#Excel compatibility#google sheets#Excel alternatives for data analysis#Excel alternatives#text sequence#sequence#dd/mm/yyyy#weekly date#run down vertically#excel#formula#horizontally#current formula#google#reddit#trying to use#date format