Forum Discussion
Count multiple installation start and end date ranges in each week, of each year
I think there's something about your data that I'm just not grasping. I have noticed that it appears that each project takes six weeks. Noting that, I tweaked the formula here just a bit and got closer to some of your numbers, but not in the same weeks. Maybe you can make some adjustments to it given your understanding of the data itself.
Thank you so much for all your efforts and help. You have been the only person I have found online to even take a stab at this, let alone two. I very much appreciate how generous you have been with your time. The numbers in your second generous attempt still don't quite match what I have just eyeballed in manually adding things up. However, I'm going to look into VBA programming to see if that will provide a resolutionmathetes