It is the blank cells Lawrence. If they were zeroes, it would work. But this will get enormously slow when you extend the range and copy for all datesand all employees.