I am working on a class register that records the attendance of students within a semester. I have been able to write the formula that counts Total Attendance for the semester (Jan-May) but I
am struggling to write a formula that counts total attendance for a specific month (eg Feb). See screenshot below and file attached. (PS the dates on the register are dynamic)
Class Register.PNG
Bookmarks