1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Use of text sequence formula vertically

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

submitted by /u/elerooisbest
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article