Hey newdoverman - Sorry I've been working on another project and been ill. Yes, this gives me the correct number on the Summary Tab G Column. I am testing scenarios to verify if the data will stay true given different dates. Thanks for your work on this. I noted that you had the instances of unexcused illness accrue at the bottom of a consecutive list instead of the top. I wasn't expecting that, but so far this looks like a very good solution. So grateful!