Bryan,

Shane's approach makes good sense. The only change I would make is to avoid
the addin.

If you change your formula =SUMPRODUCT(--(D3:D766=1),--(D4:D767<1)) to
=SUMPRODUCT(--(D3:D766=1),--(D4:D767<1),--(A3:A766 =Today()-365)) it will
ignore absenses more than 365 days prior to the current date. It is not
necessary to delete them, just ignore them.

Yeah, yeah, leap year creates a concern. So when leap year is a factor
change 365 to 366.

Tom