My example had a math error due to issues I seem to have with copy/
paste ;-)

Example was meant to imply...

Block 1 = 5 consecutive days
Block 2 = 1 day
Block 3 = 5 consecutive days
Block 4 = 4 consecutive days

Total days = 14

Blocks generated in this fashion would imply Employee 1 is taking
vacation on 4 seperate occasions. (ie, 1 week, 1 day, 1 week, 4
days). For the sake of argument... assumption is weekdays.

Thanks for pointing out the error.

- MH


On Apr 27, 1:46*pm, Jay wrote:
In your example (eg, 5 consecutive days, 1 day,