Ravi Sir's Cards › Excel
Day-care Management System in Excel (card 1 of 2)
Revision card 1 for Day-care Management System in Excel: Fee due date: =B4+B7-1 gives 07-10-2026; Days present: =COUNTIFS(Attendance!$B$5:$B$5000,A5) gives 14; Late pickup total: =SUMIFS(Attendance!$G$5:$G$5000,Attendance!$B$5:$B$5000,A5) gives ₹400. Includes an example data table.
Read card text
What this card says
1 for Day-care Management System in Excel: Fee due date: =B4+B7-1 gives 07-10-2026
Days present: =COUNTIFS(Attendance!$B$5:$B$5000,A5) gives 14
Late pickup total: =SUMIFS(Attendance!$G$5:$G$5000,Attendance!$B$5:$B$5000,A5) gives ₹400. Includes an
Example
data table
Learn this in the lesson: Day-care Management System in Excel: Children, Daily Attendance, Late Pickup Charges, Monthly Fees and Fee Bill