I think you may have a couple of options
1. Use interval match functionality to apply date ranges.(See QV Help) This could possibly be built dynamically using the date list to determine start and end date ranges using the previous function.
2. Use the Autogenerate functionality to build a continuous list of dates - see Master Calendar elsewhere.
Ive highlighted the key words to look for in help or the community but if you attached some sample data I or others could look at a solution for you.