Contact me directly and I will help you to cope with it. I was trying to send you my mail but it looks it did not come through. I used to have a similar problem, one guy showed me how to make it right. It is simple and fast, but it is a bit difficult to explain it in writing. It is better to discuss it over the phone, I am from Texas https://areaphonecodes....
Disclaimer: I am posting this answer that doesn't exactly answer the asker's question because this is the answer I needed when this question was the first result on Google, and I want to help the next person who has the same question I did.
This may not be the prettiest formula, but the result is the prettiest I could manage. Here's the Google Sheets ...
It is as simple as using the following sequence formula
Or you even could have something like this:
You could even use the SEQUENCE function for dates