Improving the speed of a loop through a date range

Thanks for all the input!

xladept: That definitely makes the copying and pasting thing I had much simpler.
Unfortunately the overall speed is the same. I wonder if it has more to do with the calculations its doing each time rather than looping through the date.

StuCram: I did try that but it still takes the same amount of time

Richard: I think the only problem with that is I don't know which dates needed to be copied and pasted over until I cycle through it. A piece of equipment can be assigned a number (0, 1, or 2) referring to (DOWN, SLOW, UP) at any given time based on calculated values. I'm interested in the transition from 0 to 2 (i.e. DOWN to UP or UP to DOWN). However, I don't know when that transition occurs unless I look at every specific time. But you bring up a good point about how I approach it; maybe I need to completely rethink how to gather the dates without having a loop.

I'll keep working on it!