Dim TempDate AsNewDate(1986, 2, 28)
Dim StartDate AsNewDate(1986, 8, 1)
Dim EndDate AsNewDate(2006, 9, 6)
Dim BrokenPeriod1Start AsNewDate(1990, 1, 1) 'Use an array and a loop for these, this is just an example
Dim BrokenPeriod1End AsNewDate(1990, 7, 1)
Dim BrokenPeriod2Start AsNewDate(1997, 1...