I have a column with the weekend date in cell [B3] and the days (Monday – Friday) beneath it begining in cell [B5], between each day I have a gap that’s dynamic depending on the number of records I have for a given day. I want to be able to create perhaps a loop that’ll fill in the actual date between the days based on the weekend date. However I’m not sure how to approach this.
Any suggestions?