Sum of Current Column

Hi All,

I would like to also show the current day's late and present count of all employees. Say for instance, January 8 is the current date, we have 3 employees who are Present, so Column D (this will always show the current day count) should show as 3. Same concept with Column E. Columns D and E should only count the current days total of present and late employees. It should just show it in D2 and E2 rows.