Forum Discussion
Generating a list of Dates using nested array inside SEQUENCE function?
J-Des000 Please see the updated file below, which includes examples for days, months, and mixed intervals on separate worksheets. Hopefully that's what you meant...
J-Des000 Fair enough. The TOCOL / IFS / SEQUENCE method is what I would recommend anyways, so I'm glad it worked out for you. Just ignore the other method... Cheers!
djclements Just a quick question - if I needed to modify this formula for monthly increments (e.g 1, 2, etc instead (keeping the same day #) how would this be done?
J-Des000 Please see the updated file below, which includes examples for days, months, and mixed intervals on separate worksheets. Hopefully that's what you meant...
Desperate I can't Like your solution 5 times nor mark it as best response. Hopefully J-Des000 will find a minute to do it...
Lorenzo Thanks for the support! I hear yah, but I'm not holding my breath. It seems like the majority of users here don't follow-up by marking the "best response" of their choice. I gave up on trying to encourage people to do so after receiving this response from one user, lol. Still, the laid-back "discussion" format of this forum is much more enjoyable than the overly competitive nature of sites like Stack Overflow (the narcissism on display over there is absolutely unbearable).
