Date data continuations

[csapp_ARV]

Good Evening everyone.

I'm looking to continue a range of dates. Specifically 6/10/22-6/25/22 and basically continue it as 6/25/22-7/10/22 ---->7/10/22-7/25/22.
How could I go about doing this while maintaining the format with the date. If it is of importance, I need it to be able to move in specific cells, for instance A1 then A11 and progress down in that same spacing.

Thank you all, just starting out learning Excel. I appreciate the help and look forward to learning from the community.

 

[footoo]

Do the date ranges deliberately overlap?

Why not split the from-date and to-date into 2 columns?

 

[csapp_ARV]

I suppose I could and the function would still be the same. I'll give it a shot and see how it turns out. It's for a bill payment sheet for our household bills to try to get a grasp of basic excel functions. This may have been a bad idea for a first project due to the fact that I'm taking something I've very meticulously hand written for years and trying to over complicate something simple. Either way it will take some fiddling before I find a way to transfer it into excel. Thanks @footoo for the suggestion!