would need to see the data and the workbook - but by the description suggest you look into creating a date scaffold and join it to the data
it is a presentation for TC!18 by Archana Ganeshalingam and Sasha Singh It will show you how to use scaffolding in a number of situaltion
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.