Attendance Tracker

Hi Champs,

I have a worksheet with 30 tabs (current month's date) with name, id and attendance.

Attendance is marked as "yes" if they are present and left as blank if they are absent.

i need a macro to calculate all the person's attendance in a seperate worksheet in any business day. for example if i want to calculate from 1st to 15 month of this month, the macro need to get my input date and output date and generate the result as i said.


Pls help me and i have also attached sample for the reference.

the sample has NOV1 to NOV30 tabs and Output TABAttendance tracker sample.xlsx

yes. i am aware of count function.


.but the scenario is i may take tracker between 25 th of nov and 30th of december... or any between dates....

so i need a macro to pick..pls help if possible