I changed all the named ranges (d, date, hrs, initials) so that last row is 1000 instead of 13 and it works fine for me.

As mentioned a couple of times before don't change the references to whole columns! That's a sure way to kill Excel when you have array- or array-like formulas.

Attached Files

mmpCal_4.xlsx (27.7 KB, 11 views)